internal IEnumerable <AuditQuestions> GetAuditQuestions(int Id) { SqlConnection conn = null; SqlDataReader dr = null; List <AuditQuestions> questions = new List <AuditQuestions>(); try { conn = new SqlConnection(cnxString); conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "dbo.QA_Audit_sel_question"; cmd.Parameters.AddWithValue("@idtestdata", DbType.String).Value = Id; using (dr = cmd.ExecuteReader()) { while (dr.HasRows && dr.Read()) { AuditQuestions q = new AuditQuestions(); q.Id = dr.GetInt32(0); q.QuestionNumber = dr.GetInt32(1); q.Question = dr.GetString(2); q.SourcePass = dr.IsDBNull(3) ? false : dr.GetBoolean(3); q.Notes = dr.IsDBNull(4) ? string.Empty : dr.GetString(4); q.VerifiedBy = dr.IsDBNull(5) ? string.Empty : dr.GetString(5); q.VerifiedOn = dr.IsDBNull(6) ? string.Empty : dr.GetString(6); questions.Add(q); } dr.Close(); } } catch (Exception e) { } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } if (conn != null) { conn.Close(); } } return(questions); }
internal bool UpdateAuditDetail(AuditQuestions audit) { bool flag = false; SqlConnection conn = null; try { conn = new SqlConnection(cnxString); conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "dbo.QA_Audit_upd_secondary"; cmd.Parameters.AddWithValue("@Sourceinfoid", DbType.String).Value = audit.Id; cmd.Parameters.AddWithValue("@QuestionNumber", DbType.Int32).Value = audit.QuestionNumber; cmd.Parameters.AddWithValue("@PassFail", DbType.Int32).Value = Convert.ToInt32(audit.SourcePass); cmd.Parameters.AddWithValue("@Notes", DbType.Int32).Value = audit.Notes; cmd.Parameters.AddWithValue("@VerifyBy", DbType.Int32).Value = audit.VerifiedBy; cmd.ExecuteNonQuery(); flag = true; } catch (Exception e) { flag = false; } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } if (conn != null) { conn.Close(); } } return(flag); }