public ActionResult DeleteDonor(int id)
{
donation donation = db.donations.Find(id);
db.donations.Remove(donation);
db.SaveChanges();
return RedirectToAction("Index");
}
public ActionResult Create(DonationMvc donati, HttpPostedFileBase image)
{
if (!ModelState.IsValid || image == null || image.ContentLength == 0)
{
RedirectToAction("Create");
}
donation don = new donation();
don.lieuDonation = donati.lieuDonation;
don.TitreDonation = donati.TitreDonation;
don.TypeDonation = donati.TypeDonation;
don.image = image.FileName;
don.id = donati.id;
don.dateajout = donati.dateajout;
don.disponibilite = donati.disponibilite;
don.email = donati.email;
sc.Add(don);
sc.Commit();
var path = Path.Combine(Server.MapPath("~/Content/Upload/"), image.FileName);
image.SaveAs(path);
return(RedirectToAction("Index"));
}
//
// GET: /Admin/Donations/Delete/5
public ActionResult Delete(int id)
{
donation donation = db.donations.Single(d => d.InvestmentID == id);
ViewBag.Project = db.projects.FirstOrDefault(x => x.ProjectID == donation.ProjectID);
return(View(donation));
}
// GET: donations/Edit/5 -- THIS WILL BE FOR DONATIONS EDIT
public ActionResult Edit(int?id)
{
if (Session["role"] != null && Session["role"].ToString() == "ADM")
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
try
{
donation donation = db.donations.Find(id);
if (donation == null)
{
return(HttpNotFound());
}
ViewBag.province_char = new SelectList(db.provinces, "code", "name", donation.north_shore_accounts.province.code);
return(View(donation));
}
catch (Exception e)
{
ViewBag.GenericException = e.Message;
}
return(View("~/Views/Navigate/Errors.cshtml"));
}
else
{
return(RedirectToAction("RestrictedAccess", "Navigate"));
}
}
//GIVE DONATION IF THE USER IS LOGGED IN
public ActionResult UserDonate(FormCollection form)
{
try
{
if (ModelState.IsValid)
{
//FINDS AND HOLDS THE USER ACCOUNT
north_shore_accounts nsa = new north_shore_accounts();
nsa.user_id = Convert.ToInt16(Session["userId"]);
var user = db.north_shore_accounts.Where(n => n.user_id == nsa.user_id);
foreach (var row in user)
{
nsa.id = row.id;
}
nsa = db.north_shore_accounts.Find(nsa.id);
//FIND THE PAYMENT INFORMATION FOR THIS USER
payment_information pi = new payment_information();
pi.credit_card = form["north_shore_accounts.payment_information.credit_card"];
pi.ccv = form["north_shore_accounts.payment_information.ccv"];
DateTime date = DateTime.Parse(form["north_shore_accounts.payment_information.exp_date"]);
int year = date.Year;
int day = date.Day;
int month = date.Month;
string exp_date = year.ToString() + "-" + month.ToString() + "-" + day.ToString();
DateTime convertedDate = Convert.ToDateTime(exp_date);
pi.exp_date = date;
pi.id = nsa.payment_info ?? default(int);
ViewBag.UpRowsAffected = db.Database.ExecuteSqlCommand("UPDATE payment_information SET credit_card = @credit_card, ccv = @ccv, exp_date = @exp_date WHERE id = @id", new SqlParameter("@credit_card", pi.credit_card), new SqlParameter("@ccv", pi.ccv), new SqlParameter("@exp_date", pi.exp_date), new SqlParameter("@id", pi.id));
//SET THE DONATIONS ID TO USER ACCOUNT ID, THEN ADD THE AMOUNT TO IT
donation donation = new donation();
donation.account_id = nsa.id;
donation.amount = Convert.ToDecimal(form["amount"]);
ViewBag.InRowsAffected = db.Database.ExecuteSqlCommand("INSERT INTO donations VALUES (@amount, @account_id)", new SqlParameter("@amount", donation.amount), new SqlParameter("@account_id", donation.account_id));
Session["donated"] = "true";
return(RedirectToAction("Index", "Navigate"));
}
}
catch (DbUpdateException e)
{
ViewBag.DbExceptionMessage = e.Message;
}
catch (SqlException e)
{
ViewBag.SqlExceptionMessage = e.Message;
}
catch (Exception e)
{
ViewBag.GenericException = e.Message;
}
return(View("~/Views/Navigate/Errors.cshtml"));
}
public ActionResult Confirm(int id, DonationMvc res)
{
donation acc = sc.GetById(id);
try
{
acc.id = res.id;
acc.disponibilite = "indisponibe";
sc.Update(acc);
sc.Commit();
sc.email("Booking Confirmation",
"Your reservation has been confirmed ," +
"please Connect to your account and Click on My Reservations , Download the Confirmation receipt in order to pay for your reservation for the donation "
);
// ScriptManager.RegisterClientScriptBlock(, this.GetType(), "alertMessage", "alert('Record Inserted Successfully')", true);
// return Content("<script language='javascript' type='text/javascript'>alert('Thanks for Feedback!');</script>");
return(RedirectToAction("Confirm"));
}
catch (Exception e)
{
}
return(View("Confirm"));
}
public ActionResult DeleteAccount(int id)
{
try
{
north_shore_accounts nsa = new north_shore_accounts();
donation donation = db.donations.Find(id);
nsa.id = donation.account_id;
nsa = db.north_shore_accounts.Find(nsa.id);
db.donations.Remove(donation);
db.north_shore_accounts.Remove(nsa);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (DbUpdateException e)
{
ViewBag.DbExceptionMessage = e.Message;
}
catch (SqlException e)
{
ViewBag.SqlExceptionMessage = e.Message;
}
catch (Exception e)
{
ViewBag.GenericException = e.Message;
}
return(View("~/Views/Navigate/Errors.cshtml"));
}
// GET: donations/Details/5
public ActionResult Details(int?id)
{
if (Session["role"] != null && Session["role"].ToString() == "ADM")
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
try
{
donation donation = db.donations.Find(id);
if (donation == null)
{
return(HttpNotFound());
}
return(View(donation));
}
catch (Exception e)
{
ViewBag.GenericException = e.Message;
}
return(View("~/Views/Navigate/Errors.cshtml"));
}
else
{
return(RedirectToAction("RestrictedAccess", "Navigate"));
}
}
// 立即提交
protected void Button1_Click(object sender, EventArgs e)
{
if (Request.Form["date"] == "")
{
Response.Write("<script>alert('日期必须选择！')</script>");
}
else
{
DateTime time = Convert.ToDateTime(Request.Form["date"]);
int obj_id = Convert.ToInt32(DropDownList1.SelectedValue);
int type_id = Convert.ToInt32(DropDownList2.SelectedValue);
string donor = TextBox1.Text.Trim();
string money = TextBox2.Text.Trim();
string message = Request.Form["message"];
donation don = new donation();
don.time = time;
don.obj_id = obj_id;
don.type_id = type_id;
don.donor = donor;
don.money = Convert.ToDecimal(money);
don.message = message;
db.donation.Add(don);
db.SaveChanges();
Response.Write("<script>alert('您已成功上传一条信息！')</script>");
}
}
//DELETE JUST THEIR DONATION
// GET: donations/Delete/5
public ActionResult Delete(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
try
{
donation donation = db.donations.Find(id);
if (donation == null)
{
return HttpNotFound();
}
return View(donation);
}
catch (DbUpdateException e)
{
ViewBag.DbExceptionMessage = e.Message;
}
catch (SqlException e)
{
ViewBag.SqlExceptionMessage = e.Message;
}
catch (Exception e)
{
ViewBag.GenericException = e.Message;
}
return View("~/Views/Navigate/Errors.cshtml");
}
//
// GET: /Admin/Donations/Edit/5
public ActionResult Edit(int id)
{
donation donation = db.donations.Single(d => d.InvestmentID == id);
ViewBag.Project = db.projects.FirstOrDefault(x => x.ProjectID == donation.ProjectID);
ViewBag.ProjectID = new SelectList(db.projects.Where(x => x.Enabled), "ProjectID", "Title", donation.ProjectID);
ViewBag.UserID = new SelectList(db.users.Where(x => x.Role == "supporter"), "UserID", "Role", donation.UserID);
return(View(donation));
}
public IHttpActionResult post([FromBody] donation adata)
{
donation p = adata;
context.donations.Add(p);
context.SaveChanges();
return(Ok(new { results = adata }));
}
public ActionResult DelP(int?id)
{
if (Session["role"] != null && Session["role"].ToString() == "ADM")
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
try
{
payment_information pi = db.payment_information.Find(id);
north_shore_accounts nsa = new north_shore_accounts();
donation d = new donation();
//find NSA id from pi payment_info
var sel_nsa = db.north_shore_accounts.Where(n => n.payment_info == pi.id);
foreach (var n in sel_nsa)
{
nsa = db.north_shore_accounts.Find(n.id);
}
//find donation from NSA account_id
var sel_don = db.donations.Where(don => don.account_id == nsa.id);
foreach (var don in sel_don)
{
d = db.donations.Find(don.id);
}
if (d == null)
{
return(HttpNotFound());
}
return(View(nsa));
}
catch (DbUpdateException e)
{
ViewBag.DbExceptionMessage = e.Message;
}
catch (SqlException e)
{
ViewBag.SqlExceptionMessage = e.Message;
}
catch (Exception e)
{
ViewBag.GenericException = e.Message;
}
return(View("~/Views/Navigate/Errors.cshtml"));
}
else
{
return(RedirectToAction("RestrictedAccess", "Navigate"));
}
}
public donation Insert_donation_select(int ID)
{
donation = donation.Select(ID);
Insert_Receipt_ID_txt.Text = Convert.ToString(donation.Receipt_ID);
Insert_Resource_ID_txt.Text = Convert.ToString(donation.Resource_ID);
Insert_Donor_ID_txt.Text = Convert.ToString(donation.Donor_ID);
Insert_Date_txt.Text = Convert.ToString(donation.Date);
Insert_Quantity_txt.Text = Convert.ToString(donation.Quantity);
Insert_Agency_ID_txt.Text = Convert.ToString(donation.Agency_ID);
Insert_Is_Monetary_txt.Text = Convert.ToString(donation.Is_Monetary);
Insert_Is_FEMA_txt.Text = Convert.ToString(donation.Is_FEMA);
return(donation);
}
// GET: Donation/Delete/5
public ActionResult Delete(int id)
{
donation acc = sc.GetById(id);
DonationMvc accomodation = new DonationMvc
{
lieuDonation = acc.lieuDonation,
TitreDonation = acc.TitreDonation,
TypeDonation = acc.TypeDonation,
email = acc.email,
};
return(View(accomodation));
}
public donation Delete_donation_select(int ID)
{
donation = donation.Select(ID);
Delete_Donation_ID_txt_lbl.Text = Convert.ToString(donation.Donation_ID);
Delete_Receipt_ID_txt_lbl.Text = Convert.ToString(donation.Receipt_ID);
Delete_Resource_ID_txt_lbl.Text = Convert.ToString(donation.Resource_ID);
Delete_Donor_ID_txt_lbl.Text = Convert.ToString(donation.Donor_ID);
Delete_Date_txt_lbl.Text = Convert.ToString(donation.Date);
Delete_Quantity_txt_lbl.Text = Convert.ToString(donation.Quantity);
Delete_Agency_ID_txt_lbl.Text = Convert.ToString(donation.Agency_ID);
Delete_Is_Monetary_txt_lbl.Text = Convert.ToString(donation.Is_Monetary);
Delete_Is_FEMA_txt_lbl.Text = Convert.ToString(donation.Is_FEMA);
return donation;
}
public ActionResult Edit(donation donation)
{
if (ModelState.IsValid)
{
db.donations.Attach(donation);
db.ObjectStateManager.ChangeObjectState(donation, EntityState.Modified);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Project = db.projects.FirstOrDefault(x => x.ProjectID == donation.ProjectID);
ViewBag.ProjectID = new SelectList(db.projects.Where(x => x.Enabled), "ProjectID", "Title", donation.ProjectID);
ViewBag.UserID = new SelectList(db.users.Where(x => x.Role == "supporter"), "UserID", "Role", donation.UserID);
return(View(donation));
}
public ActionResult DeleteConfirmed(int id, int projectid = 0)
{
donation donation = db.donations.Single(d => d.InvestmentID == id);
db.donations.DeleteObject(donation);
db.SaveChanges();
//comes from project
if (projectid > 0)
{
return(RedirectToAction("Edit", "Projects", new { id = projectid }, "donations"));
}
return(RedirectToAction("Index"));
}
public bool makeDonation(donationsPublic donation)
{
//Make new donation
donation don = new donation();
don.first_name = donation.fname;
don.last_name = donation.lname;
don.email = donation.email;
don.amount = donation.amount;
don.message = donation.message;
don.donation_date = DateTime.Now;
objDon.donations.InsertOnSubmit(don);
objDon.SubmitChanges();
return(true);
}
public ActionResult Delete(int id, FormCollection collection)
{
try
{
donation acc = sc.GetById(id);
sc.Delete(acc);
sc.Commit();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public donation donation_insert()
{
donation.Receipt_ID = Convert.ToInt32(Insert_Receipt_ID_txt.Text);
donation.Resource_ID = Convert.ToInt32(Insert_Resource_ID_txt.Text);
donation.Donor_ID = Convert.ToInt32(Insert_Donor_ID_txt.Text);
donation.Date = Convert.ToDateTime(Insert_Date_txt.Text);
donation.Quantity = Convert.ToInt32(Insert_Quantity_txt.Text);
donation.Agency_ID = Convert.ToInt32(Insert_Agency_ID_txt.Text);
donation.Is_Monetary = Convert.ToBoolean(Insert_Is_Monetary_txt.Text);
donation.Is_FEMA = Convert.ToBoolean(Insert_Is_FEMA_txt.Text);
donation = donation.Insert(donation);
Insert_donation_GridView.DataBind();
Update_donation_GridView.DataBind();
Delete_donation_GridView.DataBind();
return(donation);
}
public PartialViewResult _AllDonations(int?id)
{
var donations = db.donations.Where(d => d.account_id == id);
List <donation> don = new List <donation>();
foreach (var d in donations)
{
donation donation = new donation();
donation.id = d.id;
donation.amount = d.amount;
donation.account_id = d.account_id;
don.Add(donation);
}
return(PartialView(don));
}
public bool commitInsert(string _firstname, string _lastname, string _email, string _message)
{
donationDataContext objDonateDC = new donationDataContext();
using (objDonateDC)
{
donation objDonate = new donation();
objDonate.firstname = _firstname;
objDonate.lastname = _lastname;
objDonate.email = _email;
objDonate.message = _message;
objDonateDC.donations.InsertOnSubmit(objDonate);
objDonateDC.SubmitChanges();
return true;
}
}
public donation donation_insert()
{
donation.Receipt_ID = Convert.ToInt32(Insert_Receipt_ID_txt.Text);
donation.Resource_ID = Convert.ToInt32(Insert_Resource_ID_txt.Text);
donation.Donor_ID = Convert.ToInt32(Insert_Donor_ID_txt.Text);
donation.Date = Convert.ToDateTime(Insert_Date_txt.Text);
donation.Quantity = Convert.ToInt32(Insert_Quantity_txt.Text);
donation.Agency_ID = Convert.ToInt32(Insert_Agency_ID_txt.Text);
donation.Is_Monetary = Convert.ToBoolean(Insert_Is_Monetary_txt.Text);
donation.Is_FEMA = Convert.ToBoolean(Insert_Is_FEMA_txt.Text);
donation = donation.Insert(donation);
Insert_donation_GridView.DataBind();
Update_donation_GridView.DataBind();
Delete_donation_GridView.DataBind();
return donation;
}
// GET: Donation/Details/5
public ActionResult Details(int id)
{
donation acc = sc.GetById(id);
DonationMvc accomodation = new DonationMvc
{
id = acc.id,
lieuDonation = acc.lieuDonation,
TitreDonation = acc.TitreDonation,
TypeDonation = acc.TypeDonation,
image = acc.image,
dateajout = acc.dateajout,
disponibilite = acc.disponibilite,
email = acc.email
};
return(View(accomodation));
}
public ActionResult Return(DonationDetails model, int projectid = 0)
{
donation donation = db.donations.FirstOrDefault(x => x.InvestmentID == model.InvestmentID && x.user.UserName.ToLower() == User.Identity.Name.ToLower());
if (donation != null)
{
donation.Description = model.Description;
db.SaveChanges();
}
if (projectid > 0)
{
return(RedirectToAction("ThankYou", "Projects", new { id = projectid }));
}
return(RedirectToAction("Index", "Projects"));
}
public ActionResult DelAcc(int? id)
{
north_shore_accounts nsa = db.north_shore_accounts.Find(id);
donation d = new donation();
//find donation from NSA account_id
var sel_don = db.donations.Where(don => don.account_id == nsa.id);
foreach (var don in sel_don)
{
d = db.donations.Find(don.id);
}
if (d == null)
{
return HttpNotFound();
}
return View(d);
}
public ActionResult DelP(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
try
{
payment_information pi = db.payment_information.Find(id);
north_shore_accounts nsa = new north_shore_accounts();
donation d = new donation();
//find NSA id from pi payment_info
var sel_nsa = db.north_shore_accounts.Where(n => n.payment_info == pi.id);
foreach (var n in sel_nsa)
{
nsa = db.north_shore_accounts.Find(n.id);
}
//find donation from NSA account_id
var sel_don = db.donations.Where(don => don.account_id == nsa.id);
foreach (var don in sel_don)
{
d = db.donations.Find(don.id);
}
if (d == null)
{
return HttpNotFound();
}
return View(nsa);
}
catch(DbUpdateException e)
{
ViewBag.DbExceptionMessage = e.Message;
}
catch(SqlException e)
{
ViewBag.SqlExceptionMessage = e.Message;
}
catch(Exception e)
{
ViewBag.GenericException = e.Message;
}
return View("~/Views/Navigate/Errors.cshtml");
}
public ActionResult DonateDispo()
{
List <donation> list = new List <donation>();
foreach (var item in sc.donDispo())
{
donation dn = new donation();
dn.id = item.id;
dn.lieuDonation = item.lieuDonation;
dn.TitreDonation = item.TitreDonation;
dn.TypeDonation = item.TypeDonation;
dn.image = item.image;
dn.dateajout = item.dateajout;
dn.disponibilite = item.disponibilite;
list.Add(dn);
}
//var list = SC.GetAll();
return(View(list));
}
public ActionResult DeleteDonorPay(int id)
{
try
{
north_shore_accounts nsa = new north_shore_accounts();
payment_information pi = new payment_information();
donation donation = new donation();
var donor = db.donations.Where(d => d.account_id == id);
foreach (var d in donor)
{
donation = db.donations.Find(d.id);
if (donation != null)
{
db.donations.Remove(donation);
}
}
nsa = db.north_shore_accounts.Find(id);
pi.id = nsa.payment_info ?? default(int);
pi = db.payment_information.Find(pi.id);
db.north_shore_accounts.Remove(nsa);
db.payment_information.Remove(pi);
db.SaveChanges();
return(RedirectToAction("AcctPayInfo"));
}
catch (DbUpdateException e)
{
ViewBag.DbExceptionMessage = e.Message;
}
catch (SqlException e)
{
ViewBag.SqlExceptionMessage = e.Message;
}
catch (Exception e)
{
ViewBag.GenericException = e.Message;
}
return(View("~/Views/Navigate/Errors.cshtml"));
}
public ActionResult Edit(int id, DonationMvc DMvc)
{
donation acc = sc.GetById(id);
acc.id = DMvc.id;
acc.lieuDonation = DMvc.lieuDonation;
acc.TitreDonation = DMvc.TitreDonation;
acc.TypeDonation = DMvc.TypeDonation;
acc.image = DMvc.image;
acc.dateajout = DMvc.dateajout;
acc.disponibilite = DMvc.disponibilite;
acc.email = acc.email;
if (ModelState.IsValid)
{
sc.Update(acc);
sc.Commit();
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult AddDonation()
{
ViewBag.Message = "Add Donation.";
int userid = (int)Session["id"];
int requestid = int.Parse(Request["reqID"]);
// check 2 months.
try
{
donation don = db.donations.Where(d => d.userid == userid).OrderByDescending(m => m.datetime).First();
double days = (DateTime.Now - don.datetime).TotalDays;
if (days > 60)
{
bloodrequest req = db.bloodrequests.Find(requestid);
req.ishandle = true;
db.SaveChanges();
donation d = new donation();
d.bloodrequestid = requestid;
d.userid = userid;
d.datetime = DateTime.Now;
db.donations.Add(d);
db.SaveChanges();
}
}
catch (Exception e) {
bloodrequest req = db.bloodrequests.Find(requestid);
req.ishandle = true;
// db.SaveChanges();
donation d = new donation();
d.bloodrequestid = requestid;
d.userid = userid;
d.datetime = DateTime.Now;
db.donations.Add(d);
db.SaveChanges();
}
// Add donation here
return(RedirectToAction("bloodrequests"));
}
// GET: donations/Create
public ActionResult Create()
{
try
{
if (Session["role"] != null)
{
if (Session["role"].ToString() == "USR")
{
//GET THE USER ID, FROM THERE CROSS CHECK WITH USERS_ID FROM NSA AND FIND THE ID. IF IT EXISTS, THEN REDIRECT
int count = 0;
int user_id = Convert.ToInt16(Session["userId"]);
var account = db.north_shore_accounts.Where(a => a.user_id == user_id);
foreach(var item in account)
{
count += 1;
}
if(count > 0)
{
return RedirectToAction("UserCreateView");
}
//IF THERE IS NO DONATION ACCOUNT, BUT THEY ARE A USER, THEN REDIRECT TO DONATION PAGE WITHOUT REGISTRATION
else
{
return RedirectToAction("UserWithoutAccount");
}
}
}
//IF THEY ARE AN ADMIN OR ANONYMOUS,MAKE THEM CREATE AN ACCOUNT
donation donation = new donation();
ViewBag.province_char = new SelectList(db.provinces, "code", "name");
return View();
}
catch(Exception e)
{
ViewBag.GenericException = e.Message;
}
return View("~/Navigate/Errors");
}
partial void Updatedonation(donation instance);
protected void Insert_Select_Record(object sender, EventArgs e)
{
donation = Insert_donation_select(Convert.ToInt32(Insert_donation_GridView.SelectedValue));
}
protected void UPDATE(object sender, EventArgs e)
{
donation = donation_update(Convert.ToInt32(Update_donation_GridView.SelectedValue));
}
protected void Update_Select_Record(object sender, EventArgs e)
{
donation = Update_donation_select(Convert.ToInt32(Update_donation_GridView.SelectedValue));
}
partial void Insertdonation(donation instance);
protected void INSERT(object sender, EventArgs e)
{
donation = donation_insert();
}
partial void Deletedonation(donation instance);
