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