public recipientModel CreateRecpient(recipientModel currentRecipient)
{
///uses create procedure to insert values into the model parameters
DbCommand create_Recipient = db.GetStoredProcCommand("sp_createct2Recipient");
db.AddInParameter(create_Recipient, "@recipientID", DbType.Int32, currentRecipient.recipientID);
db.AddInParameter(create_Recipient, "@firstName", DbType.String, currentRecipient.firstName);
db.AddInParameter(create_Recipient, "@lastName", DbType.String, currentRecipient.lastName);
db.AddInParameter(create_Recipient, "@recipientGender", DbType.Int32, currentRecipient.recipientGender);
return(currentRecipient);
}
public bool UpdateListrecipient(recipientModel selectedRecipient)
{
///uses update procedure to make changes to parameter values
Boolean success = false;
DbCommand update_Recipient = db.GetStoredProcCommand("sp_updatect2Recipient");
db.AddInParameter(update_Recipient, "@recipientID", DbType.Int32, selectedRecipient.recipientID);
db.AddInParameter(update_Recipient, "@firstName", DbType.String, selectedRecipient.firstName);
db.AddInParameter(update_Recipient, "@lastName", DbType.String, selectedRecipient.lastName);
db.AddInParameter(update_Recipient, "@recipientGender", DbType.Int32, selectedRecipient.recipientGender);
success = Convert.ToBoolean(update_Recipient.ExecuteNonQuery());
return(success);
}
public bool DeleteRecipient(recipientModel deleteRecipient)
{
///uses delete procedure to remove list and all its values by the primary ID
DbCommand delete_Recipient = db.GetStoredProcCommand("sp_deletect2Recipient");
db.AddInParameter(delete_Recipient, "@recipientID", DbType.Int32, deleteRecipient.recipientID);
db.AddOutParameter(delete_Recipient, "@success", DbType.Boolean, 1);
bool success;
try
{
db.ExecuteNonQuery(delete_Recipient);
success = Convert.ToBoolean(db.GetParameterValue(delete_Recipient, "@success"));
}
catch
{
success = false;
}
return(success);
}
