public ActionResult TableServerSideGetData(int pageIndex, int pageSize, int month, int year, int userid, int status, string filter = "")
{
var db = new RecommendedListDAL();
ViewBag.pageIndex = pageIndex;
ViewBag.pageSize = pageSize;
int?total = 0;
int CurrentType = 0;
var baseListParam = new BaseListParam()
{
FilterField = filter,
OrderByField = "",
UserType = Global.CurrentUser.RoleId,
UserId = Global.CurrentUser.LoginUserId,
DeptId = Global.CurrentUser.OrganizationUnitID,
PageIndex = pageIndex,
PageSize = pageSize,
LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
};
var result = db.GetWorkingDaySupplementManager(baseListParam, month, year, CurrentType, status, out total);
var lstTotal = new TableColumnsTotalModel();
lstTotal.Total1 = "15";
lstTotal.Total2 = "25";
lstTotal.Total3 = "35";
return(Content(JsonConvert.SerializeObject(new
{
employees = result,
totalCount = total,
lstTotal = lstTotal,
userid = baseListParam.UserId
})));
}
public ActionResult RecommendedListExportExcel(int pageIndex, int pageSize, int month, int year, int status, string filter = "")
{
var baseListParam = new BaseListParam()
{
FilterField = filter,
OrderByField = "",
UserType = Global.CurrentUser.RoleId,
UserId = Global.CurrentUser.LoginUserId,
DeptId = Global.CurrentUser.OrganizationUnitID,
PageIndex = 1,
PageSize = 10000,
LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
};
DataTable dt = new DataTable("Grid");
dt.Columns.AddRange(new DataColumn[16]
{
new DataColumn(AppRes.Timekeeping_CreateName),
new DataColumn(AppRes.Timekeeping),
new DataColumn(AppRes.E_CreatedDate),
new DataColumn(AppRes.HR_FromHour),
new DataColumn(AppRes.HR_ToHour),
new DataColumn(AppRes.Timekeeping_TimeOffTitle),
new DataColumn(AppRes.HR_WorkingDaySupplement),
new DataColumn(AppRes.MultiplierFactor),
new DataColumn(AppRes.Promotion_Status),
new DataColumn(AppRes.Timekeeping_Reason),
new DataColumn(AppRes.ContactName),
new DataColumn(AppRes.Purpose),
new DataColumn(AppRes.Timekeeping_Note),
new DataColumn(AppRes.Promotion_CreatedOn),
new DataColumn(AppRes.HR_ManagerNote),
new DataColumn(AppRes.HR_HRNote),
});
dt.Columns[0].DataType = typeof(string);
dt.Columns[1].DataType = typeof(string);
dt.Columns[2].DataType = typeof(string);
dt.Columns[3].DataType = typeof(string);
dt.Columns[4].DataType = typeof(string);
dt.Columns[5].DataType = typeof(string);
dt.Columns[6].DataType = typeof(double);
dt.Columns[7].DataType = typeof(int);
dt.Columns[8].DataType = typeof(string);
dt.Columns[9].DataType = typeof(string);
dt.Columns[10].DataType = typeof(string);
dt.Columns[11].DataType = typeof(string);
dt.Columns[12].DataType = typeof(string);
dt.Columns[13].DataType = typeof(DateTime);
dt.Columns[14].DataType = typeof(string);
dt.Columns[15].DataType = typeof(string);
var db = new RecommendedListDAL();
int?total = 0;
int CurrentType = 0;
int LanguageCode = Global.CurrentUser.CurrentLanguageID;
var lstData = db.GetWorkingDaySupplementManager(baseListParam, month, year, CurrentType, status, out total);
foreach (var item in lstData)
{
dt.Rows.Add(item.StaffName, item.TypeName, item.Date, item.FromTime.HasValue ? item.FromTime.Value.ToString("hh:mm") : string.Empty, item.ToTime.HasValue ? item.ToTime.Value.ToString("hh:mm") : string.Empty, item.HourOff.HasValue ? item.HourOff.Value.ToString("hh:mm") : string.Empty, item.DayOff, item.PercentPayrollID, item.StatusName, item.ReasonTypeName, item.Note, item.CustomerContactName, item.CustomerReasonTypeName, item.CreatedDate, item.ManagerNote, item.HRNote);
}
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", "RecommendedList.xlsx"));
}
