protected void Login1_Authenticate(object sender, AuthenticateEventArgs e) { string password = Hash(Login1.Password); using (DataClasses1DataContext db = new DataClasses1DataContext()) { var department = from a in db.Peoples where (a.UserName == Login1.UserName) && (a.PasswordHash == password) select a; foreach( var n in department) { if (n.DepartmentID == 2) { Session["User"] = -1; Response.Redirect("QABugs.aspx"); } else if (n.DepartmentID == 1) { Session["User"] = n.PersonID; Response.Redirect("DevBugs.aspx"); } else if (n.DepartmentID == 3) { Session["User"] = n.PersonID; Response.Redirect("BugsGalore.aspx"); } } } }
protected void GridView1_SelectedIndexChanged1(object sender, EventArgs e) { int key = (int)GridView1.SelectedDataKey.Value; lblRow.Text = ""; using(DataClasses1DataContext db = new DataClasses1DataContext()) { int count = 0; var selectedBug = from n in db.Bugs where n.BugID == key select n; var selectedHistories = from n in db.BugHistories orderby n.DateStamp where n.BugID == key select n; foreach (var n in selectedBug) { int id = n.ReporterID; var reporter = from a in db.Peoples where a.PersonID == id select a.FullName; lblRow.Text += "Product: " + n.ProductName + "<br/>Description: " + n.Description + "<br/>Reporter: " + reporter.ToList()[0] + "<br/>"; } foreach (var n in selectedHistories) { string name = ""; if(n.OwnerID == -1) name = "QA"; else{ var owner = from a in db.Peoples where a.PersonID == n.OwnerID select a.FullName; name = owner.ToList()[0]; } if(count == 0){ lblRow.Text += "Date: " + n.DateStamp + "<br/>Status: " + n.Status + "<br/><br/>"; } else{ lblRow.Text += "Date: " + n.DateStamp + "<br/>Status: " + n.Status + "<br/>Response: " + n.Response + "<br/>Owner: " + name + "<br/><br/>"; } count++; } } }
protected void btnSubmit_Click(object sender, EventArgs e) { string severity = ddlSeverity.SelectedValue; string owner = DropDownList1.SelectedValue; if (severity.Equals("")) severity = Severity; if (severity != null) severity = severity.Trim(); if (txtResponse.Text.Equals("")) { lblError.Text = "The response field is required"; return; } // Insert record into bugHistory BugHistory newRecord = new BugHistory(); newRecord.BugID = (int)Session["Modify"]; newRecord.Status = Status; newRecord.Severity = severity; newRecord.Response = txtResponse.Text; newRecord.DateStamp = DateTime.Now; if (owner == null || owner.Equals("") || owner.Equals("11")) newRecord.OwnerID = -1; else newRecord.OwnerID = int.Parse(owner); using (DataClasses1DataContext db = new DataClasses1DataContext()) { db.BugHistories.InsertOnSubmit(newRecord); db.SubmitChanges(); } Response.Redirect("DevBugs.aspx"); }
protected void btnAddBug_Click(object sender, EventArgs e) { int User = (int)Session["User"]; if (txtDescription.Text == "" || ddlProducts.SelectedValue == "") { Response.Write(@"<script language='javascript'>alert('Both Fields are required');</script>"); } else { // add bug to db using (DataClasses1DataContext db = new DataClasses1DataContext()) { Bug newBug = new Bug(); newBug.Description = txtDescription.Text; newBug.ProductName = ddlProducts.SelectedValue; newBug.ReporterID = User; db.Bugs.InsertOnSubmit(newBug); db.SubmitChanges(); var id = (from a in db.Bugs select a.BugID).Max(); BugHistory newHistory = new BugHistory(); newHistory.BugID = id; newHistory.OwnerID = -1; newHistory.Status = "Open"; newHistory.DateStamp = DateTime.Now; db.BugHistories.InsertOnSubmit(newHistory); db.SubmitChanges(); } Response.Redirect("BugsGalore.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { int usr = (int)Session["User"]; int bugID = (int)Session["Modify"]; lblRow.Text = ""; using (DataClasses1DataContext db = new DataClasses1DataContext()) { int count = 0; var selectedBug = from n in db.Bugs where n.BugID == bugID select n; var selectedHistories = from n in db.BugHistories orderby n.DateStamp where n.BugID == bugID select n; foreach (var n in selectedBug) { int id = n.ReporterID; var reporter = from a in db.Peoples where a.PersonID == id select a.FullName; lblRow.Text += "Product: " + n.ProductName + "<br/>Description: " + n.Description + "<br/>Reporter: " + reporter.ToList()[0] + "<br/>"; } foreach (var n in selectedHistories) { string name = ""; if (n.OwnerID == -1) name = "QA"; else { var owner = from a in db.Peoples where a.PersonID == n.OwnerID select a.FullName; name = owner.ToList()[0]; } if (count == 0) { lblRow.Text += "Date: " + n.DateStamp + "<br/>Status: " + n.Status + "<br/><br/>"; } else { lblRow.Text += "Date: " + n.DateStamp + "<br/>Status: " + n.Status + "<br/>Response: " + n.Response + "<br/>Owner: " + name + "<br/><br/>"; } Status = n.Status; Severity = n.Severity; Owner = n.OwnerID; count++; } Records++; } }
protected void btnSubmit_Click(object sender, EventArgs e) { string owner = ddlOwner.SelectedValue; string status = ddlStatus.SelectedValue; string severity = ddlSeverity.SelectedValue; if(ddlStatus.SelectedValue.Equals("Closed")) owner = "QA"; else if(owner.Equals("11")) owner = ""; if(severity.Equals("")) severity = Severity; if (status.Equals("")) status = Status; owner = owner.Trim(); status = status.Trim(); if (severity != null) severity = severity.Trim(); if (status.Equals("Open") && Records <= 1) { if (severity == null) { lblError.Text = "The severity field is required"; return; } if(severity.Equals("")){ lblError.Text = "The severity field is required"; return; } if (owner.Equals("")) { lblError.Text = "An owner must be assigned"; } } if (owner.Equals("") && status.Equals("") && severity == null) { lblError.Text = "No changes were made"; return; } if (txtResponse.Text.Equals("")) { lblError.Text += "The response field is required"; return; } // Insert record into bugHistory BugHistory newRecord = new BugHistory(); newRecord.BugID = (int) Session["Modify"]; newRecord.Status = status; newRecord.Severity = severity; newRecord.Response = txtResponse.Text; newRecord.DateStamp = DateTime.Now; if(owner == null || owner.Equals("") || owner.Equals("QA")) newRecord.OwnerID = -1; else newRecord.OwnerID = int.Parse(owner); using (DataClasses1DataContext db = new DataClasses1DataContext()) { db.BugHistories.InsertOnSubmit(newRecord); db.SubmitChanges(); } Response.Redirect("QABugs.aspx"); }