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); }