public int RequestGrant(int GrantTypeKey, string GrantRequestExplanation, decimal GrantRequestAmount, int PersonKey) { GrantRequest grantRequest = new GrantRequest(); grantRequest.GrantRequestDate = DateTime.Now; grantRequest.GrantRequestAmount = GrantRequestAmount; grantRequest.GrantTypeKey = GrantTypeKey; grantRequest.PersonKey = PersonKey; grantRequest.GrantRequestExplanation = GrantRequestExplanation; var result = db.GrantRequests.Add(grantRequest); db.SaveChanges(); GrantReview addentry = new GrantReview(); addentry.GrantReviewDate = DateTime.Now; addentry.GrantRequestStatus = "Pending"; addentry.GrantAllocationAmount = GrantRequestAmount; addentry.GrantRequestKey = result.GrantRequestKey; db.GrantReviews.Add(addentry); db.SaveChanges(); return(result.GrantRequestKey); }
public ActionResult DeleteConfirmed(int id) { GrantReview grantReview = db.GrantReviews.Find(id); db.GrantReviews.Remove(grantReview); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "GrantReviewKey,GrantReviewDate,GrantRequestKey,GrantRequestStatus,GrantAllocationAmount,EmployeeKey")] GrantReview grantReview) { if (ModelState.IsValid) { db.Entry(grantReview).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.EmployeeKey = new SelectList(db.Employees, "EmployeeKey", "EmployeeKey", grantReview.EmployeeKey); ViewBag.GrantRequestKey = new SelectList(db.GrantRequests, "GrantRequestKey", "GrantRequestExplanation", grantReview.GrantRequestKey); return(View(grantReview)); }
// GET: GrantReviews/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } GrantReview grantReview = db.GrantReviews.Find(id); if (grantReview == null) { return(HttpNotFound()); } return(View(grantReview)); }
// GET: GrantReviews/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } GrantReview grantReview = db.GrantReviews.Find(id); if (grantReview == null) { return(HttpNotFound()); } ViewBag.EmployeeKey = new SelectList(db.Employees, "EmployeeKey", "EmployeeKey", grantReview.EmployeeKey); ViewBag.GrantRequestKey = new SelectList(db.GrantRequests, "GrantRequestKey", "GrantRequestExplanation", grantReview.GrantRequestKey); return(View(grantReview)); }
//to request a grant public bool RequestGrant(GrantRequest rq) { bool result = true; rq.GrantRequestDate = DateTime.Now; db.GrantRequests.Add(rq); GrantReview rev = new GrantReview() { GrantRequest = rq, GrantRequestStatus = "pending" }; db.SaveChanges(); return(result); }
public bool newGrant(GrantRequest gRequest, GrantReview gReview) { bool result = true; try { db.GrantRequests.Add(gRequest); db.GrantReviews.Add(gReview); db.SaveChanges(); } catch { result = false; } return(result); }
public bool ApplyForGrant(GrantRequest gr) { bool result = true; try { GrantReview review = new GrantReview(); review.GrantRequest = gr; review.GrantRequestStatus = "Pending"; cae.GrantRequests.Add(gr); //cae.GrantReviews.Add(review); cae.SaveChanges(); } catch { result = false; } return(result); }
protected void Button1_Click(object sender, EventArgs e) { Community_AssistEntities db = new Community_AssistEntities(); string selectedGrant = DropDownList1.SelectedValue; int selectedGrantId = 1; foreach (var gt in grantTypes) { if (selectedGrant.Equals(gt.GrantTypeName)) { selectedGrantId = gt.GrantTypeKey; break; } } decimal grantAmount = decimal.Parse(GrantAmountTextBox.Text); string grantExplanation = ExplainationTextBox.Text; int personId = ((int)Session["personKey"]); GrantRequest grantRequest = new GrantRequest(); grantRequest.GrantRequestDate = DateTime.Now; grantRequest.GrantRequestAmount = grantAmount; grantRequest.GrantTypeKey = selectedGrantId; grantRequest.PersonKey = personId; grantRequest.GrantRequestExplanation = grantExplanation; var result = db.GrantRequests.Add(grantRequest); db.SaveChanges(); GrantReview addentry = new GrantReview(); addentry.GrantReviewDate = DateTime.Now; addentry.GrantRequestStatus = "Pending"; addentry.GrantAllocationAmount = grantAmount; addentry.GrantRequestKey = result.GrantRequestKey; db.GrantReviews.Add(addentry); db.SaveChanges(); ResultLabel.Text = "Grant requested succesfully" + personId; }
public bool NewGrant(GrantRequest r) { bool result = true; try { GrantReview grantrev = new GrantReview(); grantrev.GrantRequest = r; grantrev.GrantRequestStatus = "Pending"; grantrev.GrantReviewDate = DateTime.Now; db.GrantRequests.Add(r); db.GrantReviews.Add(grantrev); db.SaveChanges(); } catch (Exception ex) { result = false; } return(result); }