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 <OrganizationEntity> GetAllOrganizationForDropDown(BasicParamType param)
{
var par = new DynamicParameters();
par.Add("@BaseParam", param.ToUserDefinedDataTable(), DbType.Object);
return(ListProcedure <OrganizationEntity>("Organization_Get_GetAllOrganizationForDropDown", par, dbName: param.DbName));
}
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 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 string GetWorkingProcessByStaff(BasicParamType param, long staffId, out int totalRecord)
{
var result = new List <WorkingProcessEntity>();
var staffResponse = this._workingProcessRepository.GetWorkingProcessByStaff(param, staffId, out totalRecord);
return(JsonConvert.SerializeObject(staffResponse));
}
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 HrmResultEntity <StaffContractEntity> GetCurrentStaffContractByStaff(BasicParamType param, long staffId)
{
var par = new DynamicParameters();
par.Add("@BaseParam", param.ToUserDefinedDataTable(), DbType.Object);
par.Add("@StaffId", staffId);
return(ListProcedure <StaffContractEntity>("Staff_Get_GetCurrentStaffContractByStaff", par, dbName: param.DbName));
}
public HrmResultEntity <HealthInsuranceEntity> GetHealthInsuranceByStaff(BasicParamType param, long staffId)
{
var par = new DynamicParameters();
par.Add("@BaseParam", param.ToUserDefinedDataTable(), DbType.Object);
par.Add("@StaffId", staffId, DbType.Int32);
return(ListProcedure <HealthInsuranceEntity>("Staff_Get_GetHealthInsuranceByStaff", par, dbName: param.DbName));
}
public HrmResultEntity <StaffBenefitsEntity> GetStaffBenefitByWorkingprocess(BasicParamType param, long workingprocessId)
{
var par = new DynamicParameters();
par.Add("@BaseParam", param.ToUserDefinedDataTable(), DbType.Object);
par.Add("@WorkingprocessId", workingprocessId, DbType.Int32);
return(ListProcedure <StaffBenefitsEntity>("Staff_Get_GetStaffBenefitByWorkingprocess", par, dbName: param.DbName));
}
public HrmResultEntity <WorkingProcessEntity> GetStaffSalary(BasicParamType param, long staffId)
{
var par = new DynamicParameters();
par.Add("@BaseParam", param.ToUserDefinedDataTable(), DbType.Object);
par.Add("@StaffId", staffId);
return(ListProcedure <WorkingProcessEntity>("Staff_Get_GetStaffSalary", par, dbName: param.DbName));
}
public HrmResultEntity <ConfigInsuranceEntity> GetCurrentConfigInsurance(BasicParamType param)
{
var par = new DynamicParameters();
par.Add("@BaseParam", param.ToUserDefinedDataTable(), DbType.Object);
var result = ListProcedure <ConfigInsuranceEntity>("ConfigInsurance_Get_GetCurrentConfigInsurance", par, dbName: param.DbName);
return(result);
}
public HrmResultEntity <WorkingProcessEntity> GetSalaryDetailById(BasicParamType param, long id)
{
var par = new DynamicParameters();
par.Add("@Id", id);
par.Add("@DbName", param.DbName);
par.Add("@UserID", param.UserId);
par.Add("@RoleID", param.RoleId);
return(ListProcedure <WorkingProcessEntity>("Staff_Get_GetSalaryDetailById", par, dbName: param.DbName));
}
public HrmResultEntity <PayrollEntity> GetPayrollById(long id, BasicParamType param)
{
var par = new DynamicParameters();
par.Add("@Id", id);
par.Add("@BaseParam", param.ToUserDefinedDataTable(), DbType.Object);
var result = ListProcedure <PayrollEntity>("Payroll_Get_GetPayrollById", par, dbName: param.DbName);
return(result);
}
public HrmResultEntity <EmailEntity> GetEmail(BasicParamType param, bool isMailWelcomeKit)
{
var par = new DynamicParameters();
par.Add("@IsMailWelcomeKit", isMailWelcomeKit);
par.Add("@BaseParam", param.ToUserDefinedDataTable(), DbType.Object);
var result = ListProcedure <EmailEntity>("Email_Get_GetEmail", par, dbName: param.DbName);
return(result);
}
public HrmResultEntity <bool> SavePassword(BasicParamType param, string newPassword, int staffId)
{
var par = new DynamicParameters();
par.Add("@BaseParam", param.ToUserDefinedDataTable(), DbType.Object);
par.Add("@NewPassword", newPassword);
par.Add("@StaffId", staffId);
par.Add("@Result", 0, DbType.Int32, ParameterDirection.InputOutput);
return(Procedure("Password_Update_SavePassword", par));
}
public HrmResultEntity <StaffCertificateEntity> GetStaffCertificateById(BasicParamType param, long id)
{
var par = new DynamicParameters();
par.Add("@Id", id);
par.Add("@DbName", param.DbName);
par.Add("@UserID", param.UserId);
par.Add("@RoleID", param.RoleId);
return(ListProcedure <StaffCertificateEntity>("Staff_Get_GetStaffCertificateById", par, dbName: param.DbName));
}
public HrmResultEntity <bool> CheckContractCodeExisted(BasicParamType param, string contractCode, long id, out bool result)
{
var par = new DynamicParameters();
par.Add("@BaseParam", param.ToUserDefinedDataTable(), DbType.Object);
par.Add("@Id", id);
par.Add("@ContractCode", contractCode);
par.Add("@Result", 0, DbType.Boolean, ParameterDirection.InputOutput);
var response = ListProcedure <bool>("WorkingProcess_Get_CheckContractCodeExisted", par);
result = par.GetDataOutput <bool>("@Result");
return(response);
}
public HrmResultEntity <bool> CheckNextPipeLineStep(BasicParamType param, long pipeLineSteffId, long staffId, out bool result)
{
var par = new DynamicParameters();
par.Add("@PipelineStepIdNew", pipeLineSteffId);
par.Add("@StaffId", staffId);
par.Add("@DbName", param.DbName);
par.Add("@UserID", param.UserId);
par.Add("@RoleID", param.RoleId);
par.Add("@Result", 0, DbType.Boolean, ParameterDirection.InputOutput);
var response = ListProcedure <bool>("Staff_Get_CheckNextPipeLineStep", par);
result = par.GetDataOutput <bool>("@Result");
return(response);
}
public HrmResultEntity <bool> SaveStaff(StaffEntity data, BasicParamType param)
{
var par = new DynamicParameters();
par.Add("@StaffCode", data.StaffCode);
par.Add("@Name", data.Name);
par.Add("@Birthday", data.Birthday);
par.Add("@GenderId", data.GenderId);
par.Add("@CurrentWorkingProcessId", data.CurrentWorkingProcessId);
par.Add("@Email", data.Email);
par.Add("@Phone", data.Phone);
par.Add("@PhoneCompany", data.PhoneCompany);
par.Add("@Skype", data.Skype);
par.Add("@IdentityNumber", data.IdentityNumber);
par.Add("@IdIssuedDate", data.IdIssuedDate);
par.Add("@IdIssuedBy", data.IdIssuedBy);
par.Add("@TaxId", data.TaxId);
par.Add("@TaxDate", data.TaxDate);
par.Add("@TaxBy", data.TaxBy);
par.Add("@UserName", data.UserName);
par.Add("@BankNumber", data.BankNumber);
par.Add("@BankName", data.BankName);
par.Add("@BankBranch", data.BankBranch);
par.Add("@Address", data.Address);
par.Add("@ContactAddress", data.ContactAddress);
par.Add("@NationalId", data.NationalId);
par.Add("@LinkFacebook", data.LinkFacebook);
par.Add("@ImageLink", data.ImageLink);
par.Add("@EmailCompany", data.EmailCompany);
par.Add("@PresentationContactName", data.PresentationContactName);
par.Add("@PresentationContactPhone", data.PresentationContactPhone);
par.Add("@Note", data.Note);
par.Add("@IsSendCheckList", data.IsSendChecklist);
par.Add("@SendCheckListDate", data.SendCheckListDate);
par.Add("@SendCheckListBy", data.SendCheckListBy);
par.Add("@IsDeleted", data.IsDeleted);
par.Add("@EthnicityId", data.EthnicityId);
par.Add("@MaritalStatus", data.MaritalStatus);
par.Add("@IsOnboarding", data.IsOnboarding);
par.Add("@OnboardingDate", data.OnboardingDate);
par.Add("@CreatedBy", param.UserId);
par.Add("@DbName", param.DbName);
par.Add("@Id", data.Id, DbType.Int32, ParameterDirection.InputOutput);
var result = Procedure("Staff_Update_SaveShortStaff", par);
return(result);
}
public HrmResultEntity <PayrollEntity> SavePayroll(PayrollEntity payroll, BasicParamType param)
{
var par = new DynamicParameters();
par.Add("@Id", payroll.Id);
par.Add("@SalaryTypeId", payroll.SalaryTypeId);
par.Add("@Name", payroll.Name);
par.Add("@Description", payroll.Description);
par.Add("@MonthYear", payroll.MonthYear);
par.Add("@Status", payroll.Status);
par.Add("@PaymentDate", payroll.PaymentDate);
par.Add("@BaseParam", param.ToUserDefinedDataTable(), DbType.Object);
var result = ListProcedure <PayrollEntity>("Payroll_Update_SavePayroll", par, useCache: false);
return(result);
}
public HrmResultEntity <WorkingdayPeriodEntity> GetWorkingdayPeriod(BasicParamType param, out int totalRecord)
{
//FilterField :
var par = new DynamicParameters();
par.Add("@BaseParam", param.ToUserDefinedDataTable(), DbType.Object);
par.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
var result = ListProcedure <WorkingdayPeriodEntity>("WorkingDayCalculationPeriod_Get_GetPeriod", par, dbName: param.DbName);
if (result.StatusCode != StatusCode.AccessDenied)
{
totalRecord = par.GetDataOutput <int>("@TotalRecord");
}
else
{
totalRecord = 0;
}
return(result);
}
public HrmResultEntity <OrganizationEntity> GetOrganization(BasicParamType param, out int totalRecord)
{
var par = new DynamicParameters();
par.Add("@BaseParam", param.ToUserDefinedDataTable(), DbType.Object);
par.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
var result = ListProcedure <OrganizationEntity>("Organization_Get_GetOrganization", par, dbName: param.DbName);
if (result.StatusCode != StatusCode.AccessDenied)
{
par = HttpRuntime.Cache.Get(param.DbName + "-Organization_Get_GetOrganization-" + GetKeyFromParam(par as object) + "-" + CurrentUser.UserId + "-output") as DynamicParameters;
totalRecord = par.GetDataOutput <int>("@TotalRecord");
}
else
{
totalRecord = 0;
}
return(result);
}
public HrmResultEntity <StaffEntity> SearchStaff(BasicParamType param, string searchKey, out int totalRecord)
{
var par = new DynamicParameters();
par.Add("@BaseParam", param.ToUserDefinedDataTable(), DbType.Object);
par.Add("@SearchKey", searchKey);
par.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.InputOutput);
var result = ListProcedure <StaffEntity>("System_Get_GlobalSearchStaff", par, dbName: param.DbName);
if (result.StatusCode != StatusCode.AccessDenied)
{
par = HttpRuntime.Cache.Get(param.DbName + "-System_Get_GlobalSearchStaff-" + GetKeyFromParam(par as object) + "-" + CurrentUser.UserId + "-output") as DynamicParameters;
totalRecord = par.GetDataOutput <int>("@TotalRecord");
}
else
{
totalRecord = 0;
}
return(result);
}
public string GetCurrentConfigInsuranceDetail(BasicParamType param, long insuranceId, out int totalRecord)
{
var response = this._configInsuranceDetailRepository.GetCurrentConfigInsuranceDetail(param, insuranceId, out totalRecord);
return(JsonConvert.SerializeObject(response));
}
public string GetSupplementConfigurationException(BasicParamType param, out int totalRecord)
{
var result = this._workingDaySupplementConfigurationExceptionRepository.GetSupplementConfigurationException(param, out totalRecord);
return(JsonConvert.SerializeObject(result));
}
public HrmResultEntity <OrganizationEntity> SaveMergerOrganization(OrganizationEntity data, List <ListDataSelectedIdType> listData, BasicParamType param, string dbName)
{
var par = new DynamicParameters();
par.Add("@BaseParam", param.ToUserDefinedDataTable(), DbType.Object);
par.Add("@ListData", listData.ConvertToUserDefinedDataTable(), DbType.Object);
par.Add("@ToOrganizationaID", data.Id);
par.Add("@DecisionNo", data.DecisionNo);
par.Add("@WorkingStatus", MasterDataId.WorkingStatusActive);
par.Add("@DecisionDate", data.DecisionDate);
par.Add("@StartDate", data.StartDate);
par.Add("@EndDate", data.EndDate);
par.Add("@Note", data.Note);
par.Add("@OrganizationName", data.OrganizationName);
par.Add("@OrganizationCode", data.OrganizationCode);
par.Add("@OrderNo", data.OrderNo);
par.Add("@ParentId", data.ParentId);
par.Add("@Status", data.Status);
par.Add("@OrganizationType", data.OrganizationType);
par.Add("@Email", data.Email);
par.Add("@Phone", data.Phone);
par.Add("@Branch", data.Branch);
par.Add("@CurrencyTypeId", data.CurrencyTypeId);
par.Add("@DbName", dbName);
return(ListProcedure <OrganizationEntity>("Organization_Update_Merger", par));
}
public HrmResultEntity <bool> savePersonnelTransfer(WorkingProcessEntity data, BasicParamType param)
{
var par = new DynamicParameters();
par.Add("@StaffId", data.StaffId);
par.Add("@OrganizationId", data.OrganizationId);
par.Add("@Note", data.Note);
par.Add("@DbName", param.DbName);
return(Procedure("Organization_Update_SavePersonnelTransfer", par));
}
public HrmResultEntity <OrganizationEntity> SaveOrganization(OrganizationEntity data, BasicParamType param)
{
var par = new DynamicParameters();
par.Add("@Id", data.Id);
par.Add("@OrganizationName", data.OrganizationName);
par.Add("@OrganizationCode", data.OrganizationCode);
par.Add("@OrderNo", data.OrderNo);
par.Add("@ParentId", data.ParentId);
par.Add("@Status", data.Status);
par.Add("@OrganizationType", data.OrganizationType);
par.Add("@Email", data.Email);
par.Add("@Phone", data.Phone);
par.Add("@Branch", data.Branch);
par.Add("@CurrencyTypeId", data.CurrencyTypeId);
par.Add("@CreatedBy", data.CreatedBy);
par.Add("@UpdatedBy", data.UpdatedBy);
par.Add("@DbName", param.DbName);
return(ListProcedure <OrganizationEntity>("Organization_Update_SaveOrganization", par));
}
public string GetSalary(BasicParamType param, int month, int year, long staffId, out string outTotalJson, out int totalRecord)
{
var response = _salaryRepository.GetSalary(param, month, year, staffId, out outTotalJson, out totalRecord);
return(JsonConvert.SerializeObject(response));
}
public string GetSupplementConfigurationByRoleId(BasicParamType param, out int totalRecord)
{
var staffResponse = this._workingDaySupplementConfigurationRepository.GetSupplementConfigurationByRoleId(param, out totalRecord);
return(JsonConvert.SerializeObject(staffResponse));
}