public Sal_UnusualAllowanceModel Post([Bind]Sal_UnusualAllowanceModel model)
{
#region Validate
string message = string.Empty;
var checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<Sal_UnusualAllowanceModel>(model, "Sal_UnusualEDChildCareInfo", "Sal_UnusualAllowance", ref message);
if (!checkValidate)
{
model.ActionStatus = message;
return model;
}
if (model.RelativeID != null)
{
checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<Sal_UnusualAllowanceModel>(model, "Sal_UnusualEDChildCareDuplicate", "Sal_UnusualAllowance", ref message);
if (!checkValidate)
{
model.ActionStatus = message;
return model;
}
}
else
{
checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<Sal_UnusualAllowanceModel>(model, "Sal_UnusualEDChildCareDuplicate1", "Sal_UnusualAllowance", ref message);
if (!checkValidate)
{
model.ActionStatus = message;
return model;
}
}
DateTime now = model.MonthEnd.Value;
int age = now.Year - model.MonthStart.Value.Year;
if (now < model.MonthStart.Value.AddYears(age)) age--;
if (age > 18)
{
model.ActionStatus = "Con nhân viên không được vượt quá 18 tuổi";
return model;
}
#endregion
string status = string.Empty;
var relativeServices = new Hre_RelativesServices();
var objRelatives = new List<object>();
objRelatives.AddRange(new object[11]);
objRelatives[9] = 1;
objRelatives[10] = int.MaxValue - 1;
var lstRelatives = relativeServices.GetData<Hre_RelativesEntity>(objRelatives, ConstantSql.hrm_hr_sp_get_Relatives, UserLogin, ref status).ToList();
if (model.RelativeID != null)
{
var dateNow = DateTime.Now;
var entity = lstRelatives.Where(s => s.ID == model.RelativeID).FirstOrDefault();
if (entity != null)
{
if (!string.IsNullOrEmpty(entity.YearOfBirth))
{
var strDob = entity.YearOfBirth.Split('/');
// var dob = DateTime.Parse(entity.YearOfBirth);
var checkDob = (dateNow.Year - int.Parse(strDob[2])) * 12 + dateNow.Month - int.Parse(strDob[1]);
if (checkDob >= 216)
{
model.ActionStatus = ConstantMessages.WarningRelativeGreaterThan18.ToString().TranslateString();
return model;
}
}
}
}
ActionService service = new ActionService(UserLogin);
return service.UpdateOrCreate<Sal_UnusualAllowanceEntity, Sal_UnusualAllowanceModel>(model);
}
public DataTable GetReportHaveChildUsunual(string orderNumberOrg, DateTime? dateFrom, DateTime? dateTo, string UserLogin, bool IsCreateTemplate)
{
DataTable table = CreateReportHaveChildUsunualSchema();
if (IsCreateTemplate)
{
return table;
}
using (var context = new VnrHrmDataContext())
{
string status = string.Empty;
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var orgTypeServices = new Cat_OrgStructureTypeServices();
var objOrgType = new List<object>();
objOrgType.Add(null);
objOrgType.Add(null);
objOrgType.Add(1);
objOrgType.Add(int.MaxValue - 1);
var lstOrgType = orgTypeServices.GetData<Cat_OrgStructureTypeEntity>(objOrgType, ConstantSql.hrm_cat_sp_get_OrgStructureType, UserLogin, ref status).ToList();
var orgServices = new Cat_OrgStructureServices();
var objOrg = new List<object>();
objOrg.Add(null);
objOrg.Add(null);
objOrg.Add(null);
objOrg.Add(1);
objOrg.Add(int.MaxValue - 1);
var lstOrg = orgServices.GetData<Cat_OrgStructureEntity>(objOrg, ConstantSql.hrm_cat_sp_get_OrgStructure, UserLogin, ref status).ToList();
//if (lstOrgType != null)
//{
// lstOrg = lstOrg.Where(s => s.OrgStructureTypeID != null && s.OrgStructureTypeID == lstOrgType.ID).ToList();
//}
var lstOrgNumber = lstOrg.Select(s => s.OrderNumber).ToList();
var strOrderNumber = string.Join(",", lstOrgNumber);
var profileServices = new Hre_ProfileServices();
var objProfile = new List<object>();
objProfile.Add(strOrderNumber);
objProfile.Add(null);
objProfile.Add(null);
var lstProfile = profileServices.GetData<Hre_ProfileEntity>(objProfile, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrg, UserLogin, ref status).ToList();
var relativeServices = new Hre_RelativesServices();
var objRelative = new List<object>();
objRelative.AddRange(new object[11]);
objRelative[9] = 1;
objRelative[10] = int.MaxValue - 1;
var lstRelatives = relativeServices.GetData<Hre_RelativesEntity>(objRelative, ConstantSql.hrm_hr_sp_get_Relatives, UserLogin, ref status).ToList();
var repoCat_OrgStructure = new CustomBaseRepository<Cat_OrgStructure>(unitOfWork);
var repoCat_OrgStructureType = new Cat_OrgStructureTypeRepository(unitOfWork);
var orgs = repoCat_OrgStructure.FindBy(s => s.IsDelete == null).ToList();
var orgTypes = repoCat_OrgStructureType.FindBy(s => s.IsDelete == null).ToList();
var UnusualAllowance = new Sal_UnusualAllowanceServices();
var objUnusualAllowance = new List<object>();
objUnusualAllowance.AddRange(new object[7]);
objUnusualAllowance[3] = dateFrom;
objUnusualAllowance[4] = dateTo;
objUnusualAllowance[5] = 1;
objUnusualAllowance[6] = int.MaxValue - 1;
List<Sal_UnusualAllowanceEntity> listUnusualAllowance = UnusualAllowance.GetData<Sal_UnusualAllowanceEntity>(objUnusualAllowance, ConstantSql.hrm_sal_sp_get_UnusualEDChildCare, UserLogin, ref status);
//lọc nhân viên có hưởng phụ cấp con nhỏ
lstProfile = lstProfile.Where(m => listUnusualAllowance.Any(t => t.ProfileID == m.ID)).ToList();
foreach (var item in lstProfile)
{
DataRow dr = table.NewRow();
var lstRelativeByProfileID = lstRelatives.Where(s => s.ProfileID == item.ID).ToList();
if (lstRelativeByProfileID.Count == 0)
{
continue;
}
Guid? orgId = item.OrgStructureID;
var unit = LibraryService.GetNearestParent(orgId, OrgUnit.E_UNIT, orgs, orgTypes);
var division = LibraryService.GetNearestParent(orgId, OrgUnit.E_DIVISION, orgs, orgTypes);
var department = LibraryService.GetNearestParent(orgId, OrgUnit.E_DEPARTMENT, orgs, orgTypes);
var section = LibraryService.GetNearestParent(orgId, OrgUnit.E_SECTION, orgs, orgTypes);
dr[Sal_ReportHaveChildUsunualEntity.FieldNames.CodeEmp] = item.CodeEmp;
dr[Sal_ReportHaveChildUsunualEntity.FieldNames.ProfileName] = item.ProfileName;
dr[Sal_ReportHaveChildUsunualEntity.FieldNames.E_UNIT] = item.E_UNIT;
dr[Sal_ReportHaveChildUsunualEntity.FieldNames.E_DIVISION] = item.E_DIVISION;
dr[Sal_ReportHaveChildUsunualEntity.FieldNames.E_DEPARTMENT] = item.E_DEPARTMENT;
dr[Sal_ReportHaveChildUsunualEntity.FieldNames.E_TEAM] = item.E_TEAM;
dr[Sal_ReportHaveChildUsunualEntity.FieldNames.E_SECTION] = item.E_SECTION;
if (lstRelativeByProfileID.Count > 0)
{
var count = 0;
foreach (var relative in lstRelativeByProfileID)
{
var _tmp = new DateTime();
count++;
if (count == 11)
{
break;
}
if (relative.YearOfBirth != null)
{
var strYearOfBirth = relative.YearOfBirth.Split('/');
var newYOB = new DateTime(int.Parse(strYearOfBirth[2]), int.Parse(strYearOfBirth[1]), int.Parse(strYearOfBirth[0]));
var dateCheck = DateTime.Now;
var age = (dateCheck.Subtract(_tmp).TotalDays / 30) / 12;
dr[Sal_ReportHaveChildUsunualEntity.FieldNames.RelativeName + count] = relative.RelativeName;
dr[Sal_ReportHaveChildUsunualEntity.FieldNames.DateBorn + count] = newYOB;
}
}
}
table.Rows.Add(dr);
}
return table.ConfigTable(true);
}
}