public ActionResult TableServerSideGetData(int pageIndex, int pageSize, int month, int year, int userid, int status, string filter = "")
{
var db = new TimekeepingDal();
ViewBag.pageIndex = pageIndex;
ViewBag.pageSize = pageSize;
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.GetWorkingDaySupplementManager(baseListParam, month, year, out total, out totalColumns);
return(Content(JsonConvert.SerializeObject(new
{
employees = result,
totalCount = total,
lstTotal = totalColumns,
userid = baseListParam.UserId
})));
}
public List <PaymentProduct> GetPaymentProductReport(BaseListParam listParam, ListFilterParam listFilterParam, out int?totalRecord, out TableColumnsTotal totalColumns)
{
try
{
var param = new DynamicParameters();
param.Add("@FilterField", listParam.FilterField);
param.Add("@OrderByField", listParam.OrderByField);
param.Add("@PageIndex", listParam.PageIndex);
param.Add("@PageSize", listParam.PageSize);
param.Add("@startdate", listFilterParam.FromDate);
param.Add("@enddate", listFilterParam.ToDate);
param.Add("@UserId", listParam.UserId);
param.Add("@RoleId", listParam.UserType);
param.Add("@DeptId", listParam.DeptId);
param.Add("@LanguageID", listParam.LanguageCode);
param.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
param.Add("@Total1", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total2", dbType: DbType.Double, direction: ParameterDirection.Output);
var list = UnitOfWork.Procedure <PaymentProduct>("PaymentProductReportGets", param).ToList();
param = HttpRuntime.Cache.Get("PaymentProductReportGets-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + HRM.Common.Global.CurrentUser.UserID + "-output") as DynamicParameters;
totalRecord = param.GetDataOutput <int>("@TotalRecord");
totalColumns = new TableColumnsTotal();
totalColumns.Total1 = param.GetDataOutput <double>("@Total1").ToString();
totalColumns.Total2 = param.GetDataOutput <double>("@Total2").ToString();
return(list);
}
catch (Exception ex)
{
totalRecord = 0;
totalColumns = new TableColumnsTotal();
return(new List <PaymentProduct>());
}
}
public ActionResult TableServerSideGetData(int pageIndex, string pageSize, ListFilterParam list, string filter = "")
{
filter = filter.Replace("!!", "%");
var db = new HistoryUpdateSpendingDAL();
ViewBag.pageIndex = pageIndex;
ViewBag.pageSize = pageSize;
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 = Int32.Parse(pageSize),
LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
};
var result = db.getHistoryUpdateSpending(baseListParam, list, Global.CurrentUser.CurrencyTypeID ?? 0, out total, out totalColumns);
return(Content(JsonConvert.SerializeObject(new
{
employees = result,
totalCount = total,
lstTotal = totalColumns,
userid = baseListParam.UserId
})));
}
public List <ShareRateSalaryCost> GetShareRateSalaryCostByStaff(BaseListParam listParam, int isExcel, ListFilterParam listFilterParam, out int?totalRecord, out TableColumnsTotal totalColumns)
{
try
{
var param = new DynamicParameters();
param.Add("@FilterField", listParam.FilterField);
param.Add("@OrderByField", listParam.OrderByField);
param.Add("@PageNumber", listParam.PageIndex);
param.Add("@PageSize", listParam.PageSize);
param.Add("@UserId", listParam.UserId);
param.Add("@RoleID", listParam.UserType);
param.Add("@LanguageID", listParam.LanguageCode);
param.Add("@FromDate", listFilterParam.FromDate);
param.Add("@ToDate", listFilterParam.ToDate);
param.Add("@IsExcel", isExcel);
param.Add("@Total1", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
var list = UnitOfWork.Procedure <ShareRateSalaryCost>("GetShareRateSalaryCostByStaff", param).ToList();
param = HttpRuntime.Cache.Get("GetShareRateSalaryCostByStaff-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + HRM.Common.Global.CurrentUser.UserID + "-output") as DynamicParameters;
totalColumns = new TableColumnsTotal();
totalRecord = param.GetDataOutput <int>("@TotalRecord");
totalColumns.Total1 = param.GetDataOutput <double>("@Total1").ToString();
return(list);
}
catch (Exception ex)
{
totalColumns = new TableColumnsTotal();
totalRecord = 0;
return(new List <ShareRateSalaryCost>());
}
}
public List <DetailReportAccount> ReportMccAccountDetailNew(BaseListParam listParam, ListFilterParam filterParam, int currencyID, out int?totalRecord, out TableColumnsTotal totalColumns)
{
try
{
var param = new DynamicParameters();
param.Add("@FilterField", listParam.FilterField);
param.Add("@OrderBy", listParam.OrderByField);
param.Add("@PageNumber", listParam.PageIndex);
param.Add("@PageSize", listParam.PageSize);
param.Add("@UserId", listParam.UserId);
param.Add("@DateFrom", filterParam.FromDate);
param.Add("@DateTo", filterParam.ToDate);
param.Add("@UserType", listParam.UserType);
param.Add("@CurrencyID", currencyID);
param.Add("@isExcel", false);
param.Add("@LanguageID", listParam.LanguageCode);
param.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
param.Add("@Total1", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total2", dbType: DbType.Double, direction: ParameterDirection.Output);
var list = UnitOfWork.Procedure <DetailReportAccount>("ReportMccAccountDetailNew", param).ToList();
param = HttpRuntime.Cache.Get("ReportMccAccountDetailNew-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + HRM.Common.Global.CurrentUser.UserID + "-output") as DynamicParameters;
totalRecord = param.GetDataOutput <int>("@TotalRecord");
totalColumns = new TableColumnsTotal();
totalColumns.Total1 = param.GetDataOutput <double>("@Total1").ToString();
totalColumns.Total2 = param.GetDataOutput <double>("@Total2").ToString();
return(list);
}
catch (Exception ex)
{
totalRecord = 0;
totalColumns = new TableColumnsTotal();
return(new List <DetailReportAccount>());
}
}
public ActionResult TableServerSideGetData(int pageIndex, int pageSize, string filter = "")
{
var db = new SalaryDAL();
ViewBag.pageIndex = pageIndex;
ViewBag.pageSize = pageSize;
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()
};
int type = 2; //lương theo phòng ban
var result = db.GetSalary(baseListParam, type, out total, out totalColumns);
return(Content(JsonConvert.SerializeObject(new
{
employees = result,
totalCount = total,
lstTotal = totalColumns,
staffID = baseListParam.UserId
})));
}
public List <MCCAccountExclude> GetMCCAccountExclude(BaseListParam listParam, out int?totalRecord, out TableColumnsTotal totalColumns)
{
try
{
var param = new DynamicParameters();
param.Add("@FilterField", listParam.FilterField);
param.Add("@OrderByField", listParam.OrderByField);
param.Add("@PageIndex", listParam.PageIndex);
param.Add("@PageSize", listParam.PageSize);
param.Add("@UserId", listParam.UserId);
param.Add("@RoleId", listParam.UserType);
param.Add("@DeptId", listParam.DeptId);
param.Add("@LanguageID", listParam.LanguageCode);
param.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
var list = UnitOfWork.Procedure <MCCAccountExclude>("GetMCCAccountExclude", param).ToList();
param = HttpRuntime.Cache.Get("GetMCCAccountExclude-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + HRM.Common.Global.CurrentUser.UserID + "-output") as DynamicParameters;
totalRecord = param.GetDataOutput <int>("@TotalRecord");
totalColumns = new TableColumnsTotal();
return(list);
}
catch (Exception ex)
{
totalRecord = 0;
totalColumns = new TableColumnsTotal();
return(new List <MCCAccountExclude>());
}
}
public List <CustomerTransferHistory> getCustomerTransferHistoryForExcel(BaseListParam listParam, ListFilterParam listFilterParam, int currencyID, out int?totalRecord, out TableColumnsTotal totalColumns)
{
try
{
var param = new DynamicParameters();
param.Add("@FilterField", listParam.FilterField);
param.Add("@OrderByField", listParam.OrderByField);
param.Add("@PageNumber", listParam.PageIndex);
param.Add("@PageSize", listParam.PageSize);
param.Add("@UserId", listParam.UserId);
param.Add("@RoleID", listParam.UserType);
//param.Add("@OrganizationUnitId", listParam.DeptId);
param.Add("@isExcel", 1);
param.Add("@CurrencyID", currencyID);
param.Add("@LanguageID", listParam.LanguageCode);
param.Add("@FromDate", listFilterParam.FromDate);
param.Add("@ToDate", listFilterParam.ToDate);
//param.Add("@ReportType", listFilterParam.filter7);
param.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
var list = UnitOfWork.Procedure <CustomerTransferHistory>("sp_HistoryTransferCustomer", param).ToList();
param = HttpRuntime.Cache.Get("sp_HistoryTransferCustomer-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + HRM.Common.Global.CurrentUser.UserID + "-output") as DynamicParameters;
totalRecord = param.GetDataOutput <int>("@TotalRecord");
totalColumns = new TableColumnsTotal();
return(list);
}
catch (Exception ex)
{
totalRecord = 0;
totalColumns = new TableColumnsTotal();
return(new List <CustomerTransferHistory>());
}
}
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 List <TimeKeeping_TimeSSN> GetTimeKeepingMachine(BaseListParam listParam, int month, int year, out TableColumnsTotal totalColumns)
{
try
{
var param = new DynamicParameters();
if (listParam.FilterField != "" && listParam.FilterField != null)
{
param.Add("@UserId", listParam.FilterField);
}
else
{
param.Add("@UserId", listParam.UserId);
}
param.Add("@Month", month);
param.Add("@Year", year);
param.Add("@TotalDay", 0, dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@TotalHourLate", "", dbType: DbType.String, direction: ParameterDirection.Output);
param.Add("@TotalHourEarly", "", dbType: DbType.String, direction: ParameterDirection.Output);
var list = UnitOfWork.Procedure <TimeKeeping_TimeSSN>("Get_TimeKeepingMachine", param).ToList();
totalColumns = new TableColumnsTotal();
totalColumns.Total1 = param.GetDataOutput <double>("@TotalDay").ToString();
totalColumns.Total2 = param.GetDataOutput <string>("@TotalHourLate");
totalColumns.Total3 = param.GetDataOutput <string>("@TotalHourEarly");
return(list);
}
catch (Exception ex)
{
totalColumns = new TableColumnsTotal();
return(new List <TimeKeeping_TimeSSN>());
}
}
public List <ReportAccountByStaff> ExportReportAccountByStaff(BaseListParam listParam, ListFilterParam listFilterParam, out int?totalRecord, out TableColumnsTotal totalColumns)
{
try
{
var param = new DynamicParameters();
param.Add("@FilterField", listParam.FilterField);
param.Add("@OrderByField", listParam.OrderByField);
param.Add("@UserId", listParam.UserId);
param.Add("@RoleID", listParam.UserType);
param.Add("@OrganizationUnitId", listParam.DeptId);
param.Add("@isExcel", 1);
param.Add("@LanguageID", listParam.LanguageCode);
param.Add("@FromDate", listFilterParam.FromDate);
param.Add("@ToDate", listFilterParam.ToDate);
param.Add("@ReportType", listFilterParam.filter7);
param.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
var list = UnitOfWork.Procedure <ReportAccountByStaff>("ReportAccountByStaff", param).ToList();
param = HttpRuntime.Cache.Get("ReportAccountByStaff-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + HRM.Common.Global.CurrentUser.UserID + "-output") as DynamicParameters;
totalRecord = list.Count;
totalColumns = new TableColumnsTotal();
return(list);
}
catch (Exception ex)
{
totalRecord = 0;
totalColumns = new TableColumnsTotal();
return(new List <ReportAccountByStaff>());
}
}
public ActionResult GetShareRateSalaryCostByDept(int pageIndex, string pageSize, ListFilterParam list, string filter = "")
{
filter = filter.Replace("!!", "%");
var db = new ShareRateSalaryCostDAL();
ViewBag.pageIndex = pageIndex;
ViewBag.pageSize = pageSize;
int?total = 0;
TableColumnsTotal totalColumns = new TableColumnsTotal();
var baseListParam = new BaseListParam()
{
FilterField = filter,
OrderByField = "",
UserType = Global.CurrentUser.RoleId,
UserId = Global.CurrentUser.UserID,
DeptId = Global.CurrentUser.OrganizationUnitID,
PageIndex = pageIndex,
PageSize = Int32.Parse(pageSize),
LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
};
var result = db.GetShareRateSalaryCostByDept(baseListParam, 0, list, out total, out totalColumns);
return(Content(JsonConvert.SerializeObject(new
{
employees = result,
totalCount = total,
lstTotal = totalColumns,
userid = baseListParam.UserId
})));
}
public ActionResult GetListReopenCampaign(int pageIndex, string pageSize, ListFilterParam list, string filter = "")
{
filter = filter.Replace("!!", "%");
var db = new CampaignDAL();
ViewBag.pageIndex = pageIndex;
ViewBag.pageSize = pageSize;
int?total = 0;
if (list.filter7 == "1" && filter.Split('=').Count() > 1)
{
filter = filter.Replace(filter.Split('=')[filter.Split('=').Count() - 1], "1");
}
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 = Int32.Parse(pageSize),
LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
};
var result = db.GetListReopenCampaign(baseListParam, list, out total);
return(Content(JsonConvert.SerializeObject(new
{
employees = result,
totalCount = total,
lstTotal = totalColumns,
userid = baseListParam.UserId
})));
}
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 Report_L_By_Department_BDX(int pageIndex, int pageSize, string filter = "", string startdate2 = "", string enddate2 = "")
{
var db = new ReportLDAL();
ViewBag.pageIndex = pageIndex;
ViewBag.pageSize = pageSize;
int?total = 0;
TableColumnsTotal totalColumns = new TableColumnsTotal();
var baseListParam = new BaseListParam()
{
FilterField = filter,
OrderByField = "",
UserType = Global.CurrentUser.RoleId,
UserId = Global.CurrentUser.LoginUserId,
PageIndex = pageIndex,
PageSize = pageSize,
LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
};
var result = db.Report_L_By_Department_BDX(baseListParam, startdate2, enddate2, out total, out totalColumns);
return(Content(JsonConvert.SerializeObject(new
{
employees = result,
totalCount = total,
lstTotal = totalColumns,
userid = baseListParam.UserId
})));
}
public List <HR_WorkingDaySummary> GetHR_WorkingDaySummary(BaseListParam listParam, out TableColumnsTotal totalColumns, int month, int year)
{
try
{
var param = new DynamicParameters();
param.Add("@Month", month);
param.Add("@Year", year);
if (listParam.FilterField != "" && listParam.FilterField != null && listParam.FilterField != "0")
{
param.Add("@UserId", listParam.FilterField);
}
else
{
param.Add("@UserId", listParam.UserId);
}
param.Add("@TotalDay", 0, DbType.Double, ParameterDirection.InputOutput);
param.Add("@TotalFurlough", 0, DbType.Double, ParameterDirection.InputOutput);
param.Add("@TotalOvertime", 0, DbType.Double, ParameterDirection.InputOutput);
param.Add("@TotalWorkingDaySupplement", 0, DbType.Double, ParameterDirection.InputOutput);
param.Add("@TotalWorkingDayLeave", 0, DbType.Double, ParameterDirection.InputOutput);
param.Add("@SumTotalWorkingDay", 0, DbType.Double, ParameterDirection.InputOutput);
param.Add("@TotalHourLate", "", DbType.String, ParameterDirection.InputOutput);
param.Add("@TotalHourEarly", "", DbType.String, ParameterDirection.InputOutput);
param.Add("@TotalHour", "", DbType.String, ParameterDirection.InputOutput);
var list = UnitOfWork.Procedure <HR_WorkingDaySummary>("HR_WorkingDaySummary_Get", param).ToList();
param = HttpRuntime.Cache.Get("HR_WorkingDaySummary_Get-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + HRM.Common.Global.CurrentUser.UserID + "-output") as DynamicParameters;
totalColumns = new TableColumnsTotal();
totalColumns.Total1 = param.GetDataOutput <double>("@TotalDay").ToString();
totalColumns.Total2 = param.GetDataOutput <double>("@TotalFurlough").ToString();
totalColumns.Total3 = param.GetDataOutput <double>("@TotalOvertime").ToString();
totalColumns.Total4 = param.GetDataOutput <double>("@TotalWorkingDaySupplement").ToString();
totalColumns.Total5 = param.GetDataOutput <double>("@TotalWorkingDayLeave").ToString();
totalColumns.Total6 = param.GetDataOutput <double>("@SumTotalWorkingDay").ToString();
totalColumns.Total7 = param.GetDataOutput <string>("@TotalHourLate");
totalColumns.Total8 = param.GetDataOutput <string>("@TotalHourEarly");
totalColumns.Total9 = param.GetDataOutput <string>("@TotalHour");
return(list);
}
catch (Exception ex)
{
totalColumns = new TableColumnsTotal();
return(new List <HR_WorkingDaySummary>());
}
}
public ActionResult TableServerSideGetData(int pageIndex, int pageSize, ListFilterParam list, string filter = "")
{
if (Global.CurrentUser.OfficePositionID == 250 || Global.CurrentUser.OfficePositionID == 251 ||
Global.CurrentUser.OfficePositionID == 252 || Global.CurrentUser.OfficePositionID == 253 ||
Global.CurrentUser.OfficePositionID == 254 || Global.CurrentUser.RoleId == 1 ||
Global.CurrentUser.RoleId == 11)
{
list.filter7 = list.filter7;
}
else
{
list.filter7 = "2";
}
filter = filter + (!String.IsNullOrEmpty(list.filter11) ? (!String.IsNullOrEmpty(filter.Trim()) ? " AND " : "") + " OrganizationUnitName LIKE N'%" + list.filter11 + "%'" : "");
filter = filter + (!String.IsNullOrEmpty(list.filter12) ? (!String.IsNullOrEmpty(filter.Trim()) ? " AND " : "") + " StaffName LIKE N'%" + list.filter12 + "%'" : "");
filter = filter.Replace("!!", "%");
var db = new PerformanceReportDAL();
ViewBag.pageIndex = pageIndex;
ViewBag.pageSize = pageSize;
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.GetPerformanceReport(baseListParam, list, out total, out totalColumns);
return(Content(JsonConvert.SerializeObject(new
{
employees = result,
totalCount = total,
lstTotal = totalColumns,
userid = baseListParam.UserId
})));
}
public List <ReportIncreaseSpending> GetReportIncreaseSpending(BaseListParam listParam, ListFilterParam listFilterParam, out int?totalRecord, out TableColumnsTotal totalColumns)
{
try
{
var param = new DynamicParameters();
param.Add("@FilterField", listParam.FilterField);
param.Add("@OrderByField", listParam.OrderByField);
param.Add("@PageNumber", listParam.PageIndex);
param.Add("@PageSize", listParam.PageSize);
param.Add("@UserId", listParam.UserId);
param.Add("@RoleID", listParam.UserType);
param.Add("@OrganizationUnitId", listParam.DeptId);
param.Add("@isExcel", 0);
param.Add("@LanguageID", listParam.LanguageCode);
param.Add("@FromDate", listFilterParam.FromDate);
param.Add("@ToDate", listFilterParam.ToDate);
param.Add("@ReportType", listFilterParam.filter7);
param.Add("@Period", listFilterParam.Period);
param.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
param.Add("@Total1", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total2", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total3", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total4", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total5", dbType: DbType.Double, direction: ParameterDirection.Output);
var list = UnitOfWork.Procedure <ReportIncreaseSpending>("ReportIncreaseSpending", param).ToList();
param = HttpRuntime.Cache.Get("ReportIncreaseSpending-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + HRM.Common.Global.CurrentUser.UserID + "-output") as DynamicParameters;
totalRecord = param.GetDataOutput <int>("@TotalRecord");
totalColumns = new TableColumnsTotal();
totalColumns.Total1 = param.GetDataOutput <double>("@Total1").ToString();
totalColumns.Total2 = param.GetDataOutput <double>("@Total2").ToString();
totalColumns.Total3 = param.GetDataOutput <double>("@Total3").ToString();
totalColumns.Total4 = param.GetDataOutput <double>("@Total4").ToString();
totalColumns.Total5 = param.GetDataOutput <double>("@Total5").ToString();
return(list);
}
catch (Exception ex)
{
totalRecord = 0;
totalColumns = new TableColumnsTotal();
return(new List <ReportIncreaseSpending>());
}
}
public List <HR_WorkingDaySummary> GetWorkingDaySupplementManager(BaseListParam listParam, int month, int year, out int?totalRecord, out TableColumnsTotal totalColumns)
{
try {
var param = new DynamicParameters();
param.Add("@FilterField", listParam.FilterField?.Replace("undefined", ""));
param.Add("@OrderByField", listParam.OrderByField);
param.Add("@PageIndex", listParam.PageIndex);
param.Add("@PageSize", listParam.PageSize);
param.Add("@UserId", listParam.UserId);
param.Add("@RoleId", listParam.UserType);
param.Add("@LanguageId", int.Parse(listParam.LanguageCode));
param.Add("@Month", month);
param.Add("@year", year);
param.Add("@OrganizationUnitID", listParam.DeptId);
param.Add("@TotalRecord", dbType: DbType.Int32, direction: ParameterDirection.Output);
param.Add("@Total1", 0, dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total2", 0, dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total3", 0, dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total4", 0, dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total5", 0, dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total6", 0, dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total7", 0, dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total8", 0, dbType: DbType.Double, direction: ParameterDirection.Output);
var list = UnitOfWork.Procedure <HR_WorkingDaySummary>("HR_WorkingDaySummary_GetManager", param).ToList();
param = HttpRuntime.Cache.Get("HR_WorkingDaySummary_GetManager-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + HRM.Common.Global.CurrentUser.UserID + "-output") as DynamicParameters;
totalRecord = param.GetDataOutput <int>("@TotalRecord");
totalColumns = new TableColumnsTotal();
totalColumns.Total1 = param.GetDataOutput <double>("@Total1").ToString();
//totalColumns.Total2 = param.GetDataOutput<double>("@Total2").ToString();
totalColumns.Total3 = param.GetDataOutput <double>("@Total3").ToString();
totalColumns.Total4 = param.GetDataOutput <double>("@Total4").ToString();
totalColumns.Total5 = param.GetDataOutput <double>("@Total5").ToString();
totalColumns.Total6 = param.GetDataOutput <double>("@Total6").ToString();
totalColumns.Total7 = param.GetDataOutput <double>("@Total7").ToString();
//totalColumns.Total8 = param.GetDataOutput<double>("@Total8").ToString();
return(list);
}
catch (Exception ex)
{
totalRecord = 0;
totalColumns = new TableColumnsTotal();
return(new List <HR_WorkingDaySummary>());
}
}
public ActionResult TableServerSideGetData(int pageIndex, int pageSize, string filter = "")
{
var db = new StaffPlanFundRateDAL();
int total = 0;
TableColumnsTotal TableColumnsTotal = new TableColumnsTotal();
int Languagecode = Global.CurrentLanguage;
var result = db.StaffPlanFundRate_GetList(pageIndex, pageSize, filter, Languagecode, out total, out TableColumnsTotal);
var lstTotal = new TableColumnsTotalModel();
lstTotal.Total1 = "15";
lstTotal.Total2 = "25";
lstTotal.Total3 = "35";
return(Content(JsonConvert.SerializeObject(new
{
employees = result,
totalCount = total,
lstTotal = lstTotal,
TotalQuarter = TableColumnsTotal
})));
}
public List <StaffPlanFundRateModel> StaffPlanFundRate_GetList(int pageNumber, int pageSize, string filter, int LanguageCode, out int total, out TableColumnsTotal totalColumns)
{
try
{
var param = new DynamicParameters();
param.Add("@FilterField", filter);
param.Add("@OrderBy", "");
param.Add("@PageNumber", pageNumber);
param.Add("@PageSize", pageSize);
param.Add("@Type", 1);
param.Add("@LanguageID", LanguageCode);
param.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
param.Add("@TotalRecordQ1", 0, DbType.Double, ParameterDirection.InputOutput);
param.Add("@TotalRecordQ2", 0, DbType.Double, ParameterDirection.InputOutput);
param.Add("@TotalRecordQ3", 0, DbType.Double, ParameterDirection.InputOutput);
param.Add("@TotalRecordQ4", 0, DbType.Double, ParameterDirection.InputOutput);
param.Add("@TotalRecordSum", 0, DbType.Double, ParameterDirection.InputOutput);
var list = UnitOfWork.Procedure <StaffPlanFundRateModel>("StaffPlanFundRate_GetList", param).ToList();
var userId = Global.CurrentUser.UserID;
param = HttpRuntime.Cache.Get("StaffPlanFundRate_GetList-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + userId + "-output") as DynamicParameters;
total = param.GetDataOutput <int>("@TotalRecord");
totalColumns = new TableColumnsTotal();
totalColumns.TotalQ1 = param.GetDataOutput <double>("@TotalRecordQ1").ToString();
totalColumns.TotalQ2 = param.GetDataOutput <double>("@TotalRecordQ2").ToString();
totalColumns.TotalQ3 = param.GetDataOutput <double>("@TotalRecordQ3").ToString();
totalColumns.TotalQ4 = param.GetDataOutput <double>("@TotalRecordQ4").ToString();
totalColumns.TotalQuaterSum = param.GetDataOutput <double>("@TotalRecordSum").ToString();
return(list);
}
catch (Exception ex)
{
total = 0;
totalColumns = new TableColumnsTotal();
return(null);
}
finally
{
//UnitOfWork.ConnectionString = null;
}
}
public List <ReportL> Report_L_By_Department_BDX(BaseListParam listParam, string startdate, string enddate, out int?totalRecord, out TableColumnsTotal totalColumns)
{
try
{
DateTime dt = DateTime.ParseExact(startdate, "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture);
startdate = dt.ToString("yyyy-MM-dd HH:mm:ss");
DateTime dt1 = DateTime.ParseExact(enddate, "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture);
enddate = dt1.ToString("yyyy-MM-dd HH:mm:ss");
var param = new DynamicParameters();
param.Add("@FilterField", listParam.FilterField);
param.Add("@OrderBy", listParam.OrderByField);
param.Add("@PageNumber", listParam.PageIndex);
param.Add("@PageSize", listParam.PageSize);
param.Add("@UserType", listParam.UserType);
param.Add("@UserId", listParam.UserId);
param.Add("@LanguageId", listParam.LanguageCode);
param.Add("@startdate", startdate);
param.Add("@enddate", enddate);
param.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
param.Add("@Total1", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total2", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total3", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total4", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total5", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total6", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total7", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total8", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total9", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total10", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total11", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total12", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total13", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total14", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total15", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total16", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total17", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total18", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total19", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total20", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total21", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total22", dbType: DbType.Double, direction: ParameterDirection.Output);
var list = UnitOfWork.Procedure <ReportL>("Report_L_By_Department_BDX", param).ToList();
param = HttpRuntime.Cache.Get("Report_L_By_Department_BDX-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + HRM.Common.Global.CurrentUser.UserID + "-output") as DynamicParameters;
totalRecord = param.GetDataOutput <int>("@TotalRecord");
totalColumns = new TableColumnsTotal();
totalColumns.Total1 = param.GetDataOutput <double>("@Total1").ToString();
totalColumns.Total2 = param.GetDataOutput <double>("@Total2").ToString();
totalColumns.Total3 = param.GetDataOutput <double>("@Total3").ToString();
totalColumns.Total4 = param.GetDataOutput <double>("@Total4").ToString();
totalColumns.Total5 = param.GetDataOutput <double>("@Total5").ToString();
totalColumns.Total6 = param.GetDataOutput <double>("@Total6").ToString();
totalColumns.Total7 = param.GetDataOutput <double>("@Total7").ToString();
totalColumns.Total8 = param.GetDataOutput <double>("@Total8").ToString();
totalColumns.Total9 = param.GetDataOutput <double>("@Total9").ToString();
totalColumns.Total10 = param.GetDataOutput <double>("@Total10").ToString();
totalColumns.Total11 = param.GetDataOutput <double>("@Total11").ToString();
totalColumns.Total12 = param.GetDataOutput <double>("@Total12").ToString();
totalColumns.Total13 = param.GetDataOutput <double>("@Total13").ToString();
totalColumns.Total14 = param.GetDataOutput <double>("@Total14").ToString();
totalColumns.Total15 = param.GetDataOutput <double>("@Total15").ToString();
totalColumns.Total16 = param.GetDataOutput <double>("@Total16").ToString();
totalColumns.Total17 = param.GetDataOutput <double>("@Total17").ToString();
totalColumns.Total18 = param.GetDataOutput <double>("@Total18").ToString();
totalColumns.Total19 = param.GetDataOutput <double>("@Total19").ToString();
totalColumns.Total20 = param.GetDataOutput <double>("@Total20").ToString();
totalColumns.Total21 = param.GetDataOutput <double>("@Total21").ToString();
totalColumns.Total22 = param.GetDataOutput <double>("@Total22").ToString();
return(list);
}
catch (Exception ex)
{
totalRecord = 0;
totalColumns = new TableColumnsTotal();
return(new List <ReportL>());
}
}
public List <ReportsPerformanceBD> ExportExcelPerformanceReport(BaseListParam listParam, ListFilterParam listFilterParam, out int?totalRecord, out TableColumnsTotal totalColumns)
{
try
{
var param = new DynamicParameters();
param.Add("@FilterField", listParam.FilterField);
param.Add("@OrderByField", listParam.OrderByField);
param.Add("@PageNumber", listParam.PageIndex);
param.Add("@PageSize", listParam.PageSize);
param.Add("@UserId", listParam.UserId);
param.Add("@RoleId", listParam.UserType);
param.Add("@OrganizationUnitId", listParam.DeptId);
param.Add("@ViewType", listFilterParam.viewType);
//param.Add("@LanguageID", listParam.LanguageCode);
param.Add("@FromMonth", listFilterParam.filter1);
param.Add("@ToMonth", listFilterParam.filter2);
param.Add("@FromQuarter", listFilterParam.filter3);
param.Add("@ToQuarter", listFilterParam.filter4);
param.Add("@Year", listFilterParam.filter5);
param.Add("@Type", listFilterParam.filter6);
param.Add("@ReportType", listFilterParam.filter7);
param.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
param.Add("@Total1", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total2", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total3", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total4", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total5", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total6", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total7", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total8", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total9", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total10", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total11", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total12", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total13", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total14", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total15", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total16", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total17", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total18", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total19", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total20", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total21", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total22", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total23", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total24", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total25", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total26", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total27", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total28", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total29", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total30", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total31", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total32", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total33", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total34", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total35", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total36", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total37", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total38", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total39", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total40", dbType: DbType.Double, direction: ParameterDirection.Output);
var list = UnitOfWork.Procedure <ReportsPerformanceBD>("ReportsPerformanceBD", param).ToList();
param = HttpRuntime.Cache.Get("ReportsPerformanceBD-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + HRM.Common.Global.CurrentUser.UserID + "-output") as DynamicParameters;
totalRecord = param.GetDataOutput <int>("@TotalRecord");
totalColumns = new TableColumnsTotal();
totalColumns.Total1 = param.GetDataOutput <double>("@Total1").ToString();
totalColumns.Total2 = param.GetDataOutput <double>("@Total2").ToString();
totalColumns.Total3 = param.GetDataOutput <double>("@Total3").ToString();
totalColumns.Total4 = param.GetDataOutput <double>("@Total4").ToString();
totalColumns.Total5 = param.GetDataOutput <double>("@Total5").ToString();
totalColumns.Total6 = param.GetDataOutput <double>("@Total6").ToString();
totalColumns.Total7 = param.GetDataOutput <double>("@Total7").ToString();
totalColumns.Total8 = param.GetDataOutput <double>("@Total8").ToString();
totalColumns.Total9 = param.GetDataOutput <double>("@Total9").ToString();
totalColumns.Total10 = param.GetDataOutput <double>("@Total10").ToString();
totalColumns.Total11 = param.GetDataOutput <double>("@Total11").ToString();
totalColumns.Total12 = param.GetDataOutput <double>("@Total12").ToString();
totalColumns.Total13 = param.GetDataOutput <double>("@Total13").ToString();
totalColumns.Total14 = param.GetDataOutput <double>("@Total14").ToString();
totalColumns.Total15 = param.GetDataOutput <double>("@Total15").ToString();
totalColumns.Total16 = param.GetDataOutput <double>("@Total16").ToString();
totalColumns.Total17 = param.GetDataOutput <double>("@Total17").ToString();
totalColumns.Total18 = param.GetDataOutput <double>("@Total18").ToString();
totalColumns.Total19 = param.GetDataOutput <double>("@Total19").ToString();
totalColumns.Total20 = param.GetDataOutput <double>("@Total20").ToString();
totalColumns.Total21 = param.GetDataOutput <double>("@Total21").ToString();
totalColumns.Total22 = param.GetDataOutput <double>("@Total22").ToString();
totalColumns.Total23 = param.GetDataOutput <double>("@Total23").ToString();
totalColumns.Total24 = param.GetDataOutput <double>("@Total24").ToString();
totalColumns.Total25 = param.GetDataOutput <double>("@Total25").ToString();
totalColumns.Total26 = param.GetDataOutput <double>("@Total26").ToString();
totalColumns.Total27 = param.GetDataOutput <double>("@Total27").ToString();
totalColumns.Total28 = param.GetDataOutput <double>("@Total28").ToString();
totalColumns.Total29 = param.GetDataOutput <double>("@Total29").ToString();
totalColumns.Total30 = param.GetDataOutput <double>("@Total30").ToString();
totalColumns.Total31 = param.GetDataOutput <double>("@Total31").ToString();
totalColumns.Total32 = param.GetDataOutput <double>("@Total32").ToString();
totalColumns.Total33 = param.GetDataOutput <double>("@Total33").ToString();
totalColumns.Total34 = param.GetDataOutput <double>("@Total34").ToString();
totalColumns.Total35 = param.GetDataOutput <double>("@Total35").ToString();
totalColumns.Total36 = param.GetDataOutput <double>("@Total36").ToString();
totalColumns.Total37 = param.GetDataOutput <double>("@Total37").ToString();
totalColumns.Total38 = param.GetDataOutput <double>("@Total38").ToString();
totalColumns.Total39 = param.GetDataOutput <double>("@Total39").ToString();
return(list);
}
catch (Exception e)
{
totalRecord = 0;
totalColumns = new TableColumnsTotal();
return(new List <ReportsPerformanceBD>());
}
}
public List <Salary> ExportExcelSalary(BaseListParam listParam, int type, out int?totalRecord, out TableColumnsTotal totalColumns)
{
try
{
var param = new DynamicParameters();
param.Add("@FilterField", listParam.FilterField);
param.Add("@OrderByField", listParam.OrderByField);
param.Add("@PageIndex", listParam.PageIndex);
param.Add("@PageSize", listParam.PageSize);
param.Add("@UserId", listParam.UserId);
param.Add("@RoleId", listParam.UserType);
param.Add("@DeptId", listParam.DeptId);
param.Add("@isExcel", false);
param.Add("@type", type);
param.Add("@LanguageID", listParam.LanguageCode);
param.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
param.Add("@Total1", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total2", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total3", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total4", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total5", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total6", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total7", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total8", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total9", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total10", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total11", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total12", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total13", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total14", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total15", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total16", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total17", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total18", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total19", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total20", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total21", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total22", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total23", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total24", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total25", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total26", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total27", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total28", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total29", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total30", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total31", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total32", dbType: DbType.Double, direction: ParameterDirection.Output);
var list = UnitOfWork.Procedure <Salary>("Salary_Gets", param).ToList();
param = HttpRuntime.Cache.Get("Salary_Gets-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + HRM.Common.Global.CurrentUser.UserID + "-output") as DynamicParameters;
totalColumns = new TableColumnsTotal();
totalColumns.Total1 = param.GetDataOutput <double>("@Total1").ToString();
totalColumns.Total2 = param.GetDataOutput <double>("@Total2").ToString();
totalColumns.Total3 = param.GetDataOutput <double>("@Total3").ToString();
totalColumns.Total4 = param.GetDataOutput <double>("@Total4").ToString();
totalColumns.Total5 = param.GetDataOutput <double>("@Total5").ToString();
totalColumns.Total6 = param.GetDataOutput <double>("@Total6").ToString();
totalColumns.Total7 = param.GetDataOutput <double>("@Total7").ToString();
totalColumns.Total8 = param.GetDataOutput <double>("@Total8").ToString();
totalColumns.Total9 = param.GetDataOutput <double>("@Total9").ToString();
totalColumns.Total10 = param.GetDataOutput <double>("@Total10").ToString();
totalColumns.Total11 = param.GetDataOutput <double>("@Total11").ToString();
totalColumns.Total12 = param.GetDataOutput <double>("@Total12").ToString();
totalColumns.Total13 = param.GetDataOutput <double>("@Total13").ToString();
totalColumns.Total14 = param.GetDataOutput <double>("@Total14").ToString();
totalColumns.Total15 = param.GetDataOutput <double>("@Total15").ToString();
totalColumns.Total16 = param.GetDataOutput <double>("@Total16").ToString();
totalColumns.Total17 = param.GetDataOutput <double>("@Total17").ToString();
totalColumns.Total18 = param.GetDataOutput <double>("@Total18").ToString();
totalColumns.Total19 = param.GetDataOutput <double>("@Total19").ToString();
totalColumns.Total20 = param.GetDataOutput <double>("@Total20").ToString();
totalColumns.Total21 = param.GetDataOutput <double>("@Total21").ToString();
totalColumns.Total22 = param.GetDataOutput <double>("@Total22").ToString();
totalColumns.Total23 = param.GetDataOutput <double>("@Total23").ToString();
totalColumns.Total24 = param.GetDataOutput <double>("@Total24").ToString();
totalColumns.Total25 = param.GetDataOutput <double>("@Total25").ToString();
totalColumns.Total26 = param.GetDataOutput <double>("@Total26").ToString();
totalColumns.Total27 = param.GetDataOutput <double>("@Total27").ToString();
totalColumns.Total28 = param.GetDataOutput <double>("@Total28").ToString();
totalColumns.Total29 = param.GetDataOutput <double>("@Total29").ToString();
totalColumns.Total30 = param.GetDataOutput <double>("@Total30").ToString();
totalColumns.Total31 = param.GetDataOutput <double>("@Total31").ToString();
totalColumns.Total32 = param.GetDataOutput <double>("@Total31").ToString();
totalRecord = param.GetDataOutput <int>("@TotalRecord");
return(list);
}
catch (Exception e)
{
totalRecord = 0;
totalColumns = new TableColumnsTotal();
return(new List <Salary>());
}
}
public ActionResult Get_CustomerClientSource_BDXExportExcel(int pageIndex, int pageSize, string filter = "", string startdate = "", string enddate = "", int OrganizationUnitID = 0)
{
DataTable dt = new DataTable("Grid");
dt.Columns.AddRange(new DataColumn[8]
{
new DataColumn(AppRes.StatusList),
new DataColumn(AppRes.Quantity_MKT),
new DataColumn(AppRes.Quantity_Web),
new DataColumn(AppRes.Quantity_Sale),
new DataColumn(AppRes.Total),
new DataColumn(AppRes.Rate_MKT),
new DataColumn(AppRes.Rate_Web),
new DataColumn(AppRes.Rate_Sale)
});
dt.Columns[0].DataType = typeof(string);
dt.Columns[1].DataType = typeof(double);
dt.Columns[2].DataType = typeof(double);
dt.Columns[3].DataType = typeof(double);
dt.Columns[4].DataType = typeof(double);
dt.Columns[5].DataType = typeof(double);
dt.Columns[6].DataType = typeof(double);
dt.Columns[7].DataType = typeof(double);
var db = new ReportSourceLeadDAL();
int?total = 0;
TableColumnsTotal totalColumns = new TableColumnsTotal();
var baseListParam = new BaseListParam()
{
FilterField = filter,
OrderByField = "",
PageIndex = pageIndex,
PageSize = 50000,
UserType = Global.CurrentUser.RoleId,
UserId = Global.CurrentUser.LoginUserId,
DeptId = Global.CurrentUser.OrganizationUnitID,
LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
};
var lstData = db.Get_CustomerClientSource_BDX(baseListParam, startdate, enddate, OrganizationUnitID, out total);
foreach (var item in lstData)
{
dt.Rows.Add(
item.StatusList == null ? "" : item.StatusList,
item.Quantity_MKT = item.Quantity_MKT,
item.Quantity_Web = item.Quantity_Web,
item.Quantity_Sale = item.Quantity_Sale,
item.Total = item.Total,
item.Rate_MKT = item.Rate_MKT,
item.Rate_Web = item.Rate_Web,
item.Rate_Sale = item.Rate_Sale
);
}
var wb = new XLWorkbook();
wb.Worksheets.Add(dt);
byte[] data = null;
using (var stream = new MemoryStream())
{
wb.SaveAs(stream);
data = stream.ToArray();
}
var excelName = "Get_CustomerClientSource_BDXExportExcel.xlsx";
return(File(data, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", excelName));
}
public ActionResult SalaryExportExcel(string filterString, int pageIndex, int pageSize)
{
DataTable dt = new DataTable("Grid");
dt.Columns.AddRange(new DataColumn[79]
{
new DataColumn(AppRes.MonthYear),
new DataColumn(AppRes.StaffCode),
new DataColumn(AppRes.FullName),
new DataColumn(AppRes.Department),
new DataColumn(AppRes.Position),
new DataColumn(AppRes.Rank),
new DataColumn(AppRes.EmployeeStatus),
new DataColumn(AppRes.Email),
new DataColumn(AppRes.Workingday),
new DataColumn(AppRes.Standardworkingday),
new DataColumn(AppRes.BasicSalary),
new DataColumn(AppRes.Bonus),
new DataColumn(AppRes.SeniorityPay),
new DataColumn(AppRes.AllowancesLaptop),
new DataColumn(AppRes.TotalOtherAllowances),
new DataColumn(AppRes.BDOAllowances),
new DataColumn(AppRes.IncomePerDay),
new DataColumn(AppRes.SalarylastMonth),
new DataColumn(AppRes.Commission),
new DataColumn(AppRes.OtherBonus),
new DataColumn(AppRes.BonusNote),
new DataColumn(AppRes.PersonalIncomeTax),
new DataColumn(AppRes.AmountInsurance),
new DataColumn(AppRes.UnionFund),
new DataColumn(AppRes.TardinessReduction),
new DataColumn(AppRes.QCBonus),
new DataColumn(AppRes.AdvancePayment),
new DataColumn(AppRes.OtherReduction),
new DataColumn(AppRes.ReductionNote),
new DataColumn(AppRes.TotalIncome),
new DataColumn(AppRes.TotalReduction),
new DataColumn(AppRes.Netsalary),
new DataColumn(AppRes.PaymentPeriod1),
new DataColumn(AppRes.PaymentPeriod2),
new DataColumn(AppRes.PaymentPeriod3),
new DataColumn(AppRes.PaymentPeriod4),
new DataColumn(AppRes.PaymentPeriod5),
new DataColumn(AppRes.Remain),
new DataColumn(AppRes.SalaryAccountNumber),
new DataColumn(AppRes.SalaryAccountName),
new DataColumn(AppRes.ReceipientBankName),
new DataColumn(AppRes.Nontaxableincome),
new DataColumn(AppRes.NontaxableincomeNote),
new DataColumn(AppRes.OtherAllowanceDetails),
new DataColumn(AppRes.Margincompensation),
new DataColumn(AppRes.MargincompensationNote),
new DataColumn(AppRes.DecemberBonus),
new DataColumn(AppRes.TotalSalary),
new DataColumn(AppRes.HoldSaraly),
new DataColumn(AppRes.StatusOfLaborContract),
new DataColumn(AppRes.Policy),
new DataColumn(AppRes.TimeLate),
new DataColumn(AppRes.OverTime),
new DataColumn(AppRes.AllowancesPosition),
new DataColumn(AppRes.Allowancesparkingfee),
new DataColumn(AppRes.AllowancesPhone),
new DataColumn(AppRes.OtherAllowances),
new DataColumn(AppRes.C_Socialinsurance),
new DataColumn(AppRes.C_Healthinsurance),
new DataColumn(AppRes.C_Unemploymentinsurance),
new DataColumn(AppRes.C_KPCD),
new DataColumn(AppRes.P_Socialinsurance),
new DataColumn(AppRes.P_Healthinsurance),
new DataColumn(AppRes.P_Unemploymentinsurance),
new DataColumn(AppRes.P_KPCD),
new DataColumn(AppRes.Deductionitself),
new DataColumn(AppRes.NumRelatedperson),
new DataColumn(AppRes.Deduct),
new DataColumn(AppRes.Foodexpenses),
new DataColumn(AppRes.Taxableincome),
new DataColumn(AppRes.PaymentNextMonth),
new DataColumn(AppRes.WorkingAdjusted),
new DataColumn(AppRes.NoteAdjusted),
new DataColumn(AppRes.Locked),
new DataColumn(AppRes.Currency),
new DataColumn(AppRes.Company),
new DataColumn(AppRes.Manager),
new DataColumn(AppRes.Period),
new DataColumn(AppRes.RewardsEnterHands),
});
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(string);
dt.Columns[7].DataType = typeof(string);
dt.Columns[8].DataType = typeof(double);
dt.Columns[9].DataType = typeof(double);
dt.Columns[10].DataType = typeof(double);
dt.Columns[11].DataType = typeof(double);
dt.Columns[12].DataType = typeof(double);
dt.Columns[13].DataType = typeof(double);
dt.Columns[14].DataType = typeof(double);
dt.Columns[15].DataType = typeof(double);
dt.Columns[16].DataType = typeof(double);
dt.Columns[17].DataType = typeof(double);
dt.Columns[18].DataType = typeof(double);
dt.Columns[19].DataType = typeof(double);
dt.Columns[20].DataType = typeof(string);
dt.Columns[21].DataType = typeof(double);
dt.Columns[22].DataType = typeof(double);
dt.Columns[23].DataType = typeof(double);
dt.Columns[24].DataType = typeof(double);
dt.Columns[25].DataType = typeof(double);
dt.Columns[26].DataType = typeof(double);
dt.Columns[27].DataType = typeof(double);
dt.Columns[28].DataType = typeof(string);
dt.Columns[29].DataType = typeof(double);
dt.Columns[30].DataType = typeof(double);
dt.Columns[31].DataType = typeof(double);
dt.Columns[32].DataType = typeof(double);
dt.Columns[33].DataType = typeof(double);
dt.Columns[34].DataType = typeof(double);
dt.Columns[35].DataType = typeof(double);
dt.Columns[36].DataType = typeof(double);
dt.Columns[37].DataType = typeof(double);
dt.Columns[38].DataType = typeof(string);
dt.Columns[39].DataType = typeof(string);
dt.Columns[40].DataType = typeof(string);
dt.Columns[41].DataType = typeof(double);
dt.Columns[42].DataType = typeof(string);
dt.Columns[43].DataType = typeof(string);
dt.Columns[44].DataType = typeof(double);
dt.Columns[45].DataType = typeof(string);
dt.Columns[46].DataType = typeof(double);
dt.Columns[47].DataType = typeof(double);
dt.Columns[48].DataType = typeof(int);
dt.Columns[49].DataType = typeof(string);
dt.Columns[50].DataType = typeof(string);
dt.Columns[51].DataType = typeof(double);
dt.Columns[52].DataType = typeof(double);
dt.Columns[53].DataType = typeof(double);
dt.Columns[54].DataType = typeof(double);
dt.Columns[55].DataType = typeof(double);
dt.Columns[56].DataType = typeof(double);
dt.Columns[57].DataType = typeof(double);
dt.Columns[58].DataType = typeof(double);
dt.Columns[59].DataType = typeof(double);
dt.Columns[60].DataType = typeof(double);
dt.Columns[61].DataType = typeof(double);
dt.Columns[62].DataType = typeof(double);
dt.Columns[63].DataType = typeof(double);
dt.Columns[64].DataType = typeof(double);
dt.Columns[65].DataType = typeof(double);
dt.Columns[66].DataType = typeof(double);
dt.Columns[67].DataType = typeof(double);
dt.Columns[68].DataType = typeof(double);
dt.Columns[69].DataType = typeof(double);
dt.Columns[70].DataType = typeof(double);
dt.Columns[71].DataType = typeof(double);
dt.Columns[72].DataType = typeof(string);
dt.Columns[73].DataType = typeof(string);
dt.Columns[74].DataType = typeof(string);
dt.Columns[75].DataType = typeof(string);
dt.Columns[76].DataType = typeof(string);
dt.Columns[77].DataType = typeof(double);
dt.Columns[78].DataType = typeof(double);
var db = new SalaryDAL();
int?total = 0;
TableColumnsTotal totalColumns = new TableColumnsTotal();
var baseListParam = new BaseListParam()
{
FilterField = filterString,
OrderByField = "",
PageIndex = pageIndex,
PageSize = int.MaxValue,
UserType = Global.CurrentUser.RoleId,
UserId = Global.CurrentUser.LoginUserId,
DeptId = Global.CurrentUser.OrganizationUnitID,
LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
};
int type = 2;
var lstData = db.ExportExcelSalary(baseListParam, type, out total, out totalColumns);
foreach (var item in lstData)
{
dt.Rows.Add(
item.MonthYear == null ? "" : item.MonthYear,
item.StaffCode == null ? "" : item.StaffCode,
item.FullName == null ? "" : item.FullName,
item.OrganizationUnitName == null ? "" : item.OrganizationUnitName,
item.OfficePositionName == null ? "" : item.OfficePositionName,
item.StaffLevelName == null ? "" : item.StaffLevelName,
item.EmployeeStatus == null ? "" : item.EmployeeStatus,
item.EmailPersonal == null ? "" : item.EmailPersonal,
item.Workingday == null ? 0 : item.Workingday,
item.Standardworkingday == null ? 0 : item.Standardworkingday,
item.BasicSalary == null ? 0 : item.BasicSalary,
item.Bonus == null ? 0 : item.Bonus,
item.SeniorityPay == null ? 0 : item.SeniorityPay,
item.AllowancesLaptop == null ? 0 : item.AllowancesLaptop,
item.TotalOtherAllowances == null ? 0 : item.TotalOtherAllowances, //15
item.BDOAllowances == null ? 0 : item.BDOAllowances, //16
item.IncomePerDay == null ? 0 : item.IncomePerDay,
item.SalarylastMonth == null ? 0 : item.SalarylastMonth,
item.Commission == null ? 0 : item.Commission,
item.OtherBonus == null ? 0 : item.OtherBonus, //20
item.BonusNote == null ? "" : item.BonusNote, //21
item.PersonalIncomeTax == null ? 0 : item.PersonalIncomeTax,
item.AmountInsurance == null ? 0 : item.AmountInsurance,
item.UnionFund == null ? 0 : item.UnionFund,
item.TardinessReduction == null ? 0 : item.TardinessReduction,
item.QCBonus == null ? 0 : item.QCBonus,
item.AdvancePayment == null ? 0 : item.AdvancePayment, //27
item.OtherReduction == null ? 0 : item.OtherReduction, //28
item.ReductionNote == null ? "" : item.ReductionNote, //29
item.TotalIncome == null ? 0 : item.TotalIncome,
item.TotalReduction == null ? 0 : item.TotalReduction,
item.Netsalary == null ? 0 : item.Netsalary,
item.PaymentPeriod1 == null ? 0 : item.PaymentPeriod1,
item.PaymentPeriod2 == null ? 0 : item.PaymentPeriod2,
item.PaymentPeriod3 == null ? 0 : item.PaymentPeriod3,
item.PaymentPeriod4 == null ? 0 : item.PaymentPeriod4,
item.PaymentPeriod5 == null ? 0 : item.PaymentPeriod5,
item.Remain == null ? 0 : item.Remain,
item.AccountNumber == null ? "" : item.AccountNumber,
item.AccountName == null ? "" : item.AccountName,
item.BankName == null ? "" : item.BankName,
item.Nontaxableincome == null ? 0 : item.Nontaxableincome, //42
item.NontaxableincomeNote == null ? "" : item.NontaxableincomeNote, //43
item.AllowancesNote == null ? "" : item.AllowancesNote, //44
item.Margincompensation == null ? 0 : item.Margincompensation, //45
item.MargincompensationNote == null ? "" : item.MargincompensationNote, //46
item.Decemberbonus == null ? 0 : item.Decemberbonus, //47
item.TotalSalary == null ? 0 : item.TotalSalary,
item.HoldSalary == null ? 0 : item.HoldSalary,
item.StatusContractName == null ? "" : item.StatusContractName,
item.PolicyName == null ? "" : item.PolicyName,
item.TimeLate == null ? 0 : item.TimeLate,
item.OverTime == null ? 0 : item.OverTime,
item.AllowancesPosition == null ? 0 : item.AllowancesPosition,
item.Allowancesparkingfee == null ? 0 : item.Allowancesparkingfee,
item.AllowancesPhone == null ? 0 : item.AllowancesPhone,
item.OtherAllowances == null ? 0 : item.OtherAllowances,
item.C_Socialinsurance == null ? 0 : item.C_Socialinsurance,
item.C_Healthinsurance == null ? 0 : item.C_Healthinsurance,
item.C_Unemploymentinsurance == null ? 0 : item.C_Unemploymentinsurance,
item.C_KPCD == null ? 0 : item.C_KPCD,
item.P_Socialinsurance == null ? 0 : item.P_Socialinsurance,
item.P_Healthinsurance == null ? 0 : item.P_Healthinsurance,
item.P_Unemploymentinsurance == null ? 0 : item.P_Unemploymentinsurance,
item.P_KPCD == null ? 0 : item.P_KPCD,
item.Deductionitself == null ? 0 : item.Deductionitself,
item.NumRelatedperson,
item.Deduction == null ? 0 : item.Deduction,
item.Foodexpenses == null ? 0 : item.Foodexpenses,
item.Taxableincome == null ? 0 : item.Taxableincome,
item.PaymentNextMonth == null ? 0 : item.PaymentNextMonth,
item.WorkingAdjusted == null ? 0 : item.WorkingAdjusted,
item.NoteAdjusted == null ? "" : item.NoteAdjusted,
item.Locked,
item.Currency == null ? "" : item.Currency,
item.CompanyName == null ? "" : item.CompanyName,
item.ParentName == null ? "" : item.ParentName,
item.Period,
item.SysBonus
);
}
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", "SalaryFull.xlsx"));
}
public ActionResult ExportExcel(int pageIndex, int pageSize, ListFilterParam list, string filter = "")
{
filter = filter.Replace("!!", "%");
DataTable dt = new DataTable("Grid");
if (list.filter7 == "2")
{
dt.Columns.AddRange(new DataColumn[8]
{
new DataColumn(AppRes.DeptName),
new DataColumn(AppRes.Staff),
new DataColumn(AppRes.AssignedSpending),
new DataColumn(AppRes.SpendingInMonth),
new DataColumn(AppRes.IncreaseSpending),
new DataColumn(AppRes.SpendingIncreasedStandard),
new DataColumn(AppRes.CompletionRate),
new DataColumn(AppRes.StaffStatus)
});
dt.Columns[0].DataType = typeof(string);
dt.Columns[1].DataType = typeof(string);
dt.Columns[2].DataType = typeof(double);
dt.Columns[3].DataType = typeof(double);
dt.Columns[4].DataType = typeof(double);
dt.Columns[5].DataType = typeof(double);
dt.Columns[6].DataType = typeof(double);
dt.Columns[7].DataType = typeof(string);
}
else
{
dt.Columns.AddRange(new DataColumn[6]
{
new DataColumn(AppRes.DeptName),
new DataColumn(AppRes.AssignedSpending),
new DataColumn(AppRes.SpendingInMonth),
new DataColumn(AppRes.IncreaseSpending),
new DataColumn(AppRes.SpendingIncreasedStandard),
new DataColumn(AppRes.CompletionRate)
});
dt.Columns[0].DataType = typeof(string);
dt.Columns[1].DataType = typeof(double);
dt.Columns[2].DataType = typeof(double);
dt.Columns[3].DataType = typeof(double);
dt.Columns[4].DataType = typeof(double);
dt.Columns[5].DataType = typeof(double);
}
var db = new ReportIncreaseSpendingDAL();
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,
LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
};
list.FromDate = Convert.ToDateTime(DateTime.ParseExact(list.StringFromDate, "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture));
list.ToDate = Convert.ToDateTime(DateTime.ParseExact(list.StringToDate, "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture));
var lstData = db.ExportReportIncreaseSpending(baseListParam, list, out total, out totalColumns);
foreach (var item in lstData)
{
if (list.filter7 == "2")
{
dt.Rows.Add(
item.OrganizationUnitName == null ? "" : item.OrganizationUnitName,
item.StaffName == null ? "" : item.StaffName,
item.AssignedSpending == null ? 0 : item.AssignedSpending,
item.SpendingInMonth == null ? 0 : item.SpendingInMonth,
item.IncreaseSpending == null ? 0 : item.IncreaseSpending,
item.SpendingIncreasedStandard == null ? 0 : item.SpendingIncreasedStandard,
item.CompletionRate == null ? 0 : item.CompletionRate,
item.StaffStatus == null ? "" : item.StaffStatus);
}
else
{
dt.Rows.Add(
item.OrganizationUnitName == null ? "" : item.OrganizationUnitName,
item.AssignedSpending == null ? 0 : item.AssignedSpending,
item.SpendingInMonth == null ? 0 : item.SpendingInMonth,
item.IncreaseSpending == null ? 0 : item.IncreaseSpending,
item.SpendingIncreasedStandard == null ? 0 : item.SpendingIncreasedStandard,
item.CompletionRate == null ? 0 : item.CompletionRate);
}
}
var wb = new XLWorkbook();
wb.Worksheets.Add(dt);
byte[] data = null;
using (var stream = new MemoryStream())
{
wb.SaveAs(stream);
data = stream.ToArray();
}
var excelName = "";
switch (list.filter7)
{
case "2":
// code block
excelName = "ReportIncreaseSpending.xlsx";
break;
case "1":
// code block
excelName = "ReportIncreaseSpendingByDepartment.xlsx";
break;
}
return(File(data, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", excelName));
}
public ActionResult ExportExcel(int pageIndex, int pageSize, ListFilterParam list, string filter = "")
{
filter = filter.Replace("!!", "%");
DataTable dt = new DataTable("Grid");
dt.Columns.AddRange(new DataColumn[5]
{
new DataColumn(AppRes.AccountNumber),
new DataColumn(AppRes.SpendingDay),
new DataColumn(AppRes.InitialAmount),
new DataColumn(AppRes.AmountChanged),
new DataColumn(AppRes.ModifiedDate),
});
dt.Columns[0].DataType = typeof(string);
dt.Columns[1].DataType = typeof(DateTime?);
dt.Columns[2].DataType = typeof(double);
dt.Columns[3].DataType = typeof(double);
dt.Columns[5].DataType = typeof(DateTime?);
var db = new HistoryUpdateSpendingDAL();
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,
LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
};
list.FromDate = Convert.ToDateTime(DateTime.ParseExact(list.StringFromDate, "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture));
list.ToDate = Convert.ToDateTime(DateTime.ParseExact(list.StringToDate, "dd-MM-yyyy HH:mm:ss", CultureInfo.InvariantCulture));
var lstData = db.getHistoryUpdateSpendingForExcel(baseListParam, list, Global.CurrentUser.CurrencyTypeID ?? 0, out total, out totalColumns);
foreach (var item in lstData)
{
dt.Rows.Add(
item.AccountNumber ?? "",
item.Day,
item.AmountVND ?? 0,
item.AmountChanged ?? 0,
item.ModifiedDate);
}
var wb = new XLWorkbook();
wb.Worksheets.Add(dt);
byte[] data = null;
using (var stream = new MemoryStream())
{
wb.SaveAs(stream);
data = stream.ToArray();
}
var excelName = "";
excelName = "CustomerTransferHistory.xlsx";
return(File(data, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", excelName));
}
public ActionResult PerformanceReportONNExportExcel(int pageIndex, int pageSize, ListFilterParam list, string filter = "")
{
filter = filter + (!String.IsNullOrEmpty(list.filter9) ? (!String.IsNullOrEmpty(filter.Trim()) ? " AND " : "") + " CompanyName LIKE N'%" + list.filter9 + "%'" : "");
filter = filter + (!String.IsNullOrEmpty(list.filter10) ? (!String.IsNullOrEmpty(filter.Trim()) ? " AND " : "") + " UnitName LIKE N'%" + list.filter10 + "%'" : "");
filter = filter + (!String.IsNullOrEmpty(list.filter11) ? (!String.IsNullOrEmpty(filter.Trim()) ? " AND " : "") + " OrganizationUnitName LIKE N'%" + list.filter11 + "%'" : "");
filter = filter + (!String.IsNullOrEmpty(list.filter12) ? (!String.IsNullOrEmpty(filter.Trim()) ? " AND " : "") + " StaffName LIKE N'%" + list.filter12 + "%'" : "");
if (Global.CurrentUser.OfficePositionID == 250 || Global.CurrentUser.OfficePositionID == 251 ||
Global.CurrentUser.OfficePositionID == 252 || Global.CurrentUser.OfficePositionID == 253 ||
Global.CurrentUser.OfficePositionID == 254 || Global.CurrentUser.RoleId != 1 ||
Global.CurrentUser.RoleId == 11)
{
list.filter7 = list.filter7;
}
else
{
list.filter7 = "2";
}
filter = filter.Replace("!!", "%");
DataTable dt = new DataTable("Grid");
dt.Columns.AddRange(new DataColumn[42]
{
new DataColumn(AppRes.Company),
new DataColumn(AppRes.ByUnit),
new DataColumn(AppRes.DeptName),
new DataColumn(AppRes.Staff),
new DataColumn(AppRes.StaffCode),
new DataColumn(AppRes.OrganazationUnitCode),
new DataColumn(AppRes.L1),
new DataColumn(AppRes.L2),
new DataColumn(AppRes.L3),
new DataColumn(AppRes.L4),
new DataColumn(AppRes.L5),
new DataColumn(AppRes.L6),
new DataColumn(AppRes.L7),
new DataColumn(AppRes.L8),
new DataColumn(AppRes.L9),
new DataColumn(AppRes.L10),
new DataColumn(AppRes.L11),
new DataColumn(AppRes.L12),
new DataColumn(AppRes.TotalMonth),
new DataColumn(AppRes.Rate1),
new DataColumn(AppRes.Rate2),
new DataColumn(AppRes.Rate3),
new DataColumn(AppRes.Rate4),
new DataColumn(AppRes.Rate5),
new DataColumn(AppRes.Rate6),
new DataColumn(AppRes.Rate7),
new DataColumn(AppRes.Rate8),
new DataColumn(AppRes.Rate9),
new DataColumn(AppRes.Rate10),
new DataColumn(AppRes.Rate11),
new DataColumn(AppRes.Rate12),
new DataColumn(AppRes.QL1),
new DataColumn(AppRes.QL2),
new DataColumn(AppRes.QL3),
new DataColumn(AppRes.QL4),
new DataColumn(AppRes.TotalQuarter),
new DataColumn(AppRes.RateQ1),
new DataColumn(AppRes.RateQ2),
new DataColumn(AppRes.RateQ3),
new DataColumn(AppRes.RateQ4),
new DataColumn(AppRes.R_RateYear),
new DataColumn(AppRes.Note)
});
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(double);
dt.Columns[8].DataType = typeof(double);
dt.Columns[9].DataType = typeof(double);
dt.Columns[10].DataType = typeof(double);
dt.Columns[11].DataType = typeof(double);
dt.Columns[12].DataType = typeof(double);
dt.Columns[13].DataType = typeof(double);
dt.Columns[14].DataType = typeof(double);
dt.Columns[15].DataType = typeof(double);
dt.Columns[16].DataType = typeof(double);
dt.Columns[17].DataType = typeof(double);
dt.Columns[18].DataType = typeof(double);
dt.Columns[19].DataType = typeof(double);
dt.Columns[20].DataType = typeof(double);
dt.Columns[21].DataType = typeof(double);
dt.Columns[22].DataType = typeof(double);
dt.Columns[23].DataType = typeof(double);
dt.Columns[24].DataType = typeof(double);
dt.Columns[25].DataType = typeof(double);
dt.Columns[26].DataType = typeof(double);
dt.Columns[27].DataType = typeof(double);
dt.Columns[28].DataType = typeof(double);
dt.Columns[29].DataType = typeof(double);
dt.Columns[30].DataType = typeof(double);
dt.Columns[31].DataType = typeof(double);
dt.Columns[32].DataType = typeof(double);
dt.Columns[33].DataType = typeof(double);
dt.Columns[34].DataType = typeof(double);
dt.Columns[35].DataType = typeof(double);
dt.Columns[36].DataType = typeof(double);
dt.Columns[37].DataType = typeof(double);
dt.Columns[38].DataType = typeof(double);
dt.Columns[39].DataType = typeof(double);
dt.Columns[40].DataType = typeof(double);
dt.Columns[41].DataType = typeof(string);
var db = new PerformanceReportDAL();
int?total = 0;
TableColumnsTotal totalColumns = new TableColumnsTotal();
var baseListParam = new BaseListParam()
{
FilterField = filter,
OrderByField = "",
PageIndex = 1,
PageSize = int.MaxValue,
UserType = Global.CurrentUser.RoleId,
UserId = Global.CurrentUser.LoginUserId,
DeptId = Global.CurrentUser.OrganizationUnitID,
LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
};
var lstData = db.PerformanceReportONN(baseListParam, list, Global.CurrentUser.CurrencyTypeID ?? 0, 1, out total, out totalColumns);
foreach (var item in lstData)
{
dt.Rows.Add(
item.CompanyName == null ? "" : item.CompanyName,
item.UnitName == null ? "" : item.UnitName,
item.OrganizationUnitName == null ? "" : item.OrganizationUnitName,
item.StaffName ?? "",
item.StaffCode == null ? "" : item.StaffCode,
item.OrganazationUnitCode == null ? "" : item.OrganazationUnitCode,
item.L1 == null ? 0 : Math.Round(item.L1 ?? 0, 2),
item.L2 == null ? 0 : Math.Round(item.L2 ?? 0, 2),
item.L3 == null ? 0 : Math.Round(item.L3 ?? 0, 2),
item.L4 == null ? 0 : Math.Round(item.L4 ?? 0, 2),
item.L5 == null ? 0 : Math.Round(item.L5 ?? 0, 2),
item.L6 == null ? 0 : Math.Round(item.L6 ?? 0, 2),
item.L7 == null ? 0 : Math.Round(item.L7 ?? 0, 2),
item.L8 == null ? 0 : Math.Round(item.L8 ?? 0, 2),
item.L9 == null ? 0 : Math.Round(item.L9 ?? 0, 2),
item.L10 == null ? 0 : Math.Round(item.L10 ?? 0, 2),
item.L11 == null ? 0 : Math.Round(item.L11 ?? 0, 2),
item.L12 == null ? 0 : Math.Round(item.L12 ?? 0, 2),
item.TotalMonth == null ? 0 : Math.Round(item.TotalMonth ?? 0, 2),
item.Rate1 == null ? 0 : Math.Round(item.Rate1 ?? 0, 2),
item.Rate2 == null ? 0 : Math.Round(item.Rate2 ?? 0, 2),
item.Rate3 == null ? 0 : Math.Round(item.Rate3 ?? 0, 2),
item.Rate4 == null ? 0 : Math.Round(item.Rate4 ?? 0, 2),
item.Rate5 == null ? 0 : Math.Round(item.Rate5 ?? 0, 2),
item.Rate6 == null ? 0 : Math.Round(item.Rate6 ?? 0, 2),
item.Rate7 == null ? 0 : Math.Round(item.Rate7 ?? 0, 2),
item.Rate8 == null ? 0 : Math.Round(item.Rate8 ?? 0, 2),
item.Rate9 == null ? 0 : Math.Round(item.Rate9 ?? 0, 2),
item.Rate10 == null ? 0 : Math.Round(item.Rate10 ?? 0, 2),
item.Rate11 == null ? 0 : Math.Round(item.Rate11 ?? 0, 2),
item.Rate12 == null ? 0 : Math.Round(item.Rate12 ?? 0, 2),
item.QL1 == null ? 0 : Math.Round(item.QL1 ?? 0, 2),
item.QL2 == null ? 0 : Math.Round(item.QL2 ?? 0, 2),
item.QL3 == null ? 0 : Math.Round(item.QL3 ?? 0, 2),
item.QL4 == null ? 0 : Math.Round(item.QL4 ?? 0, 2),
item.TotalQuarter == null ? 0 : Math.Round(item.TotalQuarter ?? 0, 2),
item.RateQ1 == null ? 0 : Math.Round(item.RateQ1 ?? 0, 2),
item.RateQ2 == null ? 0 : Math.Round(item.RateQ2 ?? 0, 2),
item.RateQ3 == null ? 0 : Math.Round(item.RateQ3 ?? 0, 2),
item.RateQ4 == null ? 0 : Math.Round(item.RateQ4 ?? 0, 2),
item.RateMonth == null ? 0 : Math.Round(item.RateMonth ?? 0, 2),
item.Note == null ? "" : item.Note
);
}
if (list.filter7 == "4")
{
dt.Columns.Remove(AppRes.DeptName);
dt.Columns.Remove(AppRes.ByUnit);
dt.Columns.Remove(AppRes.Staff);
}
else if (list.filter7 == "3")
{
dt.Columns.Remove(AppRes.DeptName);
dt.Columns.Remove(AppRes.Staff);
}
else if (list.filter7 == "1")
{
dt.Columns.Remove(AppRes.Staff);
}
var wb = new XLWorkbook();
wb.Worksheets.Add(dt);
byte[] data = null;
using (var stream = new MemoryStream())
{
wb.SaveAs(stream);
data = stream.ToArray();
}
var excelName = "PerformanceReport_ONN.xlsx";
return(File(data, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", excelName));
}
public ActionResult Report_L_By_Department_BDXExportExcel(int pageIndex, int pageSize, string filter = "", string startdate2 = "", string enddate2 = "")
{
DataTable dt = new DataTable("Grid");
dt.Columns.AddRange(new DataColumn[23]
{
new DataColumn(AppRes.DeptName),
new DataColumn(AppRes.L0_1),
new DataColumn(AppRes.L0_2),
new DataColumn(AppRes.L0_3),
new DataColumn(AppRes.L0_4),
new DataColumn(AppRes.L1_1),
new DataColumn(AppRes.L1_2),
new DataColumn(AppRes.L1_3),
new DataColumn(AppRes.L1_4),
new DataColumn(AppRes.L2_1),
new DataColumn(AppRes.L2_2),
new DataColumn(AppRes.L2_3),
new DataColumn(AppRes.L2_4),
new DataColumn(AppRes.L3_1),
new DataColumn(AppRes.L3_2),
new DataColumn(AppRes.L3_3),
new DataColumn(AppRes.L3_4),
new DataColumn(AppRes.L4_1),
new DataColumn(AppRes.L4_2),
new DataColumn(AppRes.L5),
new DataColumn(AppRes.L6_1),
new DataColumn(AppRes.L6_2),
new DataColumn(AppRes.Total)
});
dt.Columns[0].DataType = typeof(string);
dt.Columns[1].DataType = typeof(double);
dt.Columns[2].DataType = typeof(double);
dt.Columns[3].DataType = typeof(double);
dt.Columns[4].DataType = typeof(double);
dt.Columns[5].DataType = typeof(double);
dt.Columns[6].DataType = typeof(double);
dt.Columns[7].DataType = typeof(double);
dt.Columns[8].DataType = typeof(double);
dt.Columns[9].DataType = typeof(double);
dt.Columns[10].DataType = typeof(double);
dt.Columns[11].DataType = typeof(double);
dt.Columns[12].DataType = typeof(double);
dt.Columns[13].DataType = typeof(double);
dt.Columns[14].DataType = typeof(double);
dt.Columns[15].DataType = typeof(double);
dt.Columns[16].DataType = typeof(double);
dt.Columns[17].DataType = typeof(double);
dt.Columns[18].DataType = typeof(double);
dt.Columns[19].DataType = typeof(double);
dt.Columns[20].DataType = typeof(double);
dt.Columns[21].DataType = typeof(double);
dt.Columns[22].DataType = typeof(double);
var db = new ReportLDAL();
int?total = 0;
TableColumnsTotal totalColumns = new TableColumnsTotal();
var baseListParam = new BaseListParam()
{
FilterField = filter,
OrderByField = "",
PageIndex = pageIndex,
PageSize = 50000,
UserType = Global.CurrentUser.RoleId,
UserId = Global.CurrentUser.LoginUserId,
DeptId = Global.CurrentUser.OrganizationUnitID,
LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
};
var lstData = db.Report_L_By_Department_BDX(baseListParam, startdate2, enddate2, out total, out totalColumns);
foreach (var item in lstData)
{
dt.Rows.Add(
item.department == null ? "" : item.department,
item.L0_1 = item.L0_1,
item.L0_2 = item.L0_2,
item.L0_3 = item.L0_3,
item.L0_4 = item.L0_4,
item.L1_1 = item.L1_1,
item.L1_2 = item.L1_2,
item.L1_3 = item.L1_3,
item.L1_4 = item.L1_4,
item.L2_1 = item.L2_1,
item.L2_2 = item.L2_2,
item.L2_3 = item.L2_3,
item.L2_4 = item.L2_4,
item.L3_1 = item.L3_1,
item.L3_2 = item.L3_2,
item.L3_3 = item.L3_3,
item.L3_4 = item.L3_4,
item.L4_1 = item.L4_1,
item.L4_2 = item.L4_2,
item.L5 = item.L5,
item.L6_1 = item.L6_1,
item.L6_2 = item.L6_2,
item.Total = item.Total
);
}
var wb = new XLWorkbook();
wb.Worksheets.Add(dt);
byte[] data = null;
using (var stream = new MemoryStream())
{
wb.SaveAs(stream);
data = stream.ToArray();
}
var excelName = "Report_L_By_Department_BDX.xlsx";
return(File(data, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", excelName));
}
