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