public EmployerHistoryModel GetMonthsFromEmployerHistory(long TenantId, string EmpStartDate, string EmpTerminationDate) { ShomaRMEntities db = new ShomaRMEntities(); EmployerHistoryModel model = new EmployerHistoryModel(); try { int monthsCount = 0; string fromDateDB = string.Empty; string toDateDB = string.Empty; long ptoid = ShomaGroupWebSession.CurrentUser != null ? ShomaGroupWebSession.CurrentUser.UserID : 0; var empHist = db.tbl_EmployerHistory.Where(co => co.TenantId == TenantId && co.ParentTOID == ptoid).ToList(); if (empHist != null) { foreach (var item in empHist) { fromDateDB = Convert.ToString(item.StartDate.Value.ToString("MM/dd/yyyy")); toDateDB = Convert.ToString(item.TerminationDate.Value.ToString("MM/dd/yyyy")); DateTime dtFromDB = Convert.ToDateTime(fromDateDB); DateTime dtToDB = Convert.ToDateTime(toDateDB); int givenDate = ((dtToDB.Year - dtFromDB.Year) * 12) + dtToDB.Month - dtFromDB.Month; monthsCount += givenDate + 1; } } DateTime dtCurrentFromDB = Convert.ToDateTime(EmpStartDate); DateTime dtCurrentToDB = Convert.ToDateTime(EmpTerminationDate); int givenCurrentDate = ((dtCurrentToDB.Year - dtCurrentFromDB.Year) * 12) + dtCurrentToDB.Month - dtCurrentFromDB.Month; monthsCount += givenCurrentDate + 1; model.TotalMonthsEmployerHistory = monthsCount; db.Dispose(); return(model); } catch (Exception ex) { db.Database.Connection.Close(); throw ex; } }
public EmployerHistoryModel GetPriousEmploymentInfoPV(int id, long UserID) { EmployerHistoryModel model = new EmployerHistoryModel(); ShomaRMEntities db = new ShomaRMEntities(); long ptoid = UserID; var PriousEmploymentdata = db.tbl_EmployerHistory.Where(co => co.TenantId == id && co.ParentTOID == ptoid).OrderByDescending(s => s.HEIID).FirstOrDefault(); if (PriousEmploymentdata != null) { var countryName = db.tbl_Country.Where(co => co.ID == PriousEmploymentdata.Country).FirstOrDefault(); var StateName = db.tbl_State.Where(co => co.ID == PriousEmploymentdata.State).FirstOrDefault(); model.HEIID = PriousEmploymentdata.HEIID; model.EmployerName = !string.IsNullOrWhiteSpace(PriousEmploymentdata.EmployerName) ? PriousEmploymentdata.EmployerName : ""; model.JobTitle = !string.IsNullOrWhiteSpace(PriousEmploymentdata.JobTitle) ? PriousEmploymentdata.JobTitle : ""; model.JobType = PriousEmploymentdata.JobType; model.StartDate = PriousEmploymentdata.StartDate; model.TerminationDate = PriousEmploymentdata.TerminationDate; model.AnnualIncome = PriousEmploymentdata.AnnualIncome; model.AddAnnualIncome = PriousEmploymentdata.AddAnnualIncome; model.SupervisorName = !string.IsNullOrWhiteSpace(PriousEmploymentdata.SupervisorName) ? PriousEmploymentdata.SupervisorName : ""; model.SupervisorPhone = PriousEmploymentdata.SupervisorPhone; model.SupervisorEmail = !string.IsNullOrWhiteSpace(PriousEmploymentdata.SupervisorEmail) ? PriousEmploymentdata.SupervisorEmail : ""; model.Country = PriousEmploymentdata.Country; model.Address1 = !string.IsNullOrWhiteSpace(PriousEmploymentdata.Address1) ? PriousEmploymentdata.Address1 : ""; model.Address2 = !string.IsNullOrWhiteSpace(PriousEmploymentdata.Address2) ? PriousEmploymentdata.Address2 : ""; model.State = PriousEmploymentdata.State; model.City = !string.IsNullOrWhiteSpace(PriousEmploymentdata.City) ? PriousEmploymentdata.City : ""; model.Zip = !string.IsNullOrWhiteSpace(PriousEmploymentdata.Zip) ? PriousEmploymentdata.Zip : ""; model.StartDateString = PriousEmploymentdata.StartDate != null?PriousEmploymentdata.StartDate.Value.ToString("MM/dd/yyyy") : ""; model.TerminationDateString = PriousEmploymentdata.TerminationDate != null?PriousEmploymentdata.TerminationDate.Value.ToString("MM/dd/yyyy") : ""; model.TerminationReason = !string.IsNullOrWhiteSpace(PriousEmploymentdata.TerminationReason) ? PriousEmploymentdata.TerminationReason : ""; model.CountryName = countryName != null ? countryName.CountryName : ""; model.StateName = StateName != null ? StateName.StateName : ""; model.JobTypeName = PriousEmploymentdata.JobType == 1 ? "Permanent" : PriousEmploymentdata.JobType == 2 ? "Contract Basis" : ""; } return(model); }
public EmployerHistoryModel EditEmployerHistory(long HEIID) { EmployerHistoryModel model = new EmployerHistoryModel(); ShomaRMEntities db = new ShomaRMEntities(); var editEmployerHistorydata = db.tbl_EmployerHistory.Where(co => co.HEIID == HEIID).FirstOrDefault(); if (editEmployerHistorydata != null) { var countryName = db.tbl_Country.Where(co => co.ID == editEmployerHistorydata.Country).FirstOrDefault(); var StateName = db.tbl_State.Where(co => co.ID == editEmployerHistorydata.State).FirstOrDefault(); model.HEIID = editEmployerHistorydata.HEIID; model.EmployerName = !string.IsNullOrWhiteSpace(editEmployerHistorydata.EmployerName) ? editEmployerHistorydata.EmployerName : ""; model.JobTitle = editEmployerHistorydata.JobTitle; model.JobType = editEmployerHistorydata.JobType; model.StartDate = editEmployerHistorydata.StartDate; model.TerminationDate = editEmployerHistorydata.TerminationDate; model.AnnualIncome = editEmployerHistorydata.AnnualIncome; model.AddAnnualIncome = editEmployerHistorydata.AddAnnualIncome; model.SupervisorName = !string.IsNullOrWhiteSpace(editEmployerHistorydata.SupervisorName) ? editEmployerHistorydata.SupervisorName : ""; model.SupervisorPhone = editEmployerHistorydata.SupervisorPhone; model.SupervisorEmail = !string.IsNullOrWhiteSpace(editEmployerHistorydata.SupervisorEmail) ? editEmployerHistorydata.SupervisorEmail : ""; model.Country = editEmployerHistorydata.Country; model.Address1 = !string.IsNullOrWhiteSpace(editEmployerHistorydata.Address1) ? editEmployerHistorydata.Address1 : ""; model.Address2 = !string.IsNullOrWhiteSpace(editEmployerHistorydata.Address2) ? editEmployerHistorydata.Address2 : ""; model.State = editEmployerHistorydata.State; model.City = !string.IsNullOrWhiteSpace(editEmployerHistorydata.City) ? editEmployerHistorydata.City : ""; model.Zip = !string.IsNullOrWhiteSpace(editEmployerHistorydata.Zip) ? editEmployerHistorydata.Zip : ""; model.StartDateString = editEmployerHistorydata.StartDate != null?editEmployerHistorydata.StartDate.Value.ToString("MM/dd/yyyy") : ""; model.TerminationDateString = editEmployerHistorydata.TerminationDate != null?editEmployerHistorydata.TerminationDate.Value.ToString("MM/dd/yyyy") : ""; model.TerminationReason = !string.IsNullOrWhiteSpace(editEmployerHistorydata.TerminationReason) ? editEmployerHistorydata.TerminationReason : ""; model.CountryName = countryName != null ? countryName.CountryName : ""; model.StateName = StateName != null ? StateName.StateName : ""; model.JobTypeName = editEmployerHistorydata.JobType == 1 ? "Permanent" : editEmployerHistorydata.JobType == 2 ? "Contract Basis" : ""; } return(model); }
public string saveUpdateEmployerHistory(EmployerHistoryModel model) { string msg = ""; ShomaRMEntities db = new ShomaRMEntities(); int userid = ShomaRM.Models.ShomaGroupWebSession.CurrentUser != null ? ShomaRM.Models.ShomaGroupWebSession.CurrentUser.UserID : 0; if (model.HEIID == 0) { var saveEmployerHistory = new tbl_EmployerHistory() { HEIID = model.HEIID, EmployerName = model.EmployerName, JobTitle = model.JobTitle, JobType = model.JobType, StartDate = model.StartDate, TerminationDate = model.TerminationDate, AnnualIncome = model.AnnualIncome, AddAnnualIncome = model.AddAnnualIncome, SupervisorName = model.SupervisorName, SupervisorPhone = model.SupervisorPhone, SupervisorEmail = model.SupervisorEmail, Country = model.Country, Address1 = model.Address1, Address2 = model.Address2, State = model.State, City = model.City, Zip = model.Zip, TenantId = model.TenantId, TerminationReason = model.TerminationReason, ParentTOID = userid, }; db.tbl_EmployerHistory.Add(saveEmployerHistory); db.SaveChanges(); msg = "Progress Saved"; } else { var updateEmployerHistory = db.tbl_EmployerHistory.Where(co => co.HEIID == model.HEIID).FirstOrDefault(); if (updateEmployerHistory != null) { updateEmployerHistory.HEIID = model.HEIID; updateEmployerHistory.EmployerName = model.EmployerName; updateEmployerHistory.JobTitle = model.JobTitle; updateEmployerHistory.JobType = model.JobType; updateEmployerHistory.StartDate = model.StartDate; updateEmployerHistory.TerminationDate = model.TerminationDate; updateEmployerHistory.AnnualIncome = model.AnnualIncome; updateEmployerHistory.AddAnnualIncome = model.AddAnnualIncome; updateEmployerHistory.SupervisorName = model.SupervisorName; updateEmployerHistory.SupervisorPhone = model.SupervisorPhone; updateEmployerHistory.SupervisorEmail = model.SupervisorEmail; updateEmployerHistory.Country = model.Country; updateEmployerHistory.Address1 = model.Address1; updateEmployerHistory.Address2 = model.Address2; updateEmployerHistory.State = model.State; updateEmployerHistory.City = model.City; updateEmployerHistory.Zip = model.Zip; updateEmployerHistory.TenantId = model.TenantId; updateEmployerHistory.TerminationReason = model.TerminationReason; db.SaveChanges(); msg = "Progress Updated"; } } db.Dispose(); return(msg); }