public ActionResult TableServerSideGetData(int pageIndex, int pageSize, string filter) { var db = new PaymentProductDAL(); int?total = 0; TableColumnsTotal totalColumns = new TableColumnsTotal(); 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.GetPaymentProduct(baseListParam, out total, out totalColumns); var lstTotal = new TableColumnsTotalModel(); lstTotal.Total1 = "15"; lstTotal.Total2 = "25"; lstTotal.Total3 = "35"; return(Content(JsonConvert.SerializeObject(new { employees = result, totalCount = total, lstTotal = totalColumns, roleid = baseListParam.UserType.ToString() }))); }
public ActionResult TableServerSideGetData(int pageIndex, int pageSize, int month, int year, int userid, int status, string filter = "") { var db = new Timekeeping_ManagerVacationDAL(); ViewBag.pageIndex = pageIndex; ViewBag.pageSize = pageSize; int?total = 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, 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 TableServerSideGetData(int pageIndex = 1, int pageSize = 5, int SessionStaffID = 0, string filter = "") { var db = new SocialInsuranceDetailDAL(); int?total = 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() }; int staffID = 0; int.TryParse(Session["StaffID"].ToString(), out staffID); var result = db.GetSocialInsuranceDetail(baseListParam, out total, SessionStaffID); var lstTotal = new TableColumnsTotalModel(); lstTotal.Total1 = "15"; lstTotal.Total2 = "25"; lstTotal.Total3 = "35"; return(Content(JsonConvert.SerializeObject(new { employees = result, totalCount = total, lstTotal = lstTotal }))); }
public ActionResult TableServerSideGetData(int pageIndex, int pageSize, int SessionStaffID, string filter = "") { var db = new WorkingProcessDAL(); int total = 0; var LanguageID = Global.CurrentLanguage; var RoleId = Global.CurrentUser.RoleId; var UserID = Global.CurrentUser.UserID; var OfficePositionID = Global.CurrentUser.OfficePositionID; int staffID = 0; int.TryParse(Session["StaffID"].ToString(), out staffID); var DeptID = Global.CurrentUser.OrganizationUnitID; var result = db.GetWorkingProcess(pageIndex, pageSize, filter, out total, LanguageID, RoleId, UserID, DeptID, SessionStaffID, OfficePositionID); var lstTotal = new TableColumnsTotalModel(); lstTotal.Total1 = "15"; lstTotal.Total2 = "25"; lstTotal.Total3 = "35"; return(Content(JsonConvert.SerializeObject(new { employees = result, totalCount = total, lstTotal = lstTotal }))); }
public ActionResult TableServerSideGetData(int pageIndex, int pageSize, string filter7, string filter6, string filter = "") { var db = new MergeDAL(); int total = 0; if (filter7 == "") { filter7 = "0"; } if (filter6 == "") { filter6 = "0"; } int LanguageCode = Global.CurrentUser.CurrentLanguageID; var result = db.Merge_GetList(pageIndex, pageSize, filter, LanguageCode, int.Parse(filter7), int.Parse(filter6), 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 }))); }
public ActionResult TableServerSideGetDataAccount(int pageIndex, int pageSize, ListFilterParam list, string filter = "") { var db = new DetailAccountReportDAL(); int?total = 0; TableColumnsTotal totalColumns = new TableColumnsTotal(); 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.ReportMccAccountDetailNew(baseListParam, list, Global.CurrentUser.CurrencyTypeID ?? 0, out total, out totalColumns); var lstTotal = new TableColumnsTotalModel(); return(Content(JsonConvert.SerializeObject(new { employees = result, totalCount = total, lstTotal = totalColumns, roleid = baseListParam.UserType.ToString() }))); }
public ActionResult TableServerSideGetData(int pageIndex, int pageSize, int month, int year, int userid, int status, string filter = "", int bosungcong = 0) { var db = new HR_WorkingDaySupplementDal(); int?total = 0; int quyen = 0; //kiểm tra trang thái được phép duyệt công của tài khoản đăng nhập quyen = db.HR_GetStatusForCheckApproval(Global.CurrentUser.LoginUserId); if (userid == 0) { userid = Global.CurrentUser.LoginUserId; } if (bosungcong == 1) { filter += " and a.StaffID = " + userid + " "; } else if (filter.Contains(" AND a.Status = 0 ") == false) { if (status == 0) { if (quyen == 252) { filter += " and a.Status in (1,6) "; } else { filter += " and a.Status = " + quyen + " "; } } } var baseListParam = new BaseListParam() { FilterField = filter, OrderByField = "", UserType = Global.CurrentUser.RoleId, UserId = userid, DeptId = Global.CurrentUser.OrganizationUnitID, PageIndex = pageIndex, PageSize = pageSize, LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString() }; var result = db.GetHR_WorkingDaySupplement(baseListParam, 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 }))); }
public ActionResult TableServerSideGetData(int pageIndex, int pageSize, string filter = "") { var db = new Sec_ControllerDal(); int total = 0; var result = db.GetSecController(pageIndex, pageSize, filter, 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 }))); }
public ActionResult getSysTableColumnID(int pageIndex, int pageSize, string filter = "") { var db = new Sys_Table_Column_DAL(); int total = 0; var result = db.Get_SyS_Table_CoLumn(pageIndex, pageSize, filter, 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 }))); }
public ActionResult TableServerSideGetData(int pageIndex, int pageSize, string filter = "") { var db = new Config_InsuranceDal(); int total = 0; var result = db.GetListInsurance(pageIndex, pageSize, filter, Global.CurrentLanguage, 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 }))); }
public ActionResult TableServerSideGetData(int pageIndex, int pageSize, string filter = "") { var db = new HR_WorkingDayDAL(); int total = 0; int LanguageCode = Global.CurrentUser.CurrentLanguageID; var result = db.GetHR_WorkingDay(pageIndex, pageSize, filter, out total, LanguageCode); var lstTotal = new TableColumnsTotalModel(); lstTotal.Total1 = "15"; lstTotal.Total2 = "25"; lstTotal.Total3 = "35"; return(Content(JsonConvert.SerializeObject(new { employees = result, totalCount = total, lstTotal = lstTotal }))); }
public ActionResult TableServerSideGetData(int pageIndex, int pageSize, string filter = "") { var db = new StandardSpending_DAL(); int total = 0; int LanguageCode = Global.CurrentLanguage; var result = db.StandardSpending_GetList(pageIndex, pageSize, filter, LanguageCode, 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 }))); }
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 TableServerSideGetData(int pageIndex, int pageSize, string filter = "") { var db = new OrganizationUnitPlan_DAL(); ToTalMonth ToTalMonth = new ToTalMonth(); int total = 0; int Languagecode = Global.CurrentLanguage; var result = db.OrganizationUnitPlan_GetList(pageIndex, pageSize, filter, Languagecode, out total, out ToTalMonth); var lstTotal = new TableColumnsTotalModel(); lstTotal.Total1 = "15"; lstTotal.Total2 = "25"; lstTotal.Total3 = "35"; return(Content(JsonConvert.SerializeObject(new { employees = result, totalCount = total, lstTotal = lstTotal, ToTalMonth = ToTalMonth }))); }
public ActionResult TableServerSideGetData(int pageIndex, int pageSize, string filter = "") { var db = new EmployeeAllowanceDAL(); int total = 0; var LanguageID = Global.CurrentLanguage; var RoleId = Global.CurrentUser.RoleId; var UserID = Global.CurrentUser.UserID; int wpID = 0; var DeptID = Global.CurrentUser.OrganizationUnitID; var result = db.GetEmployeeAllowance(pageIndex, pageSize, filter, out total, LanguageID, RoleId, UserID, DeptID, wpID); var lstTotal = new TableColumnsTotalModel(); lstTotal.Total1 = "15"; lstTotal.Total2 = "25"; lstTotal.Total3 = "35"; return(Content(JsonConvert.SerializeObject(new { employees = result, totalCount = total, lstTotal = lstTotal }))); }