public ActionResult EditDonation(string id) { if (Session[Shared.Constants.SESSION_ADMIN] == null) { return(RedirectToAction("Login")); } List <UserDonation> lstDonation = UserDonationManager.GetUserDonation("DonationID='" + id + "'", null); return(View(lstDonation.First())); }
public ActionResult GetAllDonations() { if (Session[Shared.Constants.SESSION_ADMIN] == null) { return(RedirectToAction("Login")); } //select* from userdonation d, user u where d.donationstatus = 'pending ' and d.userid = u.userid List <UserDonation> lstDonation = UserDonationManager.GetAll("", null); return(View(lstDonation)); }
public ActionResult EditDonation(UserDonation obj) { if (Session[Shared.Constants.SESSION_ADMIN] == null) { return(RedirectToAction("Login")); } string ret = Shared.Constants.MSG_ERR_NOUSEREXIST.Text; ret = UserDonationManager.SaveUserDonation(obj); if (ret.Equals(Shared.Constants.MSG_OK_DBSAVE.Text)) { return(RedirectToAction("GetAllPendingDonation", "Admin")); } return(RedirectToAction("EditDonation", "Admin")); }
public ActionResult AddDonation(UserDonation objDonation) { objDonation.RequestDate = DateTime.Now.Date; objDonation.DonationStatus = Shared.Constants.DonationStatusPending; string ret = Shared.Constants.MSG_ERR_NOUSEREXIST.Text; MySqlConnection conn = Shared.BaseManager.PrimaryConnection(); conn.Open(); var transaction = conn.BeginTransaction(); ret = UserDonationManager.SaveUserDonation(objDonation, conn, transaction); bool err = false; if (!ret.Equals(Shared.Constants.MSG_ERR_DBSAVE.Text)) { for (int i = 0; i < objDonation.ItemName.Count; i++) { DonationDetails objDD = new DonationDetails(); objDD.DONATIONID = Convert.ToInt32(ret); objDD.ITEMNAME = objDonation.ItemName[i]; objDD.QUANTITY = objDonation.Quantity[i]; string res = DonationDetailManager.SaveDonationDetail(objDD, conn, transaction); if (res.Equals(Shared.Constants.MSG_ERR_DBSAVE.Text)) { err = true; break; } } if (!err) { transaction.Commit(); conn.Close(); conn.Dispose(); return(RedirectToAction("GetAllPendingDonation", "Admin")); } //return RedirectToAction("GetAllPendingDonation", "Admin"); } transaction.Rollback(); conn.Close(); conn.Dispose(); return(RedirectToAction("AddDonation", "Admin")); }