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 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 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 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 List <DetailReportAccount> ExportExcelDetailAccountReport(BaseListParam listParam, ListFilterParam filterParam)
{
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", 194);
param.Add("@LanguageID", listParam.LanguageCode);
param.Add("@isExcel", true);
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();
return(list);
}
catch (Exception ex)
{
return(new List <DetailReportAccount>());
}
}
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 List <PaymentProduct> ExportExcelPaymentProduct(BaseListParam listParam, ListFilterParam listFilterParam, out int?totalRecord)
{
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");
return(list);
}
catch (Exception e)
{
totalRecord = 0;
return(new List <PaymentProduct>());
}
}
public List <ReportGeneralSpending> GetReportGeneralSpending(BaseListParam listParam, ListFilterParam listFilterParam, out int?totalRecord, out TableColumnsTotal totalColumns, int isExcel)
{
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", isExcel);
param.Add("@LanguageID", listParam.LanguageCode);
param.Add("@FromMonth", listFilterParam.filter1);
param.Add("@ToMonth", listFilterParam.filter2);
param.Add("@Year", listFilterParam.filter5);
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);
var list = UnitOfWork.Procedure <ReportGeneralSpending>("ReportGeneralSpending", param).ToList();
param = HttpRuntime.Cache.Get("ReportGeneralSpending-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + HRM.Common.Global.CurrentUser.UserID + "-output") as DynamicParameters;
foreach (var item in list)
{
item.Total = item.M1 + item.M2 + item.M3 + item.M4 + item.M5 + item.M6 + item.M7 + item.M8 + item.M9 +
item.M10 + item.M11 + item.M12;
}
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 = (double.Parse(totalColumns.Total1) + double.Parse(totalColumns.Total2) + double.Parse(totalColumns.Total3) +
double.Parse(totalColumns.Total4) + double.Parse(totalColumns.Total5) + double.Parse(totalColumns.Total6) +
double.Parse(totalColumns.Total7) + double.Parse(totalColumns.Total8) + double.Parse(totalColumns.Total9) +
double.Parse(totalColumns.Total10) + double.Parse(totalColumns.Total11) + double.Parse(totalColumns.Total12)).ToString();
return(list);
}
catch (Exception ex)
{
totalRecord = 0;
totalColumns = new TableColumnsTotal();
return(new List <ReportGeneralSpending>());
}
}
public ActionResult PaymentProductExportExcel(int pageIndex, int pageSize, ListFilterParam list, string filter = "")
{
DataTable dt = new DataTable("Grid");
dt.Columns.AddRange(new DataColumn[9]
{
new DataColumn(AppRes.CustomerCode),
new DataColumn(AppRes.Email),
new DataColumn(AppRes.Website),
new DataColumn(AppRes.BD),
new DataColumn(AppRes.OrganizationUnitName),
new DataColumn(AppRes.Product),
new DataColumn(AppRes.Margin),
new DataColumn(AppRes.PaymentDate),
new DataColumn(AppRes.StatusName)
});
dt.Columns[0].DataType = typeof(int);
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(DateTime);
dt.Columns[8].DataType = typeof(string);
var db = new PaymentProductDAL();
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 = int.MaxValue,
LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
};
var lstData = db.ExportExcelPaymentProduct(baseListParam, list, out total);
foreach (var item in lstData)
{
dt.Rows.Add(
item.CustomerID,
item.Email == null ? "" : item.Email,
item.Website == null ? "" : item.Website,
item.BDName == null ? "" : item.BDName,
item.OrganizationUnitName == null ? "": item.OrganizationUnitName,
item.ProductName == null ? "" : item.ProductName,
item.Amount,
item.PaymentDate,
item.StatusName == null ? "" : item.StatusName
);
}
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", "PaymentProduct.xlsx"));
}
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 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 ExportExcel(int pageIndex, int pageSize, ListFilterParam list, string filter = "")
{
filter = filter.Replace("!!", "%");
DataTable dt = new DataTable("Grid");
if (list.filter7 == "1")
{
dt.Columns.AddRange(new DataColumn[7]
{
new DataColumn(AppRes.Staff),
new DataColumn(AppRes.OrganizationUnit),
new DataColumn(AppRes.ShareRate),
new DataColumn(AppRes.StartDate),
new DataColumn(AppRes.EndDate),
new DataColumn(AppRes.Note),
new DataColumn(AppRes.Company)
});
dt.Columns[0].DataType = typeof(string);
dt.Columns[1].DataType = typeof(string);
dt.Columns[2].DataType = typeof(double);
dt.Columns[3].DataType = typeof(DateTime);
dt.Columns[4].DataType = typeof(DateTime);
dt.Columns[5].DataType = typeof(string);
dt.Columns[6].DataType = typeof(string);
}
else
{
dt.Columns.AddRange(new DataColumn[6]
{
new DataColumn(AppRes.OrganizationUnit),
new DataColumn(AppRes.ShareRate),
new DataColumn(AppRes.StartDate),
new DataColumn(AppRes.EndDate),
new DataColumn(AppRes.Note),
new DataColumn(AppRes.Company)
});
dt.Columns[0].DataType = typeof(string);
dt.Columns[1].DataType = typeof(double);
dt.Columns[2].DataType = typeof(DateTime);
dt.Columns[3].DataType = typeof(DateTime);
dt.Columns[4].DataType = typeof(string);
dt.Columns[5].DataType = typeof(string);
}
var db = new ShareRateSalaryCostDAL();
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,
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 = new List <ShareRateSalaryCost>();
if (list.filter7 == "1")
{
lstData = db.GetShareRateSalaryCostByStaff(baseListParam, 1, list, out total, out totalColumns);
}
else
{
lstData = db.GetShareRateSalaryCostByDept(baseListParam, 1, list, out total, out totalColumns);
}
foreach (var item in lstData)
{
if (list.filter7 == "1")
{
dt.Rows.Add(
item.OrganizationUnitName == null ? "" : item.OrganizationUnitName,
item.StaffName == null ? "" : item.StaffName,
Double.Parse(String.Format("{0:###0.##}", item.ShareRate)),
item.StartDate,
item.EndDate,
item.Note == null ? "" : item.Note,
item.CompanyName == null ? "" : item.CompanyName);
}
else
{
dt.Rows.Add(
item.OrganizationUnitName == null ? "" : item.OrganizationUnitName,
Double.Parse(String.Format("{0:###0.##}", item.ShareRate)),
item.StartDate,
item.EndDate,
item.Note == null ? "" : item.Note,
item.CompanyName == null ? "" : item.CompanyName);
}
}
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 "1":
// code block
excelName = "Ty le share bao cao chi phi luong theo nhan vien.xlsx";
break;
default:
// code block
excelName = "Ty le share bao cao chi phi luong theo phong ban.xlsx";
break;
}
return(File(data, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", excelName));
}
public ActionResult ExportListReopenCampaign(int pageIndex, int pageSize, ListFilterParam list, string filter = "")
{
filter = filter.Replace("!!", "%");
DataTable dt = new DataTable("Grid");
dt.Columns.AddRange(new DataColumn[6]
{
new DataColumn(AppRes.ErpCampaignID),
new DataColumn(AppRes.ReopenBy),
new DataColumn(AppRes.OrganizationUnit),
new DataColumn(AppRes.ReasonReopenCampaign),
new DataColumn(AppRes.MediaAccount),
new DataColumn(AppRes.TimeReopenCampaign)
});
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(DateTime);
var db = new CampaignDAL();
int?total = 0;
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.ExportListReopenCampaign(baseListParam, list, out total);
foreach (var item in lstData)
{
dt.Rows.Add(
item.CampaignId == null ? "" : item.CampaignId,
item.ReopenBy == null ? "" : item.ReopenBy,
item.OrginizationUnit == null ? "" : item.OrginizationUnit,
item.Reason == null ? "" : item.Reason,
item.Requester == null ? "" : item.Requester,
item.ReopenDate == null ? new DateTime(1, 1, 1) : item.ReopenDate
);
}
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 = "ListCampaignReopen.xlsx";
return(File(data, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", excelName));
}
public ActionResult DetailAccountReportExportExcel(int pageIndex, int pageSize, ListFilterParam list, string filter = "")
{
filter = filter.Replace("!!", "%");
DateTime FromDateTypeDate = new DateTime();
DateTime ToDateTypeDate = new DateTime();
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));
DataTable dt = new DataTable("Grid");
dt.Columns.AddRange(new DataColumn[11]
{
new DataColumn(AppRes.AccCode),
new DataColumn(AppRes.TitleAccount),
new DataColumn(AppRes.AccountStatus),
new DataColumn(AppRes.AccountLevel),
new DataColumn(AppRes.isPartner),
new DataColumn(AppRes.CalculationDate),
new DataColumn(AppRes.BD),
new DataColumn(AppRes.OrganizationUnitName),
new DataColumn(AppRes.Category),
new DataColumn(AppRes.T),
new DataColumn(AppRes.AccountConverted)
});
dt.Columns[0].DataType = typeof(string);
dt.Columns[1].DataType = typeof(double);
dt.Columns[2].DataType = typeof(string);
dt.Columns[3].DataType = typeof(string);
dt.Columns[4].DataType = typeof(bool);
dt.Columns[5].DataType = typeof(DateTime);
dt.Columns[6].DataType = typeof(string);
dt.Columns[7].DataType = typeof(string);
dt.Columns[8].DataType = typeof(string);
dt.Columns[9].DataType = typeof(double);
dt.Columns[10].DataType = typeof(double);
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 = int.MaxValue,
LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
};
var lstData = db.ExportExcelDetailAccountReport(baseListParam, list);
foreach (var item in lstData)
{
dt.Rows.Add(
item.CustomerCode,
item.AccountNumber,
item.StatusAccount == null ? "" : item.StatusAccount,
item.AccountLevel == null ? "" : item.AccountLevel,
item.IsPartner,
item.FirstDateLinked,
item.BD,
item.Department,
item.AccountType == null ? "" : item.AccountType,
item.T == null ? 0 : item.T,
item.AccountConversion == null ? 0 : item.AccountConversion
);
}
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", "DetailAccountReport.xlsx"));
}
public ActionResult TableServerSideGetDataPaymentRefer(int pageIndex, int pageSize, ListFilterParam list, 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.GetPaymentProductRefer(baseListParam, list, 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 PaymentReferExportExcel(int pageIndex, int pageSize, ListFilterParam list, string filter = "")
{
filter = filter.Replace("!!", "%");
DateTime FromDateTypeDate = new DateTime();
DateTime ToDateTypeDate = new DateTime();
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));
DataTable dt = new DataTable("Grid");
dt.Columns.AddRange(new DataColumn[8]
{
new DataColumn(AppRes.CustomerCode),
new DataColumn(AppRes.Email),
new DataColumn(AppRes.ContractCode),
new DataColumn(AppRes.PaymentDate),
new DataColumn(AppRes.BD),
new DataColumn(AppRes.OrganizationUnitName),
new DataColumn(AppRes.Amount),
new DataColumn(AppRes.AccountConverted)
});
dt.Columns[0].DataType = typeof(string);
dt.Columns[1].DataType = typeof(string);
dt.Columns[2].DataType = typeof(string);
dt.Columns[3].DataType = typeof(DateTime);
dt.Columns[4].DataType = typeof(string);
dt.Columns[5].DataType = typeof(string);
dt.Columns[6].DataType = typeof(double);
dt.Columns[7].DataType = typeof(double);
var db = new PaymentProductDAL();
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 = int.MaxValue,
LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
};
var lstData = db.ExportExcelPaymentRefer(baseListParam, list, out total);
foreach (var item in lstData)
{
dt.Rows.Add(
item.CustomerCode,
item.Email,
item.ContractCode == null ? "" : item.ContractCode,
item.PaymentDate,
item.BD == null ? "" : item.BD,
item.OrganizationUnitName == null ? "" : item.OrganizationUnitName,
item.Amount,
item.AccountConversion
);
}
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", "ReportsMarginRefer.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[17]
{
new DataColumn(AppRes.DeptName),
new DataColumn(AppRes.Staff),
new DataColumn(AppRes.VIP),
new DataColumn(AppRes.Advanced),
new DataColumn(AppRes.Standard),
new DataColumn(AppRes.Substandard),
new DataColumn(AppRes.Invalid),
new DataColumn(AppRes.VIPS),
new DataColumn(AppRes.AdvancedS),
new DataColumn(AppRes.StandardS),
new DataColumn(AppRes.AccountsConvertedBySpending),
new DataColumn(AppRes.FeeAmount),
new DataColumn(AppRes.MarginR),
new DataColumn(AppRes.AccountsConvertedByMargin),
new DataColumn(AppRes.TotalAccountConversion),
new DataColumn(AppRes.RateACBSPerTAC),
new DataColumn(AppRes.RateOfMarginFeePerTotalMargin),
});
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(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);
}
else
{
dt.Columns.AddRange(new DataColumn[16]
{
new DataColumn(AppRes.DeptName),
new DataColumn(AppRes.VIP),
new DataColumn(AppRes.Advanced),
new DataColumn(AppRes.Standard),
new DataColumn(AppRes.Substandard),
new DataColumn(AppRes.Invalid),
new DataColumn(AppRes.VIPS),
new DataColumn(AppRes.AdvancedS),
new DataColumn(AppRes.StandardS),
new DataColumn(AppRes.AccountsConvertedBySpending),
new DataColumn(AppRes.FeeAmount),
new DataColumn(AppRes.MarginR),
new DataColumn(AppRes.AccountsConvertedByMargin),
new DataColumn(AppRes.TotalAccountConversion),
new DataColumn(AppRes.RateACBSPerTAC),
new DataColumn(AppRes.RateOfMarginFeePerTotalMargin),
});
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);
}
var db = new ReportAccountByStaffDAL();
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.ExportReportAccountByStaff(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.VIP == null ? 0 : item.VIP,
item.Advanced == null ? 0 : item.Advanced,
item.Standard == null ? 0 : item.Standard,
item.Substandard == null ? 0 : item.Substandard,
item.Invalid == null ? 0 : item.Invalid,
item.VIPS == null ? 0 : item.VIPS,
item.AdvancedS == null ? 0 : item.AdvancedS,
item.StandardS == null ? 0 : item.StandardS,
item.AccountsConvertedBySpending == null ? 0 : item.AccountsConvertedBySpending,
item.FeeAmount == null ? 0 : item.FeeAmount,
item.Margin == null ? 0 : item.Margin,
item.AccountsConvertedByMargin == null ? 0 : item.AccountsConvertedByMargin,
item.TotalAccountsConverted == null ? 0 : item.TotalAccountsConverted,
item.RateACBSPerTAC == null ? 0 : item.RateACBSPerTAC,
item.RateOfMarginFeePerTotalMargin == null ? 0 : item.RateOfMarginFeePerTotalMargin);
}
else
{
dt.Rows.Add(
item.OrganizationUnitName == null ? "" : item.OrganizationUnitName,
item.VIP == null ? 0 : item.VIP,
item.Advanced == null ? 0 : item.Advanced,
item.Standard == null ? 0 : item.Standard,
item.Substandard == null ? 0 : item.Substandard,
item.Invalid == null ? 0 : item.Invalid,
item.VIPS == null ? 0 : item.VIPS,
item.AdvancedS == null ? 0 : item.AdvancedS,
item.StandardS == null ? 0 : item.StandardS,
item.AccountsConvertedBySpending == null ? 0 : item.AccountsConvertedBySpending,
item.FeeAmount == null ? 0 : item.FeeAmount,
item.Margin == null ? 0 : item.Margin,
item.AccountsConvertedByMargin == null ? 0 : item.AccountsConvertedByMargin,
item.TotalAccountsConverted == null ? 0 : item.TotalAccountsConverted,
item.RateACBSPerTAC == null ? 0 : item.RateACBSPerTAC,
item.RateOfMarginFeePerTotalMargin == null ? 0 : item.RateOfMarginFeePerTotalMargin);
}
}
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 = "ReportAccountByStaff.xlsx";
break;
case "1":
// code block
excelName = "ReportAccountByDepartment.xlsx";
break;
}
return(File(data, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", excelName));
}
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 <ShareRateSalaryCost> GetShareRateSalaryCostByDept(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>("GetShareRateSalaryCostByDept", param).ToList();
param = HttpRuntime.Cache.Get("GetShareRateSalaryCostByDept-" + 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();
totalRecord = param.GetDataOutput <int>("@TotalRecord");
return(list);
}
catch (Exception ex)
{
totalColumns = new TableColumnsTotal();
totalRecord = 0;
return(new List <ShareRateSalaryCost>());
}
}
public ActionResult ExportExcelMCCAcountExclude(int pageIndex, int pageSize, ListFilterParam list, string filter = "")
{
DataTable dt = new DataTable("Grid");
dt.Columns.AddRange(new DataColumn[9]
{
new DataColumn(AppRes.AccountNumber),
new DataColumn(AppRes.StartDate),
new DataColumn(AppRes.EndDate),
new DataColumn(AppRes.Status),
new DataColumn(AppRes.CreatedBy),
new DataColumn(AppRes.CreatedDate),
new DataColumn(AppRes.ModifiedBy),
new DataColumn(AppRes.ModifiedDate),
new DataColumn(AppRes.Note)
});
dt.Columns[0].DataType = typeof(long);
dt.Columns[1].DataType = typeof(DateTime);
dt.Columns[2].DataType = typeof(DateTime);
dt.Columns[3].DataType = typeof(int);
dt.Columns[4].DataType = typeof(int);
dt.Columns[5].DataType = typeof(DateTime);
dt.Columns[6].DataType = typeof(int);
dt.Columns[7].DataType = typeof(DateTime);
var db = new MCCAccountExcludeDAL();
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 = int.MaxValue,
LanguageCode = Global.CurrentUser.CurrentLanguageID.ToString()
};
var lstData = db.ExportExcelMCCAccountExclude(baseListParam, out total);
foreach (var item in lstData)
{
dt.Rows.Add(
item.AccountNumber,
item.StartDate,
item.EndDate,
item.Status,
item.CreatedBy,
item.CreatedOn,
item.ModifiedBy,
item.ModifiedOn,
item.Note
);
}
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", "MCCAccountExclude.xlsx"));
}
public List <ReportAccountByStaff> GetReportAccountByStaff(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("@CurrencyID", currencyID);
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("@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);
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 = 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();
return(list);
}
catch (Exception ex)
{
totalRecord = 0;
totalColumns = new TableColumnsTotal();
return(new List <ReportAccountByStaff>());
}
}
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 List <ShareRateForPerformanceReport> GetShareRateForPerformanceReportbyOrganizationUnit(BaseListParam listParam, ListFilterParam listFilterParam, out int?totalRecord)
{
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("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
var list = UnitOfWork.Procedure <ShareRateForPerformanceReport>("GetShareRateForPerformanceReportbyOrganizationUnit", param).ToList();
param = HttpRuntime.Cache.Get("GetShareRateForPerformanceReportbyOrganizationUnit-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + HRM.Common.Global.CurrentUser.UserID + "-output") as DynamicParameters;
totalRecord = param.GetDataOutput <int>("@TotalRecord");
return(list);
}
catch (Exception ex)
{
totalRecord = 0;
return(new List <ShareRateForPerformanceReport>());
}
}
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 List <PaymentProductRefer> GetPaymentProductRefer(BaseListParam listParam, ListFilterParam listFilterParam, 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("@CurrencyID", 0);
param.Add("@Branchid", 0);
param.Add("@IsNewCustomer", 0);
param.Add("@startdate", listFilterParam.FromDate);
param.Add("@enddate", listFilterParam.ToDate);
param.Add("@RoleId", listParam.UserType);
param.Add("@DepartmentId", 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);
param.Add("@Total3", dbType: DbType.Double, direction: ParameterDirection.Output);
param.Add("@Total4", dbType: DbType.Double, direction: ParameterDirection.Output);
var list = UnitOfWork.Procedure <PaymentProductRefer>("ReportsMarginRefer", param).ToList();
param = HttpRuntime.Cache.Get("ReportsMarginRefer-" + 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();
return(list);
}
catch (Exception ex)
{
totalRecord = 0;
totalColumns = new TableColumnsTotal();
return(new List <PaymentProductRefer>());
}
}
public List <ReportSpendingByAccountNumber> ExportReportSpendingByAccountNumber(BaseListParam listParam, ListFilterParam listFilterParam)
{
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("@LanguageID", listParam.LanguageCode);
param.Add("@FromDate", listFilterParam.FromDate);
param.Add("@ToDate", listFilterParam.ToDate);
param.Add("@ReportType", listFilterParam.filter7);
var list = UnitOfWork.Procedure <ReportSpendingByAccountNumber>("ReportSpendingByAccountNumber", param).ToList();
return(list);
}
catch (Exception ex)
{
return(new List <ReportSpendingByAccountNumber>());
}
}
