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);
}
