public int Add(AppointmentEligibilty ApptEligibility)
{
int returnID = -1;
DbCommand commandWrapper = GetDbCommand("spr_AddApptEligibiltyQuestion");
try
{
SqlParameter returnParam = new SqlParameter("@NewAEQuestionID", SqlDbType.Int);
returnParam.Direction = ParameterDirection.Output;
commandWrapper.Parameters.Add(returnParam);
if (string.IsNullOrWhiteSpace(ApptEligibility.AEQuestion))
{
commandWrapper.Parameters.Add(new SqlParameter("@AEQuestion", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@AEQuestion", ApptEligibility.AEQuestion.Trim()));
}
commandWrapper.Parameters.Add(new SqlParameter("@Active", ApptEligibility.Active));
ExecuteNonQuery(commandWrapper);
ApptEligibility.AEQuestionID = (int)returnParam.Value;
}
catch (Exception ex)
{
HandleException(ex);
}
return(returnID);
}
public List <AppointmentEligibilty> GetAllActiveAppointmentEligibiltyQuestion()
{
List <AppointmentEligibilty> listCollection = new List <AppointmentEligibilty>();
DataTable dataItems = ExecuteDataTable("spr_GetAllActiveApptEligibiltyQuestion");
if (dataItems != null)
{
for (int i = 0; i < dataItems.Rows.Count; i++)
{
AppointmentEligibilty item = new AppointmentEligibilty();
item.AEQuestionID = dataItems.Rows[i].Field <int>("AEQuestionID");
item.AEQuestion = dataItems.Rows[i].Field <string>("AEQuestion");
item.Active = dataItems.Rows[i].Field <bool>("Active");
listCollection.Add(item);
}
}
else
{
throw new Exception("You cannot create a Appointment Eligibility collection from a null data table.");
}
return(listCollection);
}
public void Delete(AppointmentEligibilty ApptEligibility)
{
if (base.ValidateKeyField(ApptEligibility.AEQuestionID))
{
try
{
ExecuteNonQuery("spr_DeleteApptEligibiltyQuestion", ApptEligibility.AEQuestionID);
}
catch (Exception ex)
{
HandleException(ex);
}
}
}
protected virtual AppointmentEligibilty FillObjectFromRowData(DataRow returnRow)
{
AppointmentEligibilty AppotEligibilty = new AppointmentEligibilty();
if (returnRow["AEQuestionID"] != DBNull.Value)
{
AppotEligibilty.AEQuestionID = (int)returnRow["AEQuestionID"];
}
if (returnRow["AEQuestion"] != DBNull.Value)
{
AppotEligibilty.AEQuestion = returnRow["AEQuestion"].ToString();
}
if (returnRow["Active"] != DBNull.Value)
{
AppotEligibilty.Active = (bool)returnRow["Active"];
}
return(AppotEligibilty);
}
public void Update(AppointmentEligibilty ApptEligibility)
{
if (base.ValidateKeyField(ApptEligibility.AEQuestionID))
{
DbCommand commandWrapper = GetDbCommand("spr_UpdateApptEligibiltyQuestion");
try
{
if (ApptEligibility.AEQuestionID == -1)
{
commandWrapper.Parameters.Add(new SqlParameter("@AEQuestionID", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@AEQuestionID", ApptEligibility.AEQuestionID));
}
if (string.IsNullOrWhiteSpace(ApptEligibility.AEQuestion))
{
commandWrapper.Parameters.Add(new SqlParameter("@AEQuestion", DBNull.Value));
}
else
{
commandWrapper.Parameters.Add(new SqlParameter("@AEQuestion", ApptEligibility.AEQuestion.Trim()));
}
commandWrapper.Parameters.Add(new SqlParameter("@Active", ApptEligibility.Active));
ExecuteNonQuery(commandWrapper);
}
catch (Exception ex)
{
HandleException(ex);
}
}
}
