/// <summary>
/// Returns the user profile for the specified username.
/// </summary>
/// <param name="username"></param>
/// <returns></returns>
public static List <SurveyCheckRec> GetSurveyCheckRecords()
{
List <SurveyCheckRec> records = new List <SurveyCheckRec>();
string query = "SELECT * FROM FN_GetSurveyChecks() ORDER BY CheckDate";
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())
{
SurveyCheckRec r = new SurveyCheckRec();
r.ID = (int)rdr["ID"];
r.CheckType = new SurveyCheckType((int)rdr["CheckTypeID"], rdr.SafeGetString("CheckType"));
r.Name = new Person(rdr.SafeGetString("Name"), (int)rdr["CheckInit"]);
r.Comments = rdr.SafeGetString("Comments");
r.SurveyCode = new Survey(rdr.SafeGetString("Survey"));
r.SurveyCode.SID = (int)rdr["SurvID"];
if (!rdr.IsDBNull(rdr.GetOrdinal("CheckDate")))
{
r.CheckDate = (DateTime)rdr["CheckDate"];
}
r.ReferenceSurveys = new BindingList <SurveyCheckRefSurvey>(GetSurveyCheckRefSurveys(r.ID));
records.Add(r);
}
}
}
catch (Exception)
{
int i = 0;
}
}
return(records);
}
public static int UpdateSurveyCheckRecord(SurveyCheckRec record)
{
using (SqlDataAdapter sql = new SqlDataAdapter())
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ISISConnectionString"].ConnectionString))
{
conn.Open();
sql.UpdateCommand = new SqlCommand("proc_updateSurveyCheckRecord", conn)
{
CommandType = CommandType.StoredProcedure
};
sql.UpdateCommand.Parameters.AddWithValue("@ID", record.ID);
sql.UpdateCommand.Parameters.AddWithValue("@checkDate", record.CheckDate);
sql.UpdateCommand.Parameters.AddWithValue("@checkInit", record.Name.ID);
//sql.UpdateCommand.Parameters.AddWithValue("@sendDate", record.SentOn);
//sql.UpdateCommand.Parameters.AddWithValue("@sendTo", record.SentTo.ID);
//sql.UpdateCommand.Parameters.AddWithValue("@reviewed", record.Reviewed);
//sql.UpdateCommand.Parameters.AddWithValue("@reviewedBy", record.ReviewedBy.ID);
//sql.UpdateCommand.Parameters.AddWithValue("@reviewDetails", record.ReviewDetails);
//sql.UpdateCommand.Parameters.AddWithValue("@editsMadeDate", record.Edited);
sql.UpdateCommand.Parameters.AddWithValue("@comments", record.Comments);
sql.UpdateCommand.Parameters.AddWithValue("@survID", record.SurveyCode.SID);
sql.UpdateCommand.Parameters.AddWithValue("@checkType", record.CheckType.ID);
try
{
sql.UpdateCommand.ExecuteNonQuery();
}
catch (Exception)
{
return(1);
}
}
return(0);
}
