public ActionResult PassportReport() { EmpPassportItem data = TempData["data"] as EmpPassportItem; ViewBag.Menuid = Request.QueryString["menuId"]; return(View(data)); }
public ActionResult Create() { int Empid = Convert.ToInt32(Url.RequestContext.RouteData.Values["id"].ToString()); objpassport = new EmpPassportService(); List <EmpPassportItem> listRel = new List <EmpPassportItem>(); listRel = objpassport.PassportListData(Empid); ViewBag.Empid = Empid; EmpPassportItem objPasitem = new EmpPassportItem(); objPasitem.ListPassport = new List <EmpPassportItem>(); objPasitem.ListPassport.AddRange(listRel); listRel = objpassport.GetPassportDoc(Empid); objPasitem.ListPassportDoc = new List <EmpPassportItem>(); objPasitem.ListPassportDoc.AddRange(listRel); #region Bind DropDown Nationality List <clsMasterData> lstMasters = new List <clsMasterData>(); lstMasters = objpassport.getNationality(); objPasitem.ListNationality = new List <clsMasterData>(); objPasitem.ListNationality.AddRange(lstMasters); #endregion #region Bind DropDown Country //List<clsMasterData> lstMasters = new List<clsMasterData>(); lstMasters = objpassport.getCountry(); objPasitem.ListCountry = new List <clsMasterData>(); objPasitem.ListCountry.AddRange(lstMasters); #endregion ViewBag.Menuid = Request.QueryString["menuId"]; return(View(objPasitem)); }
public ActionResult View(int id, int PasId) { EmpPassportService objPassService = new EmpPassportService(); EmpPassportItem objPassItem = new EmpPassportItem(); objPassItem = objPassService.GetById(PasId); //Session["Empid"] = objPassItem.EmpId; List <EmpPassportItem> lstPassport = new List <EmpPassportItem>(); objPassItem.ListPassport = new List <EmpPassportItem>(); objPassItem.ListPassport.AddRange(lstPassport); #region Bind DropDown Nationality List <clsMasterData> lstMasters = new List <clsMasterData>(); lstMasters = objpassport.getNationality(); objPassItem.ListNationality = new List <clsMasterData>(); objPassItem.ListNationality.AddRange(lstMasters); #endregion #region Bind DropDown Country //List<clsMasterData> lstMasters = new List<clsMasterData>(); lstMasters = objpassport.getCountry(); objPassItem.ListCountry = new List <clsMasterData>(); objPassItem.ListCountry.AddRange(lstMasters); #endregion ViewBag.PId = PasId; ViewBag.Menuid = Request.QueryString["menuId"]; return(View(objPassItem)); }
public int Update(EmpPassportItem model) { Mapper.CreateMap <EmpPassportItem, EmployeePassport>(); EmployeePassport objPass = DbContext.EmployeePassports.SingleOrDefault(m => m.Id == model.Id); objPass = Mapper.Map(model, objPass); return(DbContext.SaveChanges()); }
public EmpPassportItem GetById(int id) { Mapper.CreateMap <EmployeePassport, EmpPassportItem>(); EmployeePassport objPassport = DbContext.EmployeePassports.SingleOrDefault(m => m.Id == id); EmpPassportItem objPassItem = Mapper.Map <EmpPassportItem>(objPassport); return(objPassItem); }
public int Insert(EmpPassportItem model) { try { Mapper.CreateMap <EmpPassportItem, EmployeePassport>(); EmployeePassport objEmpPassport = Mapper.Map <EmployeePassport>(model); DbContext.EmployeePassports.Add(objEmpPassport); return(DbContext.SaveChanges()); } catch (Exception ex) { throw ex; } }
public ActionResult PassportReport(EmpPassportItem model) { string expdt; if (Convert.ToString(model.withinDays) != "") { expdt = ""; } else { expdt = Convert.ToString(model.ExpiryDate); } EmpPassportItem objAllItem = new EmpPassportItem(); ReportService objclsmethod = new ReportService(); int cid = 0; if (Session["CompID"] != null) { cid = Convert.ToInt32(Session["CompID"].ToString()); } if (expdt != "") { DateTime date = Convert.ToDateTime(model.ExpiryDate); string day = Convert.ToString(model.withinDays); List <EmpPassportItem> objMaster = objclsmethod.getPassportRpt(date, cid); objAllItem.ListPassRpt = new List <EmpPassportItem>(); objAllItem.ListPassRpt.AddRange(objMaster); } else if (Convert.ToString(model.withinDays) != "") { string day = Convert.ToString(model.withinDays); List <EmpPassportItem> objMaster = objclsmethod.getPassportbyDay(day, cid); objAllItem.ListPassRpt = new List <EmpPassportItem>(); objAllItem.ListPassRpt.AddRange(objMaster); } else { List <EmpPassportItem> objMaster = objclsmethod.getPassportAllRpt(cid); objAllItem.ListPassRpt = new List <EmpPassportItem>(); objAllItem.ListPassRpt.AddRange(objMaster); } TempData["data"] = objAllItem; return(RedirectToAction("PassportReport", new { @menuId = model.Viewbagidformenu })); }
public ActionResult delete(int id, int PId, int menuid) { //int Empid = Convert.ToInt32(Url.RequestContext.RouteData.Values["id"].ToString()); EmpPassportService objService = new EmpPassportService(); List <EmpPassportItem> lstItem = new List <EmpPassportItem>(); EmpPassportItem objDoc = new EmpPassportItem(); objDoc = objService.GetById(PId); db.EmployeePassports.Remove(db.EmployeePassports.Find(PId)); db.SaveChanges(); //ViewBag.Empid = Empid; ViewBag.Menuid = Request.QueryString["menuId"]; return(RedirectToAction("Create", new { @id = id, @menuId = Request.QueryString["menuId"] })); }
public ActionResult Create(EmpPassportItem model) { model.Status = "Active"; int Empid = Convert.ToInt32(Url.RequestContext.RouteData.Values["id"].ToString()); model.EmpId = Empid; string uid = null; if (Session["UserId"] != null) { uid = Session["UserId"].ToString(); } model.CreatedBy = uid; model.CreatedDate = System.DateTime.Now; objpassport = new EmpPassportService(); objpassport.Insert(model); return(RedirectToAction("Create", new { @menuId = model.Viewbagidformenu })); }
public ActionResult Edit(EmpPassportItem model) { model.Id = model.PasId; int Empid = Convert.ToInt32(Url.RequestContext.RouteData.Values["id"].ToString()); model.EmpId = Empid; string uid = null; if (Session["UserId"] != null) { uid = Session["UserId"].ToString(); } model.UpdatedBy = uid; model.UpdatedDate = System.DateTime.Now; EmpPassportService objPass = new EmpPassportService(); objPass.Update(model); ViewBag.Empid = Empid; return(RedirectToAction("Create", new { id = Empid, @menuId = model.Viewbagidformenu })); }
public List <EmpAllItem> GetALLDetails(int FID, int cid) { // Mapper.Initialize(cfg => // { // cfg.CreateMap<EmployeeContact, EmpContactItem>(); // cfg.CreateMap<EmployeePassport, EmpPassportItem>(); // cfg.CreateMap<EmployeeRelative, EmpRelativeItem>(); // }); // List<EmpAllItem> a = new List<EmpAllItem>(); // return a ; EmpContactItem ContactItem = new EmpContactItem(); EmpPassportItem PassportItem = new EmpPassportItem(); List <EmployeeItem> a = new List <EmployeeItem>(); var ab = (from Emp in DbContext.employee_master join Contact in DbContext.EmployeeContacts on Emp.id equals Contact.EmpId into Contact1 from C in Contact1.DefaultIfEmpty() join Passport in DbContext.EmployeePassports on Emp.id equals Passport.EmpId into Passport1 from P in Passport1.DefaultIfEmpty() join Relative in DbContext.EmployeeRelatives on Emp.id equals Relative.EmpId into Relative1 from R in Relative1.DefaultIfEmpty() join Company in DbContext.Company_master on Emp.Compid equals Company.id into Company1 from Companys in Company1.DefaultIfEmpty() join Branch in DbContext.Branch_master on Emp.Branchid equals Branch.id into BranchMst from Branchs in BranchMst.DefaultIfEmpty() //where Emp.Compid == (Compid == 0 ? Emp.Compid : Compid) where Emp.WorkingStatus == (FID == 0 ? Emp.WorkingStatus : FID) && Emp.Compid == (cid == 0 ? Emp.Compid : cid) select new EmpAllItem { //EmpContactItem = new EmpContactItem() //{ // Area = C.Area, // City = C.City, //}, EmployeeItem = new EmployeeItem() { Empno = Emp.Empno, Empname = Emp.Empname, Mobile = Emp.Mobile, id = Emp.id, JobTitle = Emp.JobTitle }, //EmpPassportItem = new EmpPassportItem() //{ // PassportNo = P.PassportNo //}, //EmpRelativeItem = new EmpRelativeItem() //{ // RName = R.RName, // RAddress = R.RAddress //}, CompanyItem = new CompanyItem() { CompName = Companys.CompName, }, BranchItem = new BranchItem() { BranchName = Branchs.BranchName } //Company = Companys.CompName } ).Distinct().ToList(); return(ab); // }