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"));
}
