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