public static DonationBO MapDOtoBO(IDonationDO iFrom)
{
DonationBO oTo = new DonationBO(); //creating new instance PO
//BO //DO
oTo.DonationID = iFrom.DonationID;
oTo.UserID = iFrom.UserID;
oTo.Amount = iFrom.Amount;
oTo.CardNumber = iFrom.CardNumber;
oTo.Rendered = iFrom.Rendered;
return(oTo); //returning object
}
public void UpdateDonation(IDonationDO iDonation)
{
try
{
using (SqlConnection connectionToSql = new SqlConnection(_ConnectionString))
{
using (SqlCommand command = new SqlCommand("UPDATE_DONATIONS", connectionToSql))
{
try
{
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 30;
//Passing parameters from sql
command.Parameters.AddWithValue("@DonationID", iDonation.DonationID);
command.Parameters.AddWithValue("@UserID", iDonation.UserID);
command.Parameters.AddWithValue("@Amount", iDonation.Amount);
command.Parameters.AddWithValue("@CardNumber", iDonation.CardNumber);
command.Parameters.AddWithValue("@Rendered", iDonation.Rendered);
connectionToSql.Open();
command.ExecuteNonQuery();
}
catch (Exception e)
{
throw (e);
}
finally
{
connectionToSql.Close();
connectionToSql.Dispose();
}
}
}
}
catch (Exception e)
{
throw (e);
}
finally
{
//Onshore standards
}
}
public ActionResult UpdateDonation(DonationVM iDonation)
{
ActionResult oResponse = null;
if (Session["Username"] == null || (Int16)Session["Role"] != 1)
{
//Power User & User redirected
oResponse = RedirectToAction("Index", "Home");
}
else //Admin
{
if (ModelState.IsValid) //Info correct
{
try
{
//put mapping into a variable
IDonationDO update = DonationMap.MapPOtoDO(iDonation.Donation);
//Use of method from DAL
DonationAccess.UpdateDonation(update);
//Return the list of donations
oResponse = RedirectToAction("ViewDonations", "Donation");
}
catch (Exception e)
{
iDonation.ErrorMessage = "Sorry we are unable to handle your request";
ErrorLog.LogError(e); //Log into file
oResponse = RedirectToAction("UpdateDonation", "Donation");
}
finally
{
//Onshore standards
}
}
else //Info incorrect
{
oResponse = View(iDonation);
}
}
return(oResponse);
}
public ActionResult CreateDonations(DonationVM iDonation)
{
ActionResult oResponse = null; //defining our varivale
if (Session["Username"] == null) //Guest
{
oResponse = RedirectToAction("Index", "Home");
}
else //Users,Power User, Admin
{
if (ModelState.IsValid)//If info was entered correctly
{
try
{
//set mapping to a variable to be used to convert POtoDO
IDonationDO DonationForm = DonationMap.MapPOtoDO(iDonation.Donation);
//Use the method from DAL to preform action
DonationAccess.CreateDonation(DonationForm);
//Redirect to view using UserID from database
oResponse = RedirectToAction("ViewDonationsbyUserID", "User", new { UserID = (long)Session["UserID"] });
}
catch (Exception e) //If problem with sql connection
{
iDonation.ErrorMessage = "We are sorry, We cannot process your request at this time";
ErrorLog.LogError(e); //Log to file
oResponse = View(iDonation); //return view
}
finally
{
//Onshore standards
}
}
else //If info was incorrect
{
oResponse = View(iDonation);
}
}
return(oResponse);
}
public ActionResult UpdateDonation(long DonationID)
{
ActionResult oResponse = null;
if (Session["Username"] == null || (Int16)Session["Role"] != 1)
{
//Power User & User redirected
oResponse = RedirectToAction("Index", "Home");
}
else //Admin
{
//Create a new instance of the object
DonationVM newVM = new DonationVM();
//set the method to a variable to be used
IDonationDO donation = DonationAccess.ViewDonationsByID(DonationID);
//set mapping to a variable
newVM.Donation = DonationMap.MapDOtoPO(donation);
//return view
oResponse = View(newVM);
}
return(oResponse);
}
