public HrmResultEntity <WorkingdayEntity> GetSummaryFinal(BasicParamType param, long staffId, int month, int year, out string outTotalJson, out int totalRecord)
{
//FilterField :
var par = new DynamicParameters();
par.Add("@BaseParam", param.ToUserDefinedDataTable(), DbType.Object);
par.Add("@StaffId", staffId);
par.Add("@Month", month);
par.Add("@Year", year);
par.Add("@OutTotalJson", "", DbType.String, ParameterDirection.InputOutput);
par.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
var result = ListProcedure <WorkingdayEntity>("WorkingdaySummary_Get_GetWorkingdaySummaryFinal", par, dbName: param.DbName);
if (result.StatusCode != StatusCode.AccessDenied)
{
outTotalJson = par.GetDataOutput <string>("@OutTotalJson");
totalRecord = par.GetDataOutput <int>("@TotalRecord");
}
else
{
totalRecord = 0;
outTotalJson = string.Empty;
}
return(result);
}
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 HrmResultEntity <SalaryEntity> GetSalary(BasicParamType param, int payrollId, int month, int year, long staffId, out string outTotalJson, out int totalRecord)
{
var par = new DynamicParameters();
par.Add("@BaseParam", param.ToUserDefinedDataTable(), DbType.Object);
par.Add("@PayrollId", payrollId);
par.Add("@Month", month);
par.Add("@Year", year);
par.Add("@StaffId", staffId);
par.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
par.Add("@OutTotalJson", "", DbType.String, ParameterDirection.InputOutput);
var result = ListProcedure <SalaryEntity>("Salary_Get_GetSalary_1", par, dbName: param.DbName);
if (result.StatusCode != StatusCode.AccessDenied)
{
par = HttpRuntime.Cache.Get(param.DbName + "-Salary_Get_GetSalary_1-" + GetKeyFromParam(par as object) + "-" + CurrentUser.UserId + "-output") as DynamicParameters;
totalRecord = par.GetDataOutput <int>("@TotalRecord");
outTotalJson = par.GetDataOutput <string>("@OutTotalJson");
}
else
{
totalRecord = 0;
}
outTotalJson = string.Empty;
return(result);
}
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 List <ReportAccountCS> ReportAccountCS_GetAccountNumber(int pageNumber, int pageSize, string filter, DateTime?date, out int total, out int total1)
{
try
{
var param = new DynamicParameters();
param.Add("@FilterField", filter);
param.Add("@PageNumber", pageNumber);
param.Add("@PageSize", pageSize);
param.Add("@Date", date);
param.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
param.Add("@TotalAccountActive", 0, DbType.Int32, ParameterDirection.InputOutput);
var list = UnitOfWork.Procedure <ReportAccountCS>("ReportAccountCS_GetAccountNumber", param).ToList();
total = param.GetDataOutput <int>("@TotalRecord");
total1 = param.GetDataOutput <int>("@TotalAccountActive");
return(list);
}
catch (Exception ex)
{
total = 0;
total1 = 0;
return(null);
}
finally
{
}
}
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 <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 <WorkingProcess> GetWorkingProcess(int pageNumber, int pageSize, string filter, out int total, int LanguageID, int RoleID, int UserID, int DeptID, int staffID, int OfficePositionID)
{
try
{
var param = new DynamicParameters();
param.Add("@FilterField", filter);
param.Add("@OrderByField", "");
param.Add("@PageIndex", pageNumber);
param.Add("@PageSize", pageSize);
param.Add("@StaffID", staffID);
param.Add("@UserId", UserID);
param.Add("@RoleId", RoleID);
param.Add("@OfficePositionID", OfficePositionID);
param.Add("@DeptID", DeptID);
param.Add("@LanguageID", LanguageID);
param.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
var list = UnitOfWork.Procedure <WorkingProcess>("WorkingProcess_Gets", param).ToList();
var userId = Global.CurrentUser.UserID;
param = HttpRuntime.Cache.Get("WorkingProcess_Gets-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + userId + "-output") as DynamicParameters;
total = param.GetDataOutput <int>("@TotalRecord");
return(list);
}
catch (Exception ex)
{
total = 0;
return(null);
}
}
public List <HR_WorkingDaySummary> ExportExcelTimeKeeping(BaseListParam listParam, int month, int year, out int?totalRecord)
{
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", 0, DbType.Int32, ParameterDirection.InputOutput);
var list = UnitOfWork.Procedure <HR_WorkingDaySummary>("HR_WorkingDaySummary_GetManager", param).ToList();
totalRecord = param.GetDataOutput <int>("@TotalRecord");
return(list);
}
catch (Exception e)
{
totalRecord = 0;
return(new List <HR_WorkingDaySummary>());
}
}
public SystemMessage LatchesWorkDayBack(string ListID, bool isCheckAll, int month, int year, int UserID, int RoleID)
{
SystemMessage systemMessage = new SystemMessage();
try
{
var param1 = new DynamicParameters();
param1.Add("@ListStaff", ListID);
param1.Add("@isCheckAll", isCheckAll);
param1.Add("@UserID", UserID);
param1.Add("@RoleID", RoleID);
param1.Add("@month", month);
param1.Add("@year", year);
param1.Add("@result", 0, DbType.Int32, ParameterDirection.InputOutput);
UnitOfWork.ProcedureExecute("PublishWorkingdayBack", param1);
systemMessage.existedResult = param1.GetDataOutput <int>("@result");
if (systemMessage.existedResult > 0)
{
systemMessage.IsSuccess = true;
}
else
{
systemMessage.IsSuccess = false;
}
return(systemMessage);
}
catch (Exception e)
{
systemMessage.IsSuccess = false;
systemMessage.Message = e.ToString();
return(systemMessage);
}
}
public SystemMessage Delete(ShareRateSalaryCost obj)
{
SystemMessage systemMessage = new SystemMessage();
try
{
var param = new DynamicParameters();
param.Add("@Id", obj.Id);
param.Add("@ModifiedBy", obj.ModifiedBy);
param.Add("@Type", obj.Type);
param.Add("@Result", 0, DbType.Int32, ParameterDirection.InputOutput);
UnitOfWork.ProcedureExecute("DeleteShareRateSalaryCost", param);
systemMessage.existedResult = param.GetDataOutput <int>("Result");
systemMessage.IsSuccess = systemMessage.existedResult != -1;
return(systemMessage);
}
catch (Exception e)
{
systemMessage.IsSuccess = false;
systemMessage.Message = e.ToString();
return(systemMessage);
}
}
public List <OrganizationUnit> GetOrganizationUnitForEmployee(int pageNumber, int pageSize, string filter, out int total, int usertype, int userid)
{
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("@UserType", usertype);
param.Add("@UserID", userid);
param.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
param.Add("@UserType", usertype);
param.Add("@UserID", userid);
var list = UnitOfWork.Procedure <OrganizationUnit>("OrganizationUnit_List", param).ToList();
var userId = Global.CurrentUser.UserID;
param = HttpRuntime.Cache.Get("OrganizationUnit_List-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + userId + "-output") as DynamicParameters;
total = param.GetDataOutput <int>("@TotalRecord");
return(list);
}
catch (Exception ex)
{
total = 0;
return(null);
}
}
public List <SocialInsuranceDetail> GetSocialInsuranceDetail(BaseListParam listParam, out int?total, int staffID)
{
try
{
var param = new DynamicParameters();
param.Add("@FilterField", listParam.FilterField);
param.Add("@OrderByField", "");
param.Add("@PageIndex", listParam.PageIndex);
param.Add("@PageSize", listParam.PageSize);
param.Add("@StaffID", staffID);
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 <SocialInsuranceDetail>("SocialInsuranceDetail_Gets", param).ToList();
param = HttpRuntime.Cache.Get("SocialInsuranceDetail_Gets-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + HRM.Common.Global.CurrentUser.UserID + "-output") as DynamicParameters;
total = param.GetDataOutput <int>("@TotalRecord");
return(list);
}
catch (Exception ex)
{
total = 0;
return(null);
}
}
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 HrmResultEntity <WorkingdayAllStaffEntity> GetWorkingdayAllStaff(BasicParamType param, long staffId, int month, int year, long organizationId, out int totalRecord)
{
//FilterField :
var par = new DynamicParameters();
par.Add("@BaseParam", param.ToUserDefinedDataTable(), DbType.Object);
par.Add("@StaffId", staffId);
par.Add("@Month", month);
par.Add("@Year", year);
par.Add("@OrganizationId", organizationId);
par.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
var result = ListProcedure <WorkingdayAllStaffEntity>("WorkingdaySummary_Get_GetWorkingdayAllStaff", par, dbName: param.DbName);
if (result.StatusCode != StatusCode.AccessDenied)
{
par = HttpRuntime.Cache.Get(param.DbName + "-WorkingdaySummary_Get_GetWorkingdayAllStaff-" + GetKeyFromParam(par as object) + "-" + CurrentUser.UserId + "-output") as DynamicParameters;
totalRecord = par.GetDataOutput <int>("@TotalRecord");
}
else
{
totalRecord = 0;
}
return(result);
}
public HrmResultEntity <WorkingdayFurlough> GetWorkingdayFurlough(BasicParamType param, long starffId, long organizationId, out int totalRecord)
{
var par = new DynamicParameters();
par.Add("@BaseParam", param.ToUserDefinedDataTable(), DbType.Object);
par.Add("@StaffId", starffId);
par.Add("@OrganizationId", organizationId);
par.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
var result = ListProcedure <WorkingdayFurlough>("WorkingdayAnnualLeave_Get_GetWorkingdayFurlough", par, dbName: param.DbName);
if (result.StatusCode != StatusCode.AccessDenied)
{
var parCache = HttpRuntime.Cache.Get(param.DbName + "-WorkingdayAnnualLeave_Get_GetWorkingdayFurlough-" + GetKeyFromParam(par as object) + "-" + CurrentUser.UserId + "-output") as DynamicParameters;
if (parCache != null)
{
par = parCache;
}
totalRecord = par.GetDataOutput <int>("@TotalRecord");
}
else
{
totalRecord = 0;
}
return(result);
}
public SystemMessage OpeningAdditionalWorkDelete(int AutoID, out int Status)
{
SystemMessage systemMessage = new SystemMessage();
try
{
var param = new DynamicParameters();
param.Add("@AutoID", AutoID);
param.Add("@Status", 0, DbType.Int32, ParameterDirection.InputOutput);
UnitOfWork.ProcedureExecute("OpeningAdditionalWorkDelete", param);
Status = param.GetDataOutput <int>("@Status");
if (Status == 0)
{
systemMessage.IsSuccess = true;
}
else
{
systemMessage.IsSuccess = false;
}
return(systemMessage);
}
catch (Exception e)
{
systemMessage.IsSuccess = false;
systemMessage.Message = e.ToString();
Status = 0;
return(systemMessage);
}
}
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 <MCCAccountExclude> ExportExcelMCCAccountExclude(BaseListParam listParam, 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("@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");
return(list);
}
catch (Exception e)
{
totalRecord = 0;
return(new List <MCCAccountExclude>());
}
}
public List <HR_WorkingDaySupplement> GetHR_WorkingDaySupplement(BaseListParam listParam, out int?totalRecord)
{
try
{
var param = new DynamicParameters();
if (listParam.FilterField.Contains("AND a.AutoID IN ("))
{
listParam.PageIndex = 1;
listParam.PageSize = 50000;
}
param.Add("@FilterField", listParam.FilterField);
param.Add("@OrderByField", listParam.OrderByField);
param.Add("@PageIndex", listParam.PageIndex);
param.Add("@PageSize", listParam.PageSize);
param.Add("@UserId", HRM.Common.Global.CurrentUser.UserID);
param.Add("@LanguageId", int.Parse(listParam.LanguageCode));
param.Add("@CurrentType", listParam.UserType);
param.Add("@TotalRecord", dbType: DbType.Int32, direction: ParameterDirection.Output);
var list = UnitOfWork.Procedure <HR_WorkingDaySupplement>("HR_WorkingDaySupplement_Get", param).ToList();
param = HttpRuntime.Cache.Get("HR_WorkingDaySupplement_Get-" + 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(null);
}
}
public List <EmployeeAllowance> GetEmployeeAllowance(int pageNumber, int pageSize, string filter, out int total, int LanguageID, int RoleID, int UserID, int DeptID, int wpID)
{
try
{
var param = new DynamicParameters();
param.Add("@FilterField", filter);
//param.Add("@OrderByField", "");
//param.Add("@PageIndex", pageNumber);
param.Add("@OrderBy", "");
param.Add("@PageNumber", pageNumber);
param.Add("@PageSize", pageSize);
param.Add("@type", 1);
//param.Add("@WPID", wpID);
//param.Add("@UserId", UserID);
//param.Add("@RoleId", RoleID);
//param.Add("@DeptID", DeptID);
//param.Add("@LanguageID", LanguageID);
param.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
var list = UnitOfWork.Procedure <EmployeeAllowance>("EmployeeAllowance_List", param).ToList();
var userId = Global.CurrentUser.UserID;
param = HttpRuntime.Cache.Get("EmployeeAllowance_List-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + userId + "-output") as DynamicParameters;
total = param.GetDataOutput <int>("@TotalRecord");
return(list);
}
catch (Exception ex)
{
total = 0;
return(null);
}
}
public SystemMessage RemoveLatchesWorkDay(BaseListParam listParam, string ListID, bool isCheckAll, int month, int year, int Period, out int result)
{
SystemMessage systemMessage = new SystemMessage();
try
{
var param = new DynamicParameters();
param.Add("@ListStaff", ListID);
param.Add("@isCheckAll ", isCheckAll);
param.Add("@UserID", listParam.UserId);
param.Add("@RoleID", listParam.UserType);
param.Add("@month", month);
param.Add("@year", year);
param.Add("@Period", Period);
param.Add("@result", 0, DbType.Int32, ParameterDirection.InputOutput);
UnitOfWork.ProcedureExecute("PublishPaymentSalaryBack", param);
result = param.GetDataOutput <int>("@result");
systemMessage.IsSuccess = true;
return(systemMessage);
}
catch (Exception e)
{
result = 0;
systemMessage.IsSuccess = false;
systemMessage.Message = e.ToString();
return(systemMessage);
}
}
public SystemMessage Save(BaseListParam listParam, ShareRateForPerformanceReport obj)
{
SystemMessage systemMessage = new SystemMessage();
try
{
var param = new DynamicParameters();
param.Add("@Id", obj.Id);
param.Add("@StaffId", obj.StaffId);
param.Add("@OrganizationUnitId", obj.OrganizationUnitId);
param.Add("@ShareRate", obj.ShareRate);
param.Add("@StartDate", obj.StartDate);
param.Add("@EndDate", obj.EndDate);
param.Add("@Note", obj.Note);
param.Add("@Status", obj.Status);
param.Add("@PerformanceReportId", obj.PerformanceReportId);
param.Add("@ModifiedDate", obj.ModifiedDate);
param.Add("@ModifiedBy", obj.ModifiedBy);
param.Add("@Type", obj.Type);
param.Add("@Result", 0, DbType.Int32, ParameterDirection.InputOutput);
UnitOfWork.ProcedureExecute("SaveShareRateForPerformanceReport", param);
systemMessage.existedResult = param.GetDataOutput <int>("Result");
systemMessage.IsSuccess = systemMessage.existedResult != -1;
return(systemMessage);
}
catch (Exception e)
{
systemMessage.IsSuccess = false;
systemMessage.Message = e.ToString();
return(systemMessage);
}
}
public List <OrganizationUnit> GetOrganizationUnit(BaseListParam listParam, out int?totalRecord)
{
try
{
var param = new DynamicParameters();
if (listParam.FilterField != null)
{
if (listParam.FilterField.Contains("StatusName") == true)
{
listParam.FilterField = listParam.FilterField.Replace("StatusName", "Status");
}
}
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 <OrganizationUnit>("OrganizationUnit_List_All", param).ToList();
param = HttpRuntime.Cache.Get("OrganizationUnit_List_All-" + 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(null);
}
}
public List <PaymentProductRefer> ExportExcelPaymentRefer(BaseListParam listParam, ListFilterParam listFilterParam, out int?totalRecord)
{
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", 194);
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");
return(list);
}
catch (Exception e)
{
totalRecord = 0;
return(new List <PaymentProductRefer>());
}
}
public List <Sec_Role> ExportExcelSecRole(string filter)
{
int total = 0;
try
{
var param = new DynamicParameters();
param.Add("@FilterField", filter);
param.Add("@OrderBy", "");
param.Add("@PageNumber", 1);
param.Add("@PageSize", 10);
param.Add("@Type", 2);
param.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
var list = UnitOfWork.Procedure <Sec_Role>("sec_Role_List", param).ToList();
var userId = Global.CurrentUser.UserID;
param = HttpRuntime.Cache.Get("sec_Role_List-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + userId + "-output") as DynamicParameters;
total = param.GetDataOutput <int>("@TotalRecord");
return(list);
}
catch (Exception)
{
total = 0;
return(null);
}
}
public List <Merge> Merge_GetList(int pageNumber, int pageSize, string filter, int LanguageCode, int WorkingDayMachineID, int StaffID, out int total)
{
try
{
//UnitOfWork.ConnectionString = ERP.Framework.Common.Utils.GetSetting<string>("NovaonADConnection");
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("@WorkingDayMachineID", WorkingDayMachineID);
param.Add("@StaffID", StaffID);
param.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
var list = UnitOfWork.Procedure <Merge>("CHECKINOUT_GetList", param, useCache: true).ToList();
var userId = Global.CurrentUser.UserID;
param = HttpRuntime.Cache.Get("CHECKINOUT_GetList-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + userId + "-output") as DynamicParameters;
total = param.GetDataOutput <int>("@TotalRecord");
return(list);
}
catch (Exception ex)
{
total = 0;
return(null);
}
finally
{
//UnitOfWork.ConnectionString = null;
}
}
public List <Timekeeping_ManagerVacation> GetWorkingDaySupplementManager(BaseListParam listParam, int month, int year, out int?totalRecord)
{
try
{
var param = new DynamicParameters();
param.Add("@FilterField", listParam.FilterField);
param.Add("@UserId", listParam.UserId);
param.Add("@OrderByField", null);
param.Add("@PageIndex", listParam.PageIndex);
param.Add("@PageSize", listParam.PageSize);
param.Add("@LanguageId", int.Parse(listParam.LanguageCode));
param.Add("@year", year);
param.Add("@TotalRecord", dbType: DbType.Int32, direction: ParameterDirection.Output);
var list = UnitOfWork.Procedure <Timekeeping_ManagerVacation>("HR_Furlough_GetManager", param).ToList();
var userId = Global.CurrentUser.UserID;
param = HttpRuntime.Cache.Get("HR_Furlough_GetManager-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + userId + "-output") as DynamicParameters;
totalRecord = param.GetDataOutput <int>("@TotalRecord");
return(list);
}
catch (Exception ex)
{
totalRecord = 0;
return(new List <Timekeeping_ManagerVacation>());
}
}
public List <Config_PersonalIncomeTax> Config_PersonalIncomeTax_GetList(int pageNumber, int pageSize, string filter, out int total)
{
try
{
//UnitOfWork.ConnectionString = ERP.Framework.Common.Utils.GetSetting<string>("NovaonADConnection");
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("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
var list = UnitOfWork.Procedure <Config_PersonalIncomeTax>("Config_PersonalIncomeTax_GetList", param).ToList();
var userId = Global.CurrentUser.UserID;
param = HttpRuntime.Cache.Get("Config_PersonalIncomeTax_GetList-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + userId + "-output") as DynamicParameters;
total = param.GetDataOutput <int>("@TotalRecord");
return(list);
}
catch (Exception ex)
{
total = 0;
return(null);
}
finally
{
//UnitOfWork.ConnectionString = null;
}
}
public List <Sys_Table_Column_list> Get_SyS_Table_CoLumn(int pageNumber, int pageSize, string filter, out int total)
{
try
{
var param = new DynamicParameters();
param.Add("@FilterField", "");
param.Add("@OrderBy", "");
param.Add("@PageNumber", pageNumber);
param.Add("@PageSize", pageSize);
param.Add("@Type", 1);
param.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
var list = UnitOfWork.Procedure <Sys_Table_Column_list>("Sys_table_column_Role_list", param).ToList();
var userId = Global.CurrentUser.UserID;
param = HttpRuntime.Cache.Get("Sys_table_column_Role_list-" + ERP.Framework.Common.Utils.GetKeyFromParam(param as object) + "-" + userId + "-output") as DynamicParameters;
total = param.GetDataOutput <int>("@TotalRecord");
return(list);
}
catch (Exception ex)
{
total = 0;
return(null);
}
finally
{
}
}
