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 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"); }
partial void DeleteBugHistory(BugHistory instance);
partial void UpdateBugHistory(BugHistory instance);
partial void InsertBugHistory(BugHistory instance);