public ActionResult Create([Bind(Include = "GrantRequest, AverageIncome, GrantPercentage, ServiceInMonthes")] ServiceEndGrantRequest serviceEndGrantRequest) { Db db = new Db(DbServices.ConnectionString); if (ModelState.IsValid) { try { ServiceEndGrantRequestServices.Insert(CurrentUser.Id, serviceEndGrantRequest, db); TempData["Success"] = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "UI", "InsertConfirmed"); return(RedirectToAction("Index")); } catch (CfException cfex) { TempData["Failure"] = cfex.ErrorDefinition.LocalizedMessage; } catch (Exception ex) { TempData["Failure"] = ex.Message; } } ViewBag.GrantRequestList = new SelectList(GrantRequestServices.List(db), "Request", "Description"); return(View(serviceEndGrantRequest)); }
public ActionResult Edit(int?id) { Db db = new Db(DbServices.ConnectionString); if (id == null) { return(RedirectToAction("Index")); } Product product = ProductServices.Get(id.Value, db); Request request = RequestServices.Get(id.Value, db); GrantRequest loanRequest = GrantRequestServices.Get(id.Value, db); if (product == null || request == null || loanRequest == null) { return(HttpNotFound()); } // For Product ViewBag.EmployeeList = new SelectList(EmployeeServices.List(db), "Id", "Id_Name", product.Employee); //For Grant ViewBag.GrantTypeList = new SelectList(GrantTypeServices.List(db), "Id", "Name"); GrantRequestViewModel vm = new GrantRequestViewModel(); vm.RequestProduct = product; vm.Request = request; vm.GrantRequest = loanRequest; return(View(vm)); }
public ActionResult Create() { Db db = new Db(DbServices.ConnectionString); ViewBag.GrantRequestList = new SelectList(GrantRequestServices.List(db), "Request", "Description"); return(View()); }
public ActionResult Create([Bind(Include = "Request, GrantType, Description, Amount, Notes, EventDate, IsFromOtherBranch")] GrantRequest grantRequest) { Db db = new Db(DbServices.ConnectionString); if (ModelState.IsValid) { try { GrantRequestServices.Insert(CurrentUser.Id, grantRequest, db); TempData["Success"] = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "UI", "InsertConfirmed"); return(RedirectToAction("Index")); } catch (CfException cfex) { TempData["Failure"] = cfex.ErrorDefinition.LocalizedMessage; } catch (Exception ex) { TempData["Failure"] = ex.Message; } } ViewBag.GrantTypeList = new SelectList(GrantTypeServices.List(db), "Id", "Name"); ViewBag.RequestList = new SelectList(RequestServices.List(db), "Product", "Attachment"); return(View(grantRequest)); }
public ActionResult Edit(GrantRequestViewModel model) { int productId = model.RequestProduct.Id; try { Db db = new Db(DbServices.ConnectionString); if (!(db.Connection.State == ConnectionState.Open)) { db.Connection.Open(); } db.Transaction = db.Connection.BeginTransaction(); if (ModelState.IsValid) { try { // 1- Update Prouct ProductServices.Update(CurrentUser.Id, model.RequestProduct, db); //2- Update Request RequestServices.Update(CurrentUser.Id, model.Request, db); //3- Update GrantRequest GrantRequestServices.Update(CurrentUser.Id, model.GrantRequest, db); TempData["Success"] = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "UI", "UpdateConfirmed"); } catch (CfException cfex) { TempData["Failure"] = cfex.ErrorDefinition.LocalizedMessage; } catch (Exception ex) { TempData["Failure"] = ex.Message; } } if (db.Transaction != null) { db.Transaction.Commit(); } if (productId == 0) { return(RedirectToAction("Index")); } return(RedirectToAction("Details", new { id = productId })); } catch { return(View()); } }
// GET: GrantRequest/Delete/5 public ActionResult Delete(Nullable <int> id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Db db = new Db(DbServices.ConnectionString); GrantRequest grantRequest = GrantRequestServices.Get(id.Value, db); if (grantRequest == null) { return(HttpNotFound()); } return(View(grantRequest)); }
// GET: ServiceEndGrantRequest/Edit/5 public ActionResult Edit(Nullable <int> grantRequest) { Db db = new Db(DbServices.ConnectionString); if (grantRequest == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ServiceEndGrantRequest serviceEndGrantRequest = ServiceEndGrantRequestServices.Get(grantRequest.Value, db); if (serviceEndGrantRequest == null) { return(HttpNotFound()); } ViewBag.GrantRequestList = new SelectList(GrantRequestServices.List(db), "Request", "Description", serviceEndGrantRequest.GrantRequest); return(View(serviceEndGrantRequest)); }
// GET: GrantRequest/Edit/5 public ActionResult Edit(Nullable <int> request) { Db db = new Db(DbServices.ConnectionString); if (request == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } GrantRequest grantRequest = GrantRequestServices.Get(request.Value, db); if (grantRequest == null) { return(HttpNotFound()); } ViewBag.GrantTypeList = new SelectList(GrantTypeServices.List(db), "Id", "Name", grantRequest.GrantType); ViewBag.RequestList = new SelectList(RequestServices.List(db), "Product", "Attachment", grantRequest.Request); return(View(grantRequest)); }
public ActionResult DeleteConfirmed(int request) { try { Db db = new Db(DbServices.ConnectionString); GrantRequestServices.Delete(CurrentUser.Id, request, db); TempData["Success"] = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "UI", "DeleteConfirmed"); // return RedirectToAction("Index"); } catch (CfException cfex) { TempData["Failure"] = cfex.ErrorDefinition.LocalizedMessage; } catch (Exception ex) { TempData["Failure"] = ex.Message; } // return View(grantRequest); return(RedirectToAction("Index")); }
public ActionResult Create(GrantRequestViewModel model) { int productId = 0; try { Db db = new Db(DbServices.ConnectionString); if (!(db.Connection.State == ConnectionState.Open)) { db.Connection.Open(); } db.Transaction = db.Connection.BeginTransaction(); if (ModelState.IsValid) { try { // 1- Add Prouct // set the Amount of the Produt the same as Request model.RequestProduct.Amount = model.Request.Amount; model.RequestProduct.ProductType = 0; Product p = ProductServices.Insert(CurrentUser.Id, model.RequestProduct, db); productId = p.Id; //2-Add Request model.Request.Product = p.Id; model.Request.RequestStatus = (int)RequestStatusEnum.New; model.Request.Cost = 5; Request r = RequestServices.Insert(CurrentUser.Id, model.Request, db); //3-Add GrantRequest model.GrantRequest.Request = p.Id; model.GrantRequest.Amount = model.Request.Amount; GrantRequestServices.Insert(CurrentUser.Id, model.GrantRequest, db); TempData["Success"] = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "UI", "InsertConfirmed"); } catch (CfException cfex) { TempData["Failure"] = cfex.ErrorDefinition.LocalizedMessage; } catch (Exception ex) { TempData["Failure"] = ex.Message; } } if (db.Transaction != null) { db.Transaction.Commit(); } if (productId == 0) { return(RedirectToAction("Index")); } return(RedirectToAction("Details", new { id = productId })); } catch { return(View()); } }