public int Update(TExpenseItem model) { TravelExpence TE = DbContext.TravelExpences.SingleOrDefault(m => m.Id == model.Id); TE.Companyid = model.Companyid; TE.EmpId = model.EmpId; TE.TDate = model.TDate; TE.Country = model.Country; TE.TFromDate = model.TFromDate; TE.TToDate = model.TToDate; TE.Fare = model.Fare; TE.FromDate = model.FromDate; TE.ToDate = model.ToDate; TE.City = model.City; TE.Id = model.Id; TE.AccomodationExp = model.AccomodationExp; TE.FoodExp = model.FoodExp; TE.OtherExp = model.OtherExp; TE.Remarks = model.Remarks; TE.Conv_Exp = model.Conv_Exp; TE.Status = model.Status; TE.UpdatedBy = model.UpdatedBy; TE.UpdatedDate = model.UpdatedDate; return(DbContext.SaveChanges()); }
public ActionResult Create(TExpenseItem model) { model.Status = "Active"; TExpenseService objTExp = new TExpenseService(); string uid = null; if (Session["UserId"] != null) { uid = Session["UserId"].ToString(); } int cid = 0; if (Session["CompID"] != null) { cid = Convert.ToInt32(Session["CompID"].ToString()); } if (model.Companyid == null) { model.Companyid = cid; } model.CreatedBy = uid; model.CreatedDate = System.DateTime.Now; objTExp.Insert(model); return(RedirectToAction("Create", new { @menuId = model.Viewbagidformenu })); }
public TExpenseItem GetById(int id) { Mapper.CreateMap <TravelExpence, TExpenseItem>(); TravelExpence objTExp = DbContext.TravelExpences.SingleOrDefault(m => m.Id == id); TExpenseItem objTExpItem = Mapper.Map <TExpenseItem>(objTExp); return(objTExpItem); }
public ActionResult Edit(TExpenseItem model) { TExpenseService objTExp = new TExpenseService(); string uid = null; if (Session["UserId"] != null) { uid = Session["UserId"].ToString(); } model.UpdatedBy = uid; model.UpdatedDate = System.DateTime.Now; objTExp.Update(model); return(RedirectToAction("Create", new { @menuId = model.Viewbagidformenu })); }
public ActionResult delete(int id, int menuid) { try { //int Empid = Convert.ToInt32(Url.RequestContext.RouteData.Values["id"].ToString()); TExpenseService objTenService = new TExpenseService(); TExpenseItem objDoc = new TExpenseItem(); objDoc = objTenService.GetById(id); db.TravelExpences.Remove(db.TravelExpences.Find(id)); db.SaveChanges(); //ViewBag.Empid = Empid; ViewBag.Menuid = Request.QueryString["menuId"]; } catch (Exception ex) { //ViewBag.ErrorMsg = "First Delete This Tenancy No's All Documents. "; return(View("Error")); } return(RedirectToAction("Create", new { @menuId = Request.QueryString["menuId"] })); }
public ActionResult Create() { int cid = 0; if (Session["CompID"] != null) { cid = Convert.ToInt32(Session["CompID"].ToString()); } List <TExpenseItem> lstTExp = new List <TExpenseItem>(); TExpenseService objTExp = new TExpenseService(); lstTExp = objTExp.TExpenseData(cid); TExpenseItem objTExpItem = new TExpenseItem(); objTExpItem.ListTExp = new List <TExpenseItem>(); objTExpItem.ListTExp.AddRange(lstTExp); #region Bind DropDown Country List <clsMasterData> lstMasters = new List <clsMasterData>(); lstMasters = objTExp.getCountry(); objTExpItem.ListCon = new List <clsMasterData>(); objTExpItem.ListCon.AddRange(lstMasters); #endregion #region Bind DropDown Comp List <CompanyItem> lstComp = new List <CompanyItem>(); lstComp = objTExp.GetAllComp(); objTExpItem.ListComp = new List <CompanyItem>(); objTExpItem.ListComp.AddRange(lstComp); #endregion #region Bind DropDown Emp List <EmployeeItem> lstEmp = new List <EmployeeItem>(); lstEmp = objTExp.GetEmp(cid); objTExpItem.ListEmp = new List <EmployeeItem>(); objTExpItem.ListEmp.AddRange(lstEmp); #endregion ViewBag.Menuid = Request.QueryString["menuId"]; return(View(objTExpItem)); }
public int Insert(TExpenseItem model) { try { TravelExpence TE = new TravelExpence(); TE.Companyid = model.Companyid; TE.EmpId = model.EmpId; TE.TDate = model.TDate; TE.Country = model.Country; TE.TFromDate = model.TFromDate; TE.TToDate = model.TToDate; TE.Fare = model.Fare; TE.FromDate = model.FromDate; TE.ToDate = model.ToDate; TE.City = model.City; TE.Id = model.Id; TE.AccomodationExp = model.AccomodationExp; TE.FoodExp = model.FoodExp; TE.OtherExp = model.OtherExp; TE.Conv_Exp = model.Conv_Exp; TE.Remarks = model.Remarks; TE.Status = model.Status; TE.CreatedBy = model.CreatedBy; TE.CreatedDate = model.CreatedDate; DbContext.TravelExpences.Add(TE); return(DbContext.SaveChanges()); //Mapper.CreateMap<TExpenseItem, TravelExpence>(); //TravelExpence objTExp = Mapper.Map<TravelExpence>(model); //DbContext.TravelExpences.Add(objTExp); //return DbContext.SaveChanges(); } catch (Exception ex) { throw; } }