public SurveyCheckRec()
{
CheckDate = DateTime.Today;
CheckType = new SurveyCheckType(0, "");
Name = new Person(0);
SurveyCode = new Survey();
ReferenceSurveys = new BindingList <SurveyCheckRefSurvey>();
Comments = "";
}
/// <summary>
/// Returns the user profile for the specified username.
/// </summary>
/// <param name="username"></param>
/// <returns></returns>
public static List <SurveyCheckType> GetSurveyCheckTypes()
{
List <SurveyCheckType> records = new List <SurveyCheckType>();
string query = "SELECT * FROM qrySurveyCheckTypes ORDER BY ID";
using (SqlDataAdapter sql = new SqlDataAdapter())
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ISISConnectionString"].ConnectionString))
{
conn.Open();
sql.SelectCommand = new SqlCommand(query, conn);
try
{
using (SqlDataReader rdr = sql.SelectCommand.ExecuteReader())
{
while (rdr.Read())
{
SurveyCheckType r = new SurveyCheckType();
r.ID = (int)rdr["ID"];
r.CheckName = rdr.SafeGetString("CheckType");
records.Add(r);
}
}
}
catch (Exception)
{
int i = 0;
}
}
return(records);
}
