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 Create([Bind(Include = "BusinessRuleKey,BusinessRuleText")] BusinessRule businessRule)
{
if (ModelState.IsValid)
{
db.BusinessRules.Add(businessRule);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(businessRule));
}
public ActionResult Create([Bind(Include = "GrantTypeKey,GrantTypeName,GrantTypeMaximum,GrantTypeLifetimeMaximum,GrantTypeDescription")] GrantType grantType)
{
if (ModelState.IsValid)
{
db.GrantTypes.Add(grantType);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(grantType));
}
public ActionResult Create([Bind(Include = "PersonKey,PersonLastName,PersonFirstName,PersonEmail,PersonPassWord,PersonEntryDate,PersonPassWordSeed")] Person person)
{
if (ModelState.IsValid)
{
db.People.Add(person);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(person));
}
public void Donate(Donation d)
{
int key = (int)d.PersonKey;
Donation donate = new Donation();
donate.DonationDate = DateTime.Now;
donate.DonationAmount = d.DonationAmount;
donate.PersonKey = key;
db.Donations.Add(donate);
db.SaveChanges();
}
public ActionResult Create([Bind(Include = "GrantRequestKey,GrantRequestDate,PersonKey,GrantTypeKey,GrantRequestExplanation,GrantRequestAmount")] GrantRequest grantRequest)
{
if (ModelState.IsValid)
{
db.GrantRequests.Add(grantRequest);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PersonKey = new SelectList(db.People, "PersonKey", "PersonLastName", grantRequest.PersonKey);
return(View(grantRequest));
}
public ActionResult Create([Bind(Include = "DonationKey,PersonKey,DonationDate,DonationAmount")] Donation donation)
{
if (ModelState.IsValid)
{
db.Donations.Add(donation);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PersonKey = new SelectList(db.People, "PersonKey", "PersonLastName", donation.PersonKey);
return(View(donation));
}
public ActionResult Edit([Bind(Include = "GrantRequestKey,GrantRequestDate,PersonKey,GrantTypeKey,GrantRequestExplanation,GrantRequestAmount")] GrantRequest grantRequest)
{
if (ModelState.IsValid)
{
db.Entry(grantRequest).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.GrantTypeKey = new SelectList(db.GrantType, "GrantTypeKey", "GrantTypeName", grantRequest.GrantTypeKey);
ViewBag.PersonKey = new SelectList(db.Person, "PersonKey", "PersonLastName", grantRequest.PersonKey);
return(View(grantRequest));
}
public ActionResult Create([Bind(Include = "EmployeeKey,PersonKey,EmployeeHireDate,EmployeeAnnualSalary")] Employee employee)
{
if (ModelState.IsValid)
{
db.Employees.Add(employee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PersonKey = new SelectList(db.People, "PersonKey", "PersonLastName", employee.PersonKey);
return(View(employee));
}
public ActionResult Create([Bind(Include = "GrantReviewKey,GrantReviewDate,GrantRequestKey,GrantRequestStatus,GrantAllocationAmount,EmployeeKey")] GrantReview grantReview)
{
if (ModelState.IsValid)
{
db.GrantReviews.Add(grantReview);
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));
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
string date = DateTextBox.Text;
string Amount = AmountTextBox.Text;
string explains = ExplainTextBox.Text;
Community_AssistEntities apply = new Community_AssistEntities();
GrantRequest grant = new GrantRequest();
//CommunityAssistReference.CommunityServiceClient ca = new CommunityAssistReference.CommunityServiceClient();
// CommunityAssistReference.GrantRequest apply = new CommunityAssistReference.GrantRequest();
grant.GrantRequestDate = DateTime.Parse(date);
grant.GrantRequestAmount = decimal.Parse(Amount);
grant.GrantRequestExplanation = explains;
grant.PersonKey = (int)Session["userKey"];
apply.GrantRequests.Add(grant);
apply.SaveChanges();
// if (Session["userkey"] == null)
// Response.Redirect("grantHistory.aspx");
Response.Redirect("grantHistory.aspx");
}
public ActionResult DeleteConfirmed(int id)
{
Person person = db.People.Find(id);
db.People.Remove(person);
db.SaveChanges();
return(RedirectToAction("Index"));
}
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 Donate(Donation d)
{
bool result01 = true;
//int rev = db.usp_AddRequest(r.GrantTypeKey, r.GrantRequestExplanation,
//r.GrantRequestAmount, r.PersonKey);
try
{
db.Donations.Add(d);
db.SaveChanges();
}
catch
{
result01 = false;
}
return(result01);
}
public void SubmitDonation(int userkey, decimal amount)
{
Donation d = new Donation();
d.DonationAmount = amount;
d.DonationDate = DateTime.Now;
d.PersonKey = userkey;
db.Donations.Add(d);
db.SaveChanges();
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
Community_AssistEntities db = new Community_AssistEntities();
Donation d = new Donation();
d.DonationAmount = decimal.Parse(DonationTextBox.Text);
db.Donations.Add(d);
db.SaveChanges();
Response.Redirect("DonationList.aspx");
}
public ActionResult Create([Bind(Include = "DonationAmount,PersonKey,DonationDate")] MVCAssignment7_1.Models.Donation donation)
{
if (ModelState.IsValid)
{
db.Donations.Add(donation);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
Community_AssistEntities db = new Community_AssistEntities();
Donation d = new Donation();
d.DonationAmount = decimal.Parse(DonationTextBox.Text);
d.DonationDate = DateTime.Now;
d.PersonKey = (int)Session["userKey"];
db.Donations.Add(d);
db.SaveChanges();
}
public bool newGrant(GrantRequest r)
{
bool result = true;
try {
db.GrantRequests.Add(r);
db.SaveChanges();
}catch {
result = false;
}
return(result);
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
Community_AssistEntities db = new Community_AssistEntities();
Donor d = new Donor();
d.DonorName = DonateTextBox.Text;
db.Donors.Add(d);
db.SaveChanges();
Response.Redirect("DonationList.aspx");
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
Community_AssistEntities db = new Community_AssistEntities();
Donation a = new Donation();
a.DonationName = DonationTextBox;
db.Donations.Add(a);
db.SaveChanges();
Response.Redirect("DonationList.aspx");
}
protected void DonateButton_Click(object sender, EventArgs e)
{
Community_AssistEntities cae = new Community_AssistEntities();
Donation d = new Donation();
d.DonationAmount = decimal.Parse(DonationTextBox.Text);
d.DonationDate = DateTime.Now;
d.PersonKey = (int)Session["userKey"];
cae.Donations.Add(d);
cae.SaveChanges();
Response.Redirect("Donations.aspx");
}
protected void DonationButton_Click(object sender, EventArgs e)
{
Community_AssistEntities db = new Community_AssistEntities();
Donation a = new Donation();
a.DonationAmount = Decimal.Parse(DonationTextBox.Text);
a.DonationDate = DateTime.Now;
a.PersonKey = (int)Session["PersonKey"];
db.Donations.Add(a);
db.SaveChanges();
Response.Redirect("DonationList.aspx");
}
protected void SubmitBtn_Click(object sender, EventArgs e)
{
Community_AssistEntities db = new Community_AssistEntities();
Donation d = new Donation();
d.DonationAmount = Decimal.Parse(DonationAmountTxt.Text);
d.DonationDate = DateTime.Now;
d.PersonKey = (int)Session["UserKey"];
db.Donations.Add(d);
db.SaveChanges();
Response.Redirect("DonationList.aspx");
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
Community_AssistEntities db = new Community_AssistEntities();
int key = (int)Session["userKey"];
Donation d = new Donation();
d.DonationAmount = Int32.Parse(DonationTextBox.Text);
d.DonationDate = DateTime.Now;
d.PersonKey = key;
db.Donations.Add(d);
db.SaveChanges();
Response.Redirect("DonationList.aspx");
}
//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);
}
protected void Button1_Click(object sender, EventArgs e)
{
decimal newDonationAmount = decimal.Parse(DonationTextBox.Text);
Community_AssistEntities db = new Community_AssistEntities();
Donation donation = new Donation();
donation.DonationAmount = newDonationAmount;
donation.DonationDate = DateTime.Now;
donation.PersonKey = Convert.ToInt32(Session["personKey"]);
db.Donations.Add(donation);
db.SaveChanges();
Response.Redirect("DonationListPage.aspx");
}
public bool ApplyForGrant(GrantRequest gr)
{
bool result = true;
try
{
cae.GrantRequests.Add(gr);
cae.SaveChanges();
}
catch (Exception ex)
{
result = false;
Console.WriteLine(ex);
throw;
}
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);
}
