public List <DisplinDLLViewModel> GetDisplinDDl(int desplinId, string culture) { var Actdisplin = context.DisplinRepeats.Where(a => a.DisplinId == desplinId).Select(a => new DisplinDLLViewModel { id = a.Id, name = HrContext.GetLookUpUserCode("DisplinType", a.DisplinType, culture), value = a.DisplinType }).ToList(); return(Actdisplin); }
public DeciplineInfoViewModel GetDesplinInfo(string violdata, int desplinId, string culture) { DateTime dt = Convert.ToDateTime(violdata); var repeatObj = new DisplinRepeat(); var SuggestDisplin = new List <DisplinDLLViewModel>(); var result1 = (from d in context.Disciplines join p in context.DisplinPeriods on d.PeriodId equals p.Id join n in context.DisPeriodNo on p.Id equals n.PeriodId where n.PeriodSDate <= dt && n.PeriodEDate >= dt && n.Posted == false select new PeriodIDTypeViewModel { Id = d.Id, PeriodId = n.PeriodId, SysType = p.SysType, DisPeriodNOId = n.Id }).ToList(); var Actdisplin = context.DisplinRepeats.Where(a => a.DisplinId == desplinId).Select(a => new DisplinDLLViewModel { id = a.Id, name = a.Description, value = a.DisplinType }).ToList(); var record = result1.Where(s => s.SysType == 2 && s.Id == desplinId).FirstOrDefault(); var recordPoint = result1.Where(s => s.SysType == 1 && s.Id == desplinId).FirstOrDefault(); if (record != null) { int?periodId = record.PeriodId; var result2 = (from e in context.EmpDisciplines join d in context.Disciplines on e.DiscplinId equals d.Id join p in context.DisplinPeriods on d.PeriodId equals p.Id where p.Id == periodId select new PeriodIDTypeViewModel { PeriodId = d.PeriodId }).ToList().Count(); var repNo = result2 + 1; var Repnum = context.DisplinRepeats.Max(a => a.RepNo); repeatObj = context.DisplinRepeats.Where(s => s.RepNo == repNo && s.DisplinId == desplinId).FirstOrDefault(); SuggestDisplin = context.DisplinRepeats.Where(a => a.DisplinId == desplinId && a.RepNo == repNo).Select(a => new DisplinDLLViewModel { id = a.Id, name = HrContext.GetLookUpUserCode("DisplinType", a.DisplinType, culture) }).ToList(); if (repeatObj == null) { repeatObj = context.DisplinRepeats.Where(s => s.RepNo == Repnum && s.DisplinId == desplinId).FirstOrDefault(); SuggestDisplin = context.DisplinRepeats.Where(a => a.DisplinId == desplinId && a.RepNo == Repnum).Select(a => new DisplinDLLViewModel { id = a.Id, name = HrContext.GetLookUpUserCode("DisplinType", a.DisplinType, culture) }).ToList(); } } DeciplineInfoViewModel disInfo = new DeciplineInfoViewModel { periodmodel = record, periodPoint = recordPoint, ReapetObj = repeatObj, ActDisplinDDl = Actdisplin, SuggDisplinDDl = SuggestDisplin }; return(disInfo); }
public IQueryable <TerminationGridViewModel> ReadTermRequests(int companyId, string culture) { var requests = from tr in context.Terminations where tr.CompanyId == companyId join wft in context.WF_TRANS on new { p1 = "Termination", p2 = tr.CompanyId, p3 = tr.Id } equals new { p1 = wft.Source, p2 = wft.SourceId, p3 = wft.DocumentId } into g from wft in g.DefaultIfEmpty() join ap in context.People on wft.AuthEmp equals ap.Id into g1 from ap in g1.DefaultIfEmpty() join apos in context.Positions on wft.AuthPosition equals apos.Id into g2 from apos in g2.DefaultIfEmpty() join dep in context.CompanyStructures on wft.AuthDept equals dep.Id into g3 join role in context.Roles on wft.RoleId equals role.Id into g4 from role in g4.DefaultIfEmpty() from dep in g3.DefaultIfEmpty() select new TerminationGridViewModel { Id = tr.Id, EmpId = tr.EmpId, CompanyId = tr.CompanyId, AssignStatus = HrContext.GetLookUpUserCode("Assignment", tr.AssignStatus, culture), RequestDate = tr.RequestDate, Employee = HrContext.TrlsName(tr.Employee.Title + " " + tr.Employee.FirstName + " " + tr.Employee.Familyname, culture), JoinedDate = tr.ServStartDate, PersonType = HrContext.GetLookUpUserCode("PersonType", tr.PersonType, culture), BonusInMonths = tr.BonusInMonths, ServYear = tr.ServYear, ApprovalStatus = tr.ApprovalStatus, TermReason = HrContext.GetLookUpUserCode("Termination", tr.TermReason, culture), RoleId = wft.RoleId.ToString(), DeptId = wft.DeptId, PositionId = wft.PositionId, AuthBranch = wft.AuthBranch, AuthDept = wft.AuthDept, AuthDeptName = HrContext.TrlsName(dep.Name, culture), AuthEmp = wft.AuthEmp, AuthEmpName = HrContext.TrlsName(ap.Title + " " + ap.FirstName + " " + ap.Familyname, culture), AuthPosition = wft.AuthPosition, AuthPosName = role == null?HrContext.TrlsName(apos.Name, culture) : role.Name, BranchId = wft.BranchId, Image = HrContext.GetDoc("EmployeePic", tr.Employee.Id), Gender = tr.Employee.Gender }; return(requests); }
public IQueryable <TerminationGridViewModel> ReadTermsApproved(int companyId, string culture) { var approved = from tr in context.Terminations where tr.CompanyId == companyId && tr.ApprovalStatus == 6 && tr.Terminated == false select new TerminationGridViewModel { Id = tr.Id, EmpId = tr.EmpId, AssignStatus = HrContext.GetLookUpUserCode("Assignment", tr.AssignStatus, culture), RequestDate = tr.RequestDate, Employee = HrContext.TrlsName(tr.Employee.Title + " " + tr.Employee.FirstName + " " + tr.Employee.Familyname, culture), JoinedDate = tr.ServStartDate, PersonType = HrContext.GetLookUpUserCode("PersonType", tr.PersonType, culture), BonusInMonths = tr.BonusInMonths, ServYear = tr.ServYear, TermReason = HrContext.GetLookUpUserCode("Termination", tr.TermReason, culture), Image = HrContext.GetDoc("EmployeePic", tr.Employee.Id), Gender = tr.Employee.Gender }; return(approved); }