public List <EmpInsuranceItem> InsuranceListData(int cid) { var objIns = (from EmpInsurance in DbContext.EmployeeInsurances join branch in DbContext.Branch_master on EmpInsurance.Branch equals branch.id into BLJ from left in BLJ.DefaultIfEmpty() join masterComp in DbContext.Masters_Tran on EmpInsurance.Icomp equals masterComp.Id join masterType in DbContext.Masters_Tran on EmpInsurance.Ptype equals masterType.Id join emp in DbContext.employee_master on EmpInsurance.EmpId equals emp.id into LJ from subpet in LJ.DefaultIfEmpty() join cm in DbContext.Company_master on EmpInsurance.CompID equals cm.id into comp from c in comp.DefaultIfEmpty() where (EmpInsurance.Ptype == 41 || EmpInsurance.Ptype == 43 || EmpInsurance.Ptype == 617 || EmpInsurance.Ptype == 619 || EmpInsurance.Ptype == 620 || EmpInsurance.Ptype == 629 || EmpInsurance.Ptype == 630) && EmpInsurance.CompID == (cid == 0 ? EmpInsurance.CompID : cid) select new EmpInsuranceItem { CompDetails = new CompanyItem() { CompName = (c == null?string.Empty:c.CompName) }, MasterDetails = new clsMasterData() { Name = masterComp.Name }, MasterDetailsType = new clsMasterData() { Name = masterType.Name }, BranchDetails = new BranchItem() { //BranchName = branch.BranchName BranchName = (left == null ? String.Empty : left.BranchName) }, EmpDetails = new EmployeeItem() { //Empname=emp.Empname Empname = (subpet == null ? String.Empty : subpet.Empname) }, EmpId = EmpInsurance.EmpId, Pname = EmpInsurance.Pname, Icomp = EmpInsurance.Icomp, Ptype = EmpInsurance.Ptype, Pno = EmpInsurance.Pno, Pamt = EmpInsurance.Pamt, Pdate = EmpInsurance.Pdate, PExpDate = EmpInsurance.PExpDate, PremiumDate = EmpInsurance.PremiumDate, Branch = EmpInsurance.Branch, Remarks = EmpInsurance.Remarks, IID = EmpInsurance.IID } ).Distinct().ToList(); return(objIns); }
public List <EmpInsuranceItem> EmpInsuranceList(int EmpId) { var objIns = (from EmpInsurance in DbContext.EmployeeInsurances join branch in DbContext.Branch_master on EmpInsurance.Branch equals branch.id into BLJ from left in BLJ.DefaultIfEmpty() join masterComp in DbContext.Masters_Tran on EmpInsurance.Icomp equals masterComp.Id join masterType in DbContext.Masters_Tran on EmpInsurance.Ptype equals masterType.Id join emp in DbContext.employee_master on EmpInsurance.EmpId equals emp.id into LJ from subpet in LJ.DefaultIfEmpty() where EmpInsurance.Ptype == 40 && EmpInsurance.EmpId == EmpId select new EmpInsuranceItem { MasterDetails = new clsMasterData() { Name = masterComp.Name }, MasterDetailsType = new clsMasterData() { Name = masterType.Name }, BranchDetails = new BranchItem() { //BranchName = branch.BranchName BranchName = (left == null ? String.Empty : left.BranchName) }, EmpDetails = new EmployeeItem() { //Empname=emp.Empname Empname = (subpet == null ? String.Empty : subpet.Empname) }, EmpId = EmpInsurance.EmpId, Pname = EmpInsurance.Pname, Icomp = EmpInsurance.Icomp, Ptype = EmpInsurance.Ptype, Pno = EmpInsurance.Pno, Pamt = EmpInsurance.Pamt, Pdate = EmpInsurance.Pdate, PExpDate = EmpInsurance.PExpDate, PremiumDate = EmpInsurance.PremiumDate, Branch = EmpInsurance.Branch, Remarks = EmpInsurance.Remarks, IID = EmpInsurance.IID } ).Distinct().ToList(); return(objIns); }