public donationModel CreateCompany(donationModel currentDonation)
{
///uses create procedure to insert values into the model parameters
DbCommand create_Donation = db.GetStoredProcCommand("sp_createct2Donation");
db.AddInParameter(create_Donation, "@donationID", DbType.Int32, currentDonation.donationID);
db.AddInParameter(create_Donation, "@userIDFK", DbType.Int32, currentDonation.userIDFK);
db.AddInParameter(create_Donation, "@user", DbType.Object, currentDonation.user);
db.AddInParameter(create_Donation, "@eventIDFK", DbType.Int32, currentDonation.eventIDFK);
db.AddInParameter(create_Donation, "@events", DbType.Object, currentDonation.events);
db.AddInParameter(create_Donation, "@dateSubmitted", DbType.DateTime, currentDonation.dateSubmitted);
db.AddInParameter(create_Donation, "@donationDescription", DbType.String, currentDonation.donationDescription);
db.AddInParameter(create_Donation, "@donationNotes", DbType.String, currentDonation.donationNotes);
return(currentDonation);
}
public bool UpdateListdonation(donationModel selectedDonation)
{
///uses update procedure to make changes to parameter values
Boolean success = false;
DbCommand update_Donation = db.GetStoredProcCommand("sp_updatect2Company");
db.AddInParameter(update_Donation, "@donationID", DbType.Int32, selectedDonation.donationID);
db.AddInParameter(update_Donation, "@userIDFK", DbType.Int32, selectedDonation.userIDFK);
db.AddInParameter(update_Donation, "@user", DbType.Object, selectedDonation.user);
db.AddInParameter(update_Donation, "@eventIDFK", DbType.Int32, selectedDonation.eventIDFK);
db.AddInParameter(update_Donation, "@events", DbType.Object, selectedDonation.events);
db.AddInParameter(update_Donation, "@dateSubmitted", DbType.DateTime, selectedDonation.dateSubmitted);
db.AddInParameter(update_Donation, "@donationDescription", DbType.String, selectedDonation.donationDescription);
db.AddInParameter(update_Donation, "@donationNotes", DbType.String, selectedDonation.donationNotes);
success = Convert.ToBoolean(update_Donation.ExecuteNonQuery());
return(success);
}
public bool DeleteDonation(donationModel deleteDonation)
{
///uses delete procedure to remove list and all its values by the primary ID
DbCommand delete_Donation = db.GetStoredProcCommand("sp_deletect2Donation");
db.AddInParameter(delete_Donation, "@donationID", DbType.Int32, deleteDonation.donationID);
db.AddOutParameter(delete_Donation, "@success", DbType.Boolean, 1);
bool success;
try
{
db.ExecuteNonQuery(delete_Donation);
success = Convert.ToBoolean(db.GetParameterValue(delete_Donation, "@success"));
}
catch
{
success = false;
}
return(success);
}
