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