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