Asp.Net MVC, C#, sql, Jquery, Javascript

<a href="http://localhost:53258/Content/Javascript%20Testing.html" target="_blank" download="a.pdf">Download Now</a>

1.  Create an ASP.Net application and add a class Document. public class Document    {         public int DocId { get; set; }         public string DocName { get; set; }         public byte[] DocContent { get; set; }     } 2.  Create a file of format doc/pdf/rtf etc. and convert the file content to a ByteArray using the following method. Then create an object of type Document and assign the Docname and DocContent property values from filename and filecontent. public Document FileToByteArray(string fileName)        {             byte[] fileContent = null;             System.IO.FileStream fs = new System.IO.FileStream(fileName, System.IO.FileMode.Open, System.IO.FileAccess.Read);  ...

declare @str varchar(50) ='43-2423-4234' select 'XXX-XX-' + RIGHT(@str,4) as MaskedTaxNumber

Download project from below link https://drive.google.com/file/d/1efu6TZvnbUBrgg2gtA-mW-rPq_zg3xRs/view?usp=sharing

CREATE PROCEDURE [dbo].[SPPaging]   @CurrentIndex AS INT,   @PageSize AS INT,   @SortColumn AS VARCHAR(MAX),   @SortOrder AS VARCHAR(10),   @TotalRecord AS INT OUTPUT,   @WhereClause AS VARCHAR(MAX)  AS  BEGIN  BEGIN TRY     DECLARE @LowerBound AS INT,     @UpperBound AS INT,     @Sql AS NVARCHAR(MAX),     @ParmDefinition AS NVARCHAR(MAX);     SET @LowerBound = @CurrentIndex;     SET @UpperBound = (@CurrentIndex - 1) + @PageSize;   BEGIN TRANSACTION          EXEC('SELECT A.* FROM(SELECT ROW_NUMBER() OVER(ORDER BY ' + @SortColumn+ ' ' +  @SortOrder+ ')SrNo,D.Id,      D.FirstName,      D.LastName,     D.CreatedDate     FROM [dbo].[Driver] D     LEFT JOIN [dbo].[Intermediate] I on I.[IntermediateID]=D.[In...

CREATE TABLE [dbo].[TableName](  [ID] [int] IDENTITY(1,1) NOT NULL,  [Name] [nvarchar](250) NOT NULL,  [CreatedDate] [datetime] NULL,  [IsActive] [bit] NULL  CONSTRAINT [PK_TableName] PRIMARY KEY CLUSTERED (  [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ------------------------------------------------------------------------------- INSERT INTO [TableName](Name,CreatedDate, IsActive) Values('Satyendra', GETDATE(),1) INSERT INTO [TableName](Name,CreatedDate, IsActive) Values('Piush', GETDATE(),1) INSERT INTO [TableName](Name,CreatedDate, IsActive) Values('Ankur', GETDATE(),1) INSERT INTO [TableName](Name,CreatedDate, IsActive) Values('Kumar', GETDATE(),1) INSERT INTO [TableName](Name,CreatedDate, IsActive) Values('Patel', GETDATE(),1) INSERT INTO [TableName](Name,CreatedDate, IsActive) Values('Moradiya', GE...

Controller Code public ActionResult IndexTuple()  {      ViewBag.Message = "Welcome to my demo!";      var tupleModel = new Tuple<List<Teacher>, List<Student>>(GetTeachers(), GetStudents());      return View(tupleModel);  } View Code @using MultipleModelInOneView;  @model Tuple <List<Teacher>, List <Student>>  @{      ViewBag.Title = "Home Page";  }  <h2>@ViewBag.Message</h2>  <p><b>Teacher List</b></p>  <table>      <tr>          <th>Id</th>          <th>Code</th>          <th>Name</th>      </tr>      @foreach (Teacher teacher in Model.Item1)      {          <tr>  ...

public Tuple<int, int,string> GetMultiValue() {      return Tuple.Create(1,2,"Test"); }