public DataTable GetReportNotHaveSocial(DateTime? dateFrom, DateTime? dateTo, string OrgStructureID,string userLogin) { using (var context = new VnrHrmDataContext()) { string status = string.Empty; //string type_COLLECT_SOCIAL_INSURANCE = AppConfig.E_COLLECT_SOCIAL_INSURANCE.ToString(); //bool _e_PROBATION_NoPay_INSURANCE = false; var profileServices = new Hre_ProfileServices(); DataTable table = GetReportNotHaveSocialSchema(); var lstObjProfile = new List<object>(); lstObjProfile.Add(OrgStructureID); lstObjProfile.Add(null); lstObjProfile.Add(null); var lstProfile = profileServices.GetData<Hre_ProfileEntity>(lstObjProfile, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrg, userLogin, ref status).ToList(); var gradePayrollService = new Cat_GradePayrollServices(); var lstObjGradePayroll = new List<object>(); lstObjGradePayroll.Add(null); lstObjGradePayroll.Add(null); lstObjGradePayroll.Add(1); lstObjGradePayroll.Add(int.MaxValue -1); var contractServices = new Hre_ContractServices(); var lstObjContract = new List<object>(); lstObjContract.AddRange(new object[15]); lstObjContract[13] = 1; lstObjContract[14] = int.MaxValue -1; var provinceServices = new Cat_ProvinceServices(); var lstObjProvince = new List<object>(); lstObjProvince.Add(null); lstObjProvince.Add(null); lstObjProvince.Add(null); lstObjProvince.Add(null); lstObjProvince.Add(null); lstObjProvince.Add(null); var lstProvince = provinceServices.GetData<Cat_ProvinceEntity>(lstObjProvince, ConstantSql.hrm_cat_sp_get_Province, userLogin, ref status).ToList(); foreach (var item in lstProfile) { DataRow dr = table.NewRow(); dr[Ins_ReportNotHaveSocialEntity.FieldNames.ID] = item.ID; dr[Ins_ReportNotHaveSocialEntity.FieldNames.CodeEmp] = item.CodeEmp == null ? string.Empty : item.CodeEmp; dr[Ins_ReportNotHaveSocialEntity.FieldNames.ProfileName] = item.ProfileName == null ? string.Empty : item.ProfileName; dr[Ins_ReportNotHaveSocialEntity.FieldNames.E_DEPARTMENT] = item.OrgStructureName == null ? string.Empty : item.E_DEPARTMENT; dr[Ins_ReportNotHaveSocialEntity.FieldNames.E_DIVISION] = item.OrgStructureName == null ? string.Empty : item.E_DIVISION; dr[Ins_ReportNotHaveSocialEntity.FieldNames.E_SECTION] = item.OrgStructureName == null ? string.Empty : item.E_SECTION; dr[Ins_ReportNotHaveSocialEntity.FieldNames.E_TEAM] = item.OrgStructureName == null ? string.Empty : item.E_TEAM; dr[Ins_ReportNotHaveSocialEntity.FieldNames.E_UNIT] = item.OrgStructureName == null ? string.Empty : item.E_UNIT; dr[Ins_ReportNotHaveSocialEntity.FieldNames.PositionName] = item.PositionName == null ? string.Empty : item.PositionName; dr[Ins_ReportNotHaveSocialEntity.FieldNames.JobTitleName] = item.JobTitleName == null ? string.Empty : item.JobTitleName; dr[Ins_ReportNotHaveSocialEntity.FieldNames.EthnicGroupName] = item.EthnicGroupName == null ? string.Empty : item.EthnicGroupName; dr[Ins_ReportNotHaveSocialEntity.FieldNames.HealthTreatmentPlace] = item.HealthTreatmentPlace == null ? string.Empty : item.HealthTreatmentPlace; dr[Ins_ReportNotHaveSocialEntity.FieldNames.HealthTreatmentPlaceCode] = item.HealthTreatmentPlaceCode == null ? string.Empty : item.HealthTreatmentPlaceCode; var province = lstProvince.Where(s => s.ID == item.PlaceOfIssueID).FirstOrDefault(); if(province != null) { dr[Ins_ReportNotHaveSocialEntity.FieldNames.IDPOI_Code] = province.Code == null ? string.Empty : province.Code; dr[Ins_ReportNotHaveSocialEntity.FieldNames.IDPOI] = province.ProvinceName == null ? string.Empty : province.ProvinceName; } dr[Ins_ReportNotHaveSocialEntity.FieldNames.Origin] = item.Origin == null ? string.Empty : item.Origin; dr[Ins_ReportNotHaveSocialEntity.FieldNames.PAddress] = item.PAddress == null ? string.Empty : item.PAddress; dr[Ins_ReportNotHaveSocialEntity.FieldNames.TAddress] = item.TAddress == null ? string.Empty : item.TAddress; if (item.DateHire != null) { dr[Ins_ReportNotHaveSocialEntity.FieldNames.DateHire] = item.DateHire.Value; } if (item.DateQuit != null) { dr[Ins_ReportNotHaveSocialEntity.FieldNames.DateHire] = item.DateQuit.Value; } if (item.DateOfBirth != null) { dr[Ins_ReportNotHaveSocialEntity.FieldNames.DateOfBirth] = item.DateOfBirth.Value; } var provinceTreatment = lstProvince.Where(s => s.ID == item.ProvinceInsuranceID).FirstOrDefault(); if (provinceTreatment != null) { dr[Ins_ReportNotHaveSocialEntity.FieldNames.PlaceOfTreatmentProvince] = provinceTreatment.Code == null ? string.Empty : provinceTreatment.Code; } table.Rows.Add(dr); } return table; } }
public DataTable GetReportNotHaveSocial(DateTime?dateFrom, DateTime?dateTo, string OrgStructureID, string userLogin) { using (var context = new VnrHrmDataContext()) { string status = string.Empty; //string type_COLLECT_SOCIAL_INSURANCE = AppConfig.E_COLLECT_SOCIAL_INSURANCE.ToString(); //bool _e_PROBATION_NoPay_INSURANCE = false; var profileServices = new Hre_ProfileServices(); DataTable table = GetReportNotHaveSocialSchema(); var lstObjProfile = new List <object>(); lstObjProfile.Add(OrgStructureID); lstObjProfile.Add(null); lstObjProfile.Add(null); var lstProfile = profileServices.GetData <Hre_ProfileEntity>(lstObjProfile, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrg, userLogin, ref status).ToList(); var gradePayrollService = new Cat_GradePayrollServices(); var lstObjGradePayroll = new List <object>(); lstObjGradePayroll.Add(null); lstObjGradePayroll.Add(null); lstObjGradePayroll.Add(1); lstObjGradePayroll.Add(int.MaxValue - 1); var contractServices = new Hre_ContractServices(); var lstObjContract = new List <object>(); lstObjContract.AddRange(new object[15]); lstObjContract[13] = 1; lstObjContract[14] = int.MaxValue - 1; var provinceServices = new Cat_ProvinceServices(); var lstObjProvince = new List <object>(); lstObjProvince.Add(null); lstObjProvince.Add(null); lstObjProvince.Add(null); lstObjProvince.Add(null); lstObjProvince.Add(null); lstObjProvince.Add(null); var lstProvince = provinceServices.GetData <Cat_ProvinceEntity>(lstObjProvince, ConstantSql.hrm_cat_sp_get_Province, userLogin, ref status).ToList(); foreach (var item in lstProfile) { DataRow dr = table.NewRow(); dr[Ins_ReportNotHaveSocialEntity.FieldNames.ID] = item.ID; dr[Ins_ReportNotHaveSocialEntity.FieldNames.CodeEmp] = item.CodeEmp == null ? string.Empty : item.CodeEmp; dr[Ins_ReportNotHaveSocialEntity.FieldNames.ProfileName] = item.ProfileName == null ? string.Empty : item.ProfileName; dr[Ins_ReportNotHaveSocialEntity.FieldNames.E_DEPARTMENT] = item.OrgStructureName == null ? string.Empty : item.E_DEPARTMENT; dr[Ins_ReportNotHaveSocialEntity.FieldNames.E_DIVISION] = item.OrgStructureName == null ? string.Empty : item.E_DIVISION; dr[Ins_ReportNotHaveSocialEntity.FieldNames.E_SECTION] = item.OrgStructureName == null ? string.Empty : item.E_SECTION; dr[Ins_ReportNotHaveSocialEntity.FieldNames.E_TEAM] = item.OrgStructureName == null ? string.Empty : item.E_TEAM; dr[Ins_ReportNotHaveSocialEntity.FieldNames.E_UNIT] = item.OrgStructureName == null ? string.Empty : item.E_UNIT; dr[Ins_ReportNotHaveSocialEntity.FieldNames.PositionName] = item.PositionName == null ? string.Empty : item.PositionName; dr[Ins_ReportNotHaveSocialEntity.FieldNames.JobTitleName] = item.JobTitleName == null ? string.Empty : item.JobTitleName; dr[Ins_ReportNotHaveSocialEntity.FieldNames.EthnicGroupName] = item.EthnicGroupName == null ? string.Empty : item.EthnicGroupName; dr[Ins_ReportNotHaveSocialEntity.FieldNames.HealthTreatmentPlace] = item.HealthTreatmentPlace == null ? string.Empty : item.HealthTreatmentPlace; dr[Ins_ReportNotHaveSocialEntity.FieldNames.HealthTreatmentPlaceCode] = item.HealthTreatmentPlaceCode == null ? string.Empty : item.HealthTreatmentPlaceCode; var province = lstProvince.Where(s => s.ID == item.PlaceOfIssueID).FirstOrDefault(); if (province != null) { dr[Ins_ReportNotHaveSocialEntity.FieldNames.IDPOI_Code] = province.Code == null ? string.Empty : province.Code; dr[Ins_ReportNotHaveSocialEntity.FieldNames.IDPOI] = province.ProvinceName == null ? string.Empty : province.ProvinceName; } dr[Ins_ReportNotHaveSocialEntity.FieldNames.Origin] = item.Origin == null ? string.Empty : item.Origin; dr[Ins_ReportNotHaveSocialEntity.FieldNames.PAddress] = item.PAddress == null ? string.Empty : item.PAddress; dr[Ins_ReportNotHaveSocialEntity.FieldNames.TAddress] = item.TAddress == null ? string.Empty : item.TAddress; if (item.DateHire != null) { dr[Ins_ReportNotHaveSocialEntity.FieldNames.DateHire] = item.DateHire.Value; } if (item.DateQuit != null) { dr[Ins_ReportNotHaveSocialEntity.FieldNames.DateHire] = item.DateQuit.Value; } if (item.DateOfBirth != null) { dr[Ins_ReportNotHaveSocialEntity.FieldNames.DateOfBirth] = item.DateOfBirth.Value; } var provinceTreatment = lstProvince.Where(s => s.ID == item.ProvinceInsuranceID).FirstOrDefault(); if (provinceTreatment != null) { dr[Ins_ReportNotHaveSocialEntity.FieldNames.PlaceOfTreatmentProvince] = provinceTreatment.Code == null ? string.Empty : provinceTreatment.Code; } table.Rows.Add(dr); } return(table); } }
/// <summary> /// get levelinterview and jobvancyID from Rec_interview by CandidateID /// </summary> /// <param name="ID"></param> /// <returns></returns> public JsonResult GetCandidateID(Guid ID) { var result = new List<Rec_InterviewModel>(); string status = string.Empty; if (ID != Guid.Empty) { var service = new Cat_ProvinceServices(); result = service.GetData<Rec_InterviewModel>(ID, ConstantSql.hrm_rec_sp_get_CandidateId, UserLogin, ref status); } return Json(result, JsonRequestBehavior.AllowGet); }
public JsonResult GetJobTypeCascading(Guid RoleID, string jobtitleFilter) { var result = new List<Cat_JobTypeModel>(); string status = string.Empty; if (RoleID != Guid.Empty) { var service = new Cat_ProvinceServices(); result = service.GetData<Cat_JobTypeModel>(RoleID, ConstantSql.hrm_cat_sp_get_JobTypeByRoleId, UserLogin, ref status); if (!string.IsNullOrEmpty(jobtitleFilter)) { var rs = result.Where(s => s.JobTypeName != null && s.JobTypeName.ToLower().Contains(jobtitleFilter.ToLower())).ToList(); return Json(rs, JsonRequestBehavior.AllowGet); } } return Json(result, JsonRequestBehavior.AllowGet); }
public JsonResult GetVillageCascading(Guid districtid, string villageFilter) { var result = new List<Cat_VillageModel>(); string status = string.Empty; if (districtid != Guid.Empty) { var service = new Cat_ProvinceServices(); result = service.GetData<Cat_VillageModel>(districtid, ConstantSql.hrm_cat_sp_get_VillageByDistrictId, UserLogin, ref status); result = result.OrderBy(s => s.VillageName).ToList(); if (!string.IsNullOrEmpty(villageFilter)) { var rs = result.Where(s => s.VillageName != null && s.VillageName.ToLower().Contains(villageFilter.ToLower())).OrderBy(s => s.VillageName).ToList(); return Json(rs, JsonRequestBehavior.AllowGet); } } return Json(result, JsonRequestBehavior.AllowGet); }
public JsonResult GetProvinceCascading(Guid country, string provinceFilter) { var result = new List<CatProvinceModel>(); string status = string.Empty; if (country != Guid.Empty) { var service = new Cat_ProvinceServices(); result = service.GetData<CatProvinceModel>(country, ConstantSql.hrm_cat_sp_get_ProvinceByCountryId, UserLogin, ref status); result = result.OrderBy(s => s.ProvinceName).ToList(); if (!string.IsNullOrEmpty(provinceFilter)) { var rs = result.Where(s => s.ProvinceName != null && s.ProvinceName.ToLower().Contains(provinceFilter.ToLower())).ToList(); rs = rs.OrderBy(s => s.ProvinceName).ToList(); return Json(rs, JsonRequestBehavior.AllowGet); } } return Json(result, JsonRequestBehavior.AllowGet); }