public ActionResult VisaReport() { EmpVisaItem data = TempData["data"] as EmpVisaItem; ViewBag.Menuid = Request.QueryString["menuId"]; return(View(data)); }
public ActionResult Create() { int Empid = Convert.ToInt32(Url.RequestContext.RouteData.Values["id"].ToString()); objVisas = new EmpVisaService(); ViewBag.Empid = Empid; List <EmpVisaItem> listVisa = new List <EmpVisaItem>(); listVisa = objVisas.VisaListData(Empid); EmpVisaItem objlistVisaitem = new EmpVisaItem(); objlistVisaitem.ListVisa = new List <EmpVisaItem>(); objlistVisaitem.ListVisa.AddRange(listVisa); List <clsMasterData> lstMData = new List <clsMasterData>(); lstMData = objVisas.GetVisaStatus(); objlistVisaitem.MasterDetails = new List <clsMasterData>(); objlistVisaitem.MasterDetails.AddRange(lstMData); listVisa = objVisas.GetVisaDoc(Empid); objlistVisaitem.ListVisaDoc = new List <EmpVisaItem>(); objlistVisaitem.ListVisaDoc.AddRange(listVisa); #region For Emirates Bind List <clsMasterData> lstEmirates = new List <clsMasterData>(); lstEmirates = objVisas.GetEmiratesStatus(); objlistVisaitem.EmiratesList = new List <clsMasterData>(); objlistVisaitem.EmiratesList.AddRange(lstEmirates); #endregion #region Bind DropDown Country List <clsMasterData> lstMasters = new List <clsMasterData>(); lstMasters = objVisas.getCountry(); objlistVisaitem.ListCountry = new List <clsMasterData>(); objlistVisaitem.ListCountry.AddRange(lstMasters); #endregion #region ddl company List <CompanyItem> objCompany = new List <CompanyItem>(); CompanyService objListCompany = new CompanyService(); objCompany = objListCompany.GetALL(); EmployeeItem objEmpItem = new EmployeeItem(); objlistVisaitem.ListComp = new List <CompanyItem>(); objlistVisaitem.ListComp.AddRange(objCompany); #endregion #region ddl visa type List <clsMasterData> lstMData1 = new List <clsMasterData>(); lstMData1 = objVisas.GetVisaType(); objlistVisaitem.ListVisaType = new List <clsMasterData>(); objlistVisaitem.ListVisaType.AddRange(lstMData1); #endregion ViewBag.Menuid = Request.QueryString["menuId"]; return(View(objlistVisaitem)); }
public int Update(EmpVisaItem model) { Mapper.CreateMap <EmpVisaItem, EmployeeVisa>(); EmployeeVisa objVisa = DbContext.EmployeeVisas.SingleOrDefault(m => m.VId == model.VId); objVisa = Mapper.Map(model, objVisa); return(DbContext.SaveChanges()); }
public EmpVisaItem GetById(int id) { Mapper.CreateMap <EmployeeVisa, EmpVisaItem>(); EmployeeVisa objVisa = DbContext.EmployeeVisas.SingleOrDefault(m => m.VId == id); EmpVisaItem objVisaItem = Mapper.Map <EmpVisaItem>(objVisa); return(objVisaItem); }
public ActionResult View(int id, int VId) { objVisas = new EmpVisaService(); EmpVisaItem objVisaItem = new EmpVisaItem(); objVisaItem = objVisas.GetById(VId); //ViewBag.empid = objVisaItem.EmpId; //Session["Empid"] = objPassItem.EmpId; List <EmpVisaItem> lstPassport = new List <EmpVisaItem>(); objVisaItem.ListVisa = new List <EmpVisaItem>(); objVisaItem.ListVisa.AddRange(lstPassport); List <clsMasterData> lstMData = new List <clsMasterData>(); lstMData = objVisas.GetVisaStatus(); objVisaItem.ListVisa = new List <EmpVisaItem>(); objVisaItem.ListVisa.AddRange(lstPassport); objVisaItem.MasterDetails = new List <clsMasterData>(); objVisaItem.MasterDetails.AddRange(lstMData); ViewBag.Menuid = Request.QueryString["menuId"]; #region Bind DropDown Country List <clsMasterData> lstMasters = new List <clsMasterData>(); lstMasters = objVisas.getCountry(); objVisaItem.ListCountry = new List <clsMasterData>(); objVisaItem.ListCountry.AddRange(lstMasters); #endregion #region For Emirates Bind List <clsMasterData> lstEmirates = new List <clsMasterData>(); lstEmirates = objVisas.GetEmiratesStatus(); objVisaItem.EmiratesList = new List <clsMasterData>(); objVisaItem.EmiratesList.AddRange(lstEmirates); #endregion #region ddl company List <CompanyItem> objCompany = new List <CompanyItem>(); CompanyService objListCompany = new CompanyService(); objCompany = objListCompany.GetALL(); EmployeeItem objEmpItem = new EmployeeItem(); objVisaItem.ListComp = new List <CompanyItem>(); objVisaItem.ListComp.AddRange(objCompany); #endregion #region ddl visa type List <clsMasterData> lstMData1 = new List <clsMasterData>(); lstMData1 = objVisas.GetVisaType(); objVisaItem.ListVisaType = new List <clsMasterData>(); objVisaItem.ListVisaType.AddRange(lstMData1); #endregion return(View(objVisaItem)); }
public int Insert(EmpVisaItem model) { try { Mapper.CreateMap <EmpVisaItem, EmployeeVisa>(); EmployeeVisa objVisa = Mapper.Map <EmployeeVisa>(model); DbContext.EmployeeVisas.Add(objVisa); return(DbContext.SaveChanges()); } catch (Exception ex) { throw; } }
public ActionResult VisaReport(EmpVisaItem model) { string expdt; if (Convert.ToString(model.withinDays) != "") { expdt = ""; } else { expdt = Convert.ToString(model.ExpiryDate); } EmpVisaItem objAllItem = new EmpVisaItem(); 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 <EmpVisaItem> objMaster = objclsmethod.getVisaRpt(date, cid); objAllItem.ListVisa = new List <EmpVisaItem>(); objAllItem.ListVisa.AddRange(objMaster); } else if (Convert.ToString(model.withinDays) != "") { string day = Convert.ToString(model.withinDays); List <EmpVisaItem> objMaster = objclsmethod.getVisabyDay(day, cid); objAllItem.ListVisa = new List <EmpVisaItem>(); objAllItem.ListVisa.AddRange(objMaster); } else { List <EmpVisaItem> objMaster = objclsmethod.getVisaAllRpt(cid); objAllItem.ListVisa = new List <EmpVisaItem>(); objAllItem.ListVisa.AddRange(objMaster); } TempData["data"] = objAllItem; //return View(objAllItem); return(RedirectToAction("VisaReport", new { @menuId = model.Viewbagidformenu })); }
public ActionResult delete(int id, int VId, int menuid) { //int Empid = Convert.ToInt32(Url.RequestContext.RouteData.Values["id"].ToString()); EmpVisaService objService = new EmpVisaService(); List <EmpVisaItem> lstItem = new List <EmpVisaItem>(); EmpVisaItem objDoc = new EmpVisaItem(); objDoc = objService.GetById(VId); db.EmployeeVisas.Remove(db.EmployeeVisas.Find(VId)); db.SaveChanges(); //ViewBag.Empid = Empid; ViewBag.Menuid = Request.QueryString["menuId"]; return(RedirectToAction("Create", new { @id = id, @menuId = Request.QueryString["menuId"] })); }
public ActionResult Edit(EmpVisaItem model) { 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; objVisas = new EmpVisaService(); model.CreatedDate = System.DateTime.Now; objVisas.Update(model); ViewBag.Empid = Empid; return(RedirectToAction("Create", new { @id = Empid, @menuId = model.Viewbagidformenu })); }