public Sys_AllSettingModel Get(string id) { string status = string.Empty; ActionService service = new ActionService(UserLogin); var model = service.GetFirstData<Sys_AllSettingModel>(id, ConstantSql.hrm_sys_sp_get_AllSettingByKey, ref status); if (model != null) { return (Sys_AllSettingModel)model; } return null; }
public Sys_AllSettingModel Get(string id) { string status = string.Empty; ActionService service = new ActionService(UserLogin); var model = service.GetFirstData <Sys_AllSettingModel>(id, ConstantSql.hrm_sys_sp_get_AllSettingByKey, ref status); if (model != null) { return((Sys_AllSettingModel)model); } return(null); }
/// [Hieu.Van] - 2014/07/02 Lấy Mã Thẻ(CardCode) theo mã Nhân Viên(Hre_Profile) public JsonResult GetCardCodeByProfileId(Guid id) { var service = new ActionService(UserLogin); var status = string.Empty; var fieldData = service.GetFirstData<Hre_ProfileCodeEntity>(id, ConstantSql.hrm_hre_sp_get_Profile_CardCodeByProfileID, ref status); List<object> listObj = new List<object>(); listObj.Add(status); listObj.Add(fieldData); return Json(listObj, JsonRequestBehavior.AllowGet); }
public Hre_ContractEntity SetNewDateEndNextContractByContractAndNextContractID(Hre_ContractEntity contractEntity, Guid nextContractID) { if (contractEntity != null) { var actionService = new ActionService(UserLogin); var status = string.Empty; var objContractType = actionService.GetFirstData<Cat_ContractTypeEntity>(Common.DotNetToOracle(nextContractID.ToString()), ConstantSql.hrm_cat_sp_get_ContractTypeById, ref status); if (objContractType != null) { var contractTypeEntity = (Cat_ContractTypeEntity)objContractType; if (!string.IsNullOrEmpty(contractTypeEntity.Formula)) { var formula = contractTypeEntity.Formula.Replace("\n", "").Replace("\t", "").Replace("\r", ""); ElementFormula elementContactType = new ElementFormula("ContractType", contractTypeEntity.Type, 0); ElementFormula elementUnitType = new ElementFormula("UnitType", contractTypeEntity.UnitTime, 0); ElementFormula elementValueTime = new ElementFormula("ValueTime", contractTypeEntity.ValueTime, 0); ElementFormula elementDateStart = new ElementFormula("DateStart", contractEntity.DateStart, 0); var result = FormulaHelper.ParseFormula(formula, new List<ElementFormula>() { elementContactType, elementUnitType, elementDateStart, elementValueTime }); if (result != null && string.IsNullOrEmpty(result.ErrorMessage)) { if (result.Value.GetType().Name == "DateTime") { contractEntity.DateEndNextContract = (DateTime)result.Value; } else { contractEntity.ErrorMessage = contractEntity.ProfileName; } } } } } return contractEntity; }
public Hre_ContractEntity SetNewCodeContract(Hre_ContractEntity contractEntity, string strIdConstract) { if (contractEntity != null) { var actionService = new ActionService(UserLogin); var status = string.Empty; var objContractType1 = actionService.GetFirstData<Cat_ContractTypeEntity>(Common.DotNetToOracle(contractEntity.ContractTypeID.ToString()), ConstantSql.hrm_cat_sp_get_ContractTypeById, ref status); var objProfile1 = actionService.GetFirstData<Hre_ProfileEntity>(Common.DotNetToOracle(contractEntity.ProfileID.ToString()), ConstantSql.hrm_hr_sp_get_ProfileById, ref status); if (objContractType1 != null) { var contractType = (Cat_ContractTypeEntity)objContractType1; var profileEntity = (Hre_ProfileEntity)objProfile1; if (!string.IsNullOrEmpty(contractType.Type)) { var objSysConfig = actionService.GetFirstData<Sys_AllSettingEntity>(AppConfig.HRM_HRE_GENERATE_CODE_CONTRACT.ToString(), ConstantSql.hrm_sys_sp_get_AllSettingByKey, ref status); if (objSysConfig != null) { var sysConfig = (Sys_AllSettingEntity)objSysConfig; if (sysConfig != null && !string.IsNullOrEmpty(sysConfig.Value1)) { ElementFormula elementContactType = new ElementFormula("ContactType", contractType.Type, 0); ElementFormula elementCodeEmp = new ElementFormula("CodeEmp", profileEntity.CodeEmp, 0); ElementFormula elementOrdinal = new ElementFormula("Ordinal", 1, 0); var result = FormulaHelper.ParseFormula(sysConfig.Value1, new List<ElementFormula>() { elementContactType, elementCodeEmp }); if (result != null && string.IsNullOrEmpty(result.ErrorMessage)) { var value = result.Value; if (value != null) { string newCode = value.ToString(); if (newCode.EndsWith("Ordinal")) { var strNewCode = newCode.Substring(0, newCode.Length - 7); if (!string.IsNullOrEmpty(strIdConstract)) { var listContractType = actionService.GetData<Cat_ContractTypeEntity>(Common.DotNetToOracle(strIdConstract), ConstantSql.hrm_cat_sp_get_ContractTypeByIds, ref status); if (listContractType != null) { var listContractTypeById = listContractType.Where(d => d.Type == contractType.Type).FirstOrDefault(); if (listContractTypeById != null) { var listId = strIdConstract.Split(',').ToList(); var count = listId.Where(s => listContractTypeById.ID.ToString() == s).Select(d => d == listContractTypeById.ToString()).Count(); //var count = listContractTypeById.Count(); newCode = strNewCode + "-" + (count + 1); } else { //var listId = strIdConstract.Split(',').ToList(); //var count = listId.Select(d => d == listContractTypeById.ID.ToString()).Count(); newCode = strNewCode + "-" + "1"; } } else { newCode = strNewCode + "-" + 1; } } else { newCode = strNewCode + "-" + 1; } } contractEntity.ContractNo = newCode; } } } } } } contractEntity.ActionStatus = status; } return contractEntity; }