public ActionResult ExportToTADAReviewNApproval(int page, string groupby, string orderBy, string filter, string tADAAprrovalMonth) { objLoginHelper = (LoginHelper)Session["LogInInformation"]; string reportType = string.Empty; if (objLoginHelper.Location == Helper.Zone) { reportType = Helper.ZonalOffice; } else if (objLoginHelper.Location == Helper.Region) { //reportType = Helper.RegionalOffice; reportType = Helper.AreaOffice; } List <TADADetails> lstTADADetails = new List <TADADetails>(); lstTADADetails = hrmsData.ReviewTADAAmountNApproval(objLoginHelper.LocationCode, reportType, tADAAprrovalMonth); lstTADADetails = (from ss in lstTADADetails select new TADADetails { EmployeeID = ss.EmployeeID, TAAmount = ss.TAAmount, DAAmount = ss.DAAmount, TotalTADAAmount = ss.TotalTADAAmount, EmployeeName = ss.EmployeeName, TotalDaysForTA = ss.TotalDaysForTA, TotalDaysForDA = ss.TotalDaysForDA, ZoneCode = ss.ZoneCode, ZoneName = ss.ZoneName + " [" + ss.ZoneCode + "]", RegionCode = ss.RegionCode, RegionName = ss.RegionName + " [" + ss.RegionCode + "]", ProgramName = ss.ProgramName, AreaName = ss.AreaName, UnitCode = ss.UnitCode, UnitName = ss.UnitName + " [" + ss.UnitCode + "]", TotalCollection = ss.TotalCollection, TotalSales = ss.TotalSales, DesignationName = ss.DesignationName, DepartmentName = ss.DepartmentName, JoiningDate = ss.JoiningDate, TADAMonth = ss.TADAMonth }).ToList(); MemoryStream output = new MemoryStream(); StreamWriter writer = new StreamWriter(output, Encoding.UTF8); writer.Write("Employee ID,"); writer.Write("Employee Name,"); writer.Write("Designation,"); writer.Write("Department,"); writer.Write("Work Station,"); writer.Write("Program Name,"); writer.Write("Area Name,"); //writer.Write("Region,"); //writer.Write("Zone,"); writer.Write("Date of Joining,"); //writer.Write("TA/DA Month,"); writer.Write("From Date,"); writer.Write("To Date,"); writer.Write("TA Amount,"); writer.Write("Total Days For TA,"); writer.Write("DA Amount,"); writer.Write("Total Days For DA,"); writer.Write("Total (TA+DA),"); writer.Write("Total Sales,"); writer.Write("Total Collection,"); writer.Write("Remarks"); writer.WriteLine(); foreach (TADADetails cr in lstTADADetails) { writer.Write(cr.EmployeeID); writer.Write(","); writer.Write("\""); writer.Write(cr.EmployeeName); writer.Write("\""); writer.Write(","); writer.Write("\""); writer.Write(cr.DesignationName); writer.Write("\""); writer.Write(","); writer.Write("\""); writer.Write(cr.DepartmentName); writer.Write("\""); writer.Write(","); writer.Write("\""); writer.Write(cr.UnitName); writer.Write("\""); writer.Write(","); writer.Write("\""); writer.Write(cr.ProgramName); writer.Write("\""); writer.Write(","); writer.Write("\""); writer.Write(cr.AreaName); writer.Write("\""); writer.Write(","); //writer.Write("\""); //writer.Write(cr.RegionName); //writer.Write("\""); //writer.Write(","); //writer.Write("\""); //writer.Write(cr.ZoneName); //writer.Write("\""); //writer.Write(","); writer.Write("\""); writer.Write(cr.JoiningDate.ToString("dd-MMM-yyyy")); writer.Write("\""); writer.Write(","); writer.Write("\""); writer.Write(Helper.DateFrom(cr.TADAMonth).ToString("dd-MMM-yyyy")); writer.Write("\""); writer.Write(","); writer.Write("\""); writer.Write(Helper.DateTo(cr.TADAMonth).ToString("dd-MMM-yyyy")); writer.Write("\""); writer.Write(","); //writer.Write("\""); //writer.Write(cr.TADAMonth); //writer.Write("\""); //writer.Write(","); writer.Write("\""); writer.Write(((decimal)cr.TAAmount).ToString("0")); writer.Write("\""); writer.Write(","); writer.Write("\""); writer.Write(cr.TotalDaysForTA); writer.Write("\""); writer.Write(","); writer.Write("\""); writer.Write(((decimal)cr.DAAmount).ToString("0")); writer.Write("\""); writer.Write(","); writer.Write("\""); writer.Write(cr.TotalDaysForDA); writer.Write("\""); writer.Write(","); writer.Write("\""); writer.Write(((decimal)cr.TotalTADAAmount).ToString("0")); writer.Write("\""); writer.Write(","); writer.Write("\""); writer.Write(cr.TotalSales); writer.Write("\""); writer.Write(","); writer.Write("\""); writer.Write(((decimal)cr.TotalCollection).ToString("0")); writer.Write("\""); writer.Write(","); writer.Write("\""); writer.Write(cr.Reason); writer.Write("\""); writer.WriteLine(); } writer.Flush(); output.Position = 0; return(File(output, "text/comma-separated-values", "RSF-TADAReviewNApprovalDetails.xls")); }