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