public static List <CRFITStatus> GetCRFITStatus() { List <CRFITStatus> ds = new List <CRFITStatus>(); try { DbCommand dbcmd = mDatabase.GetStoredProcCommand("uspGetCRFStatus"); using (IDataReader reader = mDatabase.ExecuteReader(dbcmd)) { while (reader.Read()) { //iUserID vcWindowsLogin vcFirstName vcLastName vcEmail CRFITStatus i = new CRFITStatus(); i.CRFStatusID = reader["iCRFStatusId"] == DBNull.Value ? Convert.ToInt32(-1) : (Int32)reader["iCRFStatusId"]; i.CRFStatus = reader["vcCRFStatus"] == DBNull.Value ? "" : (string)reader["vcCRFStatus"]; ds.Add(i); } } } catch (Exception ex) { throw ex; } return(ds); }
public static List<CRFITStatus> GetCRFITStatus() { List<CRFITStatus> ds = new List<CRFITStatus>(); try { DbCommand dbcmd = mDatabase.GetStoredProcCommand("uspGetCRFStatus"); using (IDataReader reader = mDatabase.ExecuteReader(dbcmd)) { while (reader.Read()) { //iUserID vcWindowsLogin vcFirstName vcLastName vcEmail CRFITStatus i = new CRFITStatus(); i.CRFStatusID = reader["iCRFStatusId"] == DBNull.Value ? Convert.ToInt32(-1) : (Int32)reader["iCRFStatusId"]; i.CRFStatus = reader["vcCRFStatus"] == DBNull.Value ? "" : (string)reader["vcCRFStatus"]; ds.Add(i); } } } catch (Exception ex) { throw ex; } return ds; }