public List <ExamTimes> CRUDExamTimes(ExamTimes exams, string action)
{
List <ExamTimes> examList = new List <ExamTimes>();
try
{
DataTable dtResponse = examDA.CRUDExamTimes(exams, action);
if (dtResponse != null && dtResponse.Rows.Count > 0)
{
examList = dtResponse.ConvertToListOf <ExamTimes>();
}
}
catch (Exception ex)
{
throw;
}
return(examList);
}
public DataTable CRUDExamTimes(ExamTimes ansType, string action)
{
DataTable dtResult = new DataTable();
try
{
SqlParameter objSqlParameter = new SqlParameter("ExamTimesId", ansType.ExamTimesId);
SqlParameter objSqlParameter1 = new SqlParameter("ExamTime", ansType.ExamTime);
SqlParameter objSqlParameter2 = new SqlParameter("Description", ansType.Description);
SqlParameter objSqlParameter3 = new SqlParameter("LoggedInUser", ansType.LoggedInUser);
SqlParameter objSqlParameter4 = new SqlParameter("Action", action);
List <SqlParameter> lstSqlParams = DBCommon.GetSqlParameterList(new SqlParameter[] { objSqlParameter, objSqlParameter1, objSqlParameter2, objSqlParameter3, objSqlParameter4 });
dtResult = DBCommon.ExecuteDataAdapterDataTable("uspCrudExamTimes", lstSqlParams);
}
catch (Exception ex)
{
throw;
}
return(dtResult);
}
