public IActionResult Post([FromBody] UserDonation userDonation) { _repository.UserDonation.CreateUserDonation(userDonation); _repository.Save(); return(CreatedAtAction("GetById", new { id = userDonation.Id }, new { UserDonation = userDonation })); }
public IActionResult Put(long id, [FromBody] UserDonation userDonation) { var userDonationFromDb = _repository.UserDonation.GetById(id, true); if (userDonationFromDb == null) { return(NotFound()); } userDonationFromDb.Amount = userDonation.Amount; _repository.Save(); return(NoContent()); }
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")); }
public List <UserDonation> getDonations() { SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["connection"].ConnectionString); con.Open(); string SQLString = "SELECT R.First_Name, R.Last_Name, R.Email, R.Country, R.State, R.City, " + "D.amount, D.date, D.displayName " + "FROM Register_FMSC R INNER JOIN Donate D ON R.Email = D.userId; "; SqlCommand checkIDTable = new SqlCommand(SQLString, con); SqlDataReader records = null; try { records = checkIDTable.ExecuteReader(); if (records.HasRows) { List <UserDonation> userDonations = new List <UserDonation>(); while (records.Read()) { User user = new User(records.GetString(0), records.GetString(1), records.GetString(2), records.GetString(3), records.GetString(4), records.GetString(5)); Donation donation = new Donation(Convert.ToDouble(records.GetDecimal(6)), Convert.ToDateTime(records.GetString(7)), records.GetString(8)); UserDonation userDonation = new UserDonation(donation, user); userDonations.Add(userDonation); } records.Close(); return(userDonations); } else { records.Close(); return(null); } } catch (Exception exp) { return(null); } }