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