internal IEnumerable <AuditArchive> GetAuditArchive(int SourceInfoId = 0, int id = 0, bool?isActive = false)
{
SqlConnection conn = null;
SqlDataReader dr = null;
List <AuditArchive> archives = new List <AuditArchive>();
try
{
conn = new SqlConnection(cnxString);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "dbo.QA_Audit_sel_archive_main";
cmd.Parameters.AddWithValue("@SourceInfoid", DbType.String).Value = SourceInfoId;
cmd.Parameters.AddWithValue("@id", DbType.Int32).Value = id;
if (isActive != null)
{
cmd.Parameters.AddWithValue("@isActive", DbType.Int32).Value = Convert.ToInt32(isActive);
}
using (dr = cmd.ExecuteReader())
{
while (dr.HasRows && dr.Read())
{
AuditArchive archive = new AuditArchive();
archive.Id = dr.GetInt32(0);
archive.SourceInfoId = dr.GetInt32(1);
archive.IsActive = dr.GetBoolean(2);
archive.StartTime = dr.GetDateTime(3);
archive.EndTime = dr.IsDBNull(4) ? DateTime.MinValue : dr.GetDateTime(4);
archive.CreatedBy = dr.GetString(5);
archive.SourcePass = dr.GetBoolean(6);
archive.SourceName = dr.GetString(7);
archive.QATeamNotes = dr.IsDBNull(8) ? String.Empty : dr.GetString(8);
archive.SourceUrl = dr.IsDBNull(9) ? string.Empty : dr.GetString(9);
archives.Add(archive);
}
dr.Close();
}
}
catch (Exception e)
{ }
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
if (conn != null)
{
conn.Close();
}
}
return(archives);
}
protected void ddl_history_SelectedIndexChanged(object sender, EventArgs e)
{
string[] ids = ddl_history.SelectedValue.Split('|');
Int32.TryParse(ids[0], out Sourceinfoid);
Int32.TryParse(ids[1], out idmain);
IEnumerable <AuditArchive> history = (IEnumerable <AuditArchive>)ViewState["history"];
AuditArchive a = history.Where(p => p.Id.ToString() == ids[1]).SingleOrDefault();
lb_qa_team_notes.Text = a.QATeamNotes;
loadTestData(Sourceinfoid, idmain);
}
internal IEnumerable <AuditArchive> GetDistinctArchive()
{
SqlConnection conn = null;
SqlDataReader dr = null;
List <AuditArchive> archives = new List <AuditArchive>();
try
{
conn = new SqlConnection(cnxString);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "dbo.QA_Audit_sel_archive_main_distinct";
using (dr = cmd.ExecuteReader())
{
while (dr.HasRows && dr.Read())
{
AuditArchive archive = new AuditArchive();
//archive.Id = dr.GetInt32(0);
archive.SourceInfoId = dr.GetInt32(0);
//archive.IsActive = dr.GetBoolean(2);
//archive.StartTime = dr.GetDateTime(3);
//archive.EndTime = dr.IsDBNull(4) ? DateTime.MinValue : dr.GetDateTime(4);
//archive.CreatedBy = dr.GetString(5);
//archive.SourcePass = dr.GetBoolean(6);
archive.SourceName = dr.GetString(1);
archives.Add(archive);
}
dr.Close();
}
}
catch (Exception e)
{ }
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
if (conn != null)
{
conn.Close();
}
}
return(archives);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Int32.TryParse(Request.QueryString.Get("Sourceinfoid"), out Sourceinfoid);
//Sourceinfoid = 2224;
if (Sourceinfoid == 0)
{
Response.Redirect("Default.aspx", true);
}
else
{
lnk_see_all.NavigateUrl = lnk_see_all.NavigateUrl + "?SourceInfoid=" + Sourceinfoid.ToString();
IEnumerable <AuditArchive> history = serv.GetAllArchive(Sourceinfoid).Take(3);
gv_lastest.DataSource = history;
gv_lastest.DataBind();
AuditArchive activeArchive = serv.GetActiveArchive(Sourceinfoid, 0);
if (activeArchive != null)
{
startTimeActive.Value = activeArchive.StartTime.ToString("dd-MM-yyyy HH:mm:ss");
endTimeActive.Value = activeArchive.EndTime.ToString("dd-MM-yyyy HH:mm:ss");
}
if (activeArchive != null && activeArchive.EndTime > DateTime.Now)
{
CreateGridAndHeaderInfo(true);
}
else
{
if (activeArchive != null)
{
activeArchive.IsActive = false;
serv.UpdateArchive(activeArchive);
Response.Redirect(Request.RawUrl);
}
btn_confirm_start_audit.Visible = true;
AuditMain audit = serv.GetAuditBySourceInfoId(Sourceinfoid, true);
lb_sourceinfoid.Text = Sourceinfoid.ToString();
lb_sourcename.Text = audit.SourceName;
lb_sourcetype.Text = audit.SourceType;
lb_lastaudited.Text = audit.LastAudited.ToString();;
lb_passfail.Text = audit.SourcePass == true ? "Passed" : "Failed";
lb_url.Text = audit.SourceUrl;
}
}
}
}
protected void btn_end_audit_Click(object sender, EventArgs e)
{
Int32.TryParse(Request.QueryString.Get("Sourceinfoid"), out Sourceinfoid);
//Sourceinfoid = 2224;
AuditArchive activeArchive = serv.GetActiveArchive(Sourceinfoid, 0);
if (activeArchive != null)
{
activeArchive.IsActive = false;
activeArchive.SourcePass = Convert.ToBoolean(auditStatus.Value);
activeArchive.EndTime = DateTime.Now;
activeArchive.QATeamNotes = txt_qa_team_notes.Text;
serv.UpdateArchive(activeArchive);
Response.Redirect(Request.RawUrl);
}
}
protected void loadTestData(int Sourceinfoid, int idmain)
{
IEnumerable <AuditArchive> history = (IEnumerable <AuditArchive>)ViewState["history"];
AuditArchive audit = history.Where(p => p.SourceInfoId == Sourceinfoid && p.Id == idmain).SingleOrDefault();
lb_sourceinfoid.Text = Sourceinfoid.ToString();
lb_sourcename.Text = audit.SourceName;
lb_created.Text = audit.CreatedBy;
lb_passfail.Text = audit.SourcePass == true ? "Passed" : audit.StartTime.AddDays(1) == audit.EndTime ? "Incomplete" : "Failed";
lb_url.Text = audit.SourceUrl;
grid1.Visible = true;
pnl_main.Visible = true;
grid1.DataSource = serv.GetAuditTestDataArchive(Sourceinfoid, idmain);;
grid1.DataBind();
}
internal bool UpdateArchive(AuditArchive 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_archive_main";
cmd.Parameters.AddWithValue("@id", DbType.Int32).Value = audit.Id;
cmd.Parameters.AddWithValue("@PassFail", DbType.Int32).Value = audit.SourcePass;
cmd.Parameters.AddWithValue("@isActive", DbType.Int32).Value = audit.IsActive;
cmd.Parameters.AddWithValue("@QATeamNotes", DbType.String).Value = audit.QATeamNotes;
cmd.Parameters.AddWithValue("@StartTime", DbType.Date).Value = audit.StartTime;
cmd.Parameters.AddWithValue("@EndTime", DbType.Date).Value = audit.EndTime;
cmd.ExecuteNonQuery();
flag = true;
}
catch (Exception e)
{
flag = false;
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
if (conn != null)
{
conn.Close();
}
}
return(flag);
}
public bool UpdateArchive(AuditArchive audit)
{
return(dbClient.UpdateArchive(audit));
}
