public ActionResult TableServerSideGetData(DateTime?filter1, int pageIndex, int pageSize, string filter = "")
{
var db = new ReportAccountCS_DAL();
int total = 0;
int total1 = 0;
int LanguageCode = Global.CurrentUser.CurrentLanguageID;
var result = db.ReportAccountCS_GetAccountNumber(pageIndex, pageSize, filter, filter1, out total, out total1);
var lstTotal = new TableColumnsTotalModel();
lstTotal.Total1 = "15";
lstTotal.Total2 = "25";
lstTotal.Total3 = "35";
return(Content(JsonConvert.SerializeObject(new
{
employees = result,
totalCount = total,
TotalAccountActive = total1,
lstTotal = lstTotal
})));
}
public ActionResult ReportAccountCSExportExcel(string date)
{
DataTable dt = new DataTable("Grid");
dt.Columns.AddRange(new DataColumn[]
{
new DataColumn(AppRes.ReceipientAccountNumber),
});
dt.Columns[0].DataType = typeof(string);
var db = new ReportAccountCS_DAL();
int total = 0;
int total1 = 0;
int LanguageCode = Global.CurrentUser.CurrentLanguageID;
DateTime dateFormat = DateTime.ParseExact(date, "dd-MM-yyyy", CultureInfo.InvariantCulture);
var lstData = db.ReportAccountCS_GetAccountNumber(1, 100000, string.Empty, dateFormat, out total, out total1);
if (lstData != null && lstData.Count() > 0)
{
foreach (var item in lstData)
{
dt.Rows.Add(item.AccountNumber);
}
}
var wb = new XLWorkbook();
wb.Worksheets.Add(dt);
byte[] data = null;
using (var stream = new MemoryStream())
{
wb.SaveAs(stream);
data = stream.ToArray();
}
return(File(data, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", " AccountNumberCS.xlsx"));
}