private void button2_Click(object sender, EventArgs e) { if (textBox1.Text.Trim() == "" || textEditorControl1.Text.Trim() == "") { MessageBox.Show("One or More Fields Are Empty"); } try { MemoryStream ms = new MemoryStream(); img.Save(ms, img.RawFormat); BugHandlerEntities1 bte = new BugHandlerEntities1(); var InsIssue = new Issue { Title = textBox1.Text.Trim(), Description = textEditorControl1.Text.Trim(), Image = ms.ToArray(), Status = "PENDING", InsertedBy = session.Username }; bte.Issues.Add(InsIssue); bte.SaveChanges(); MessageBox.Show("Issue Saved"); } catch (Exception) { MessageBox.Show("Error Occured", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void button1_Click(object sender, EventArgs e) { try { BugHandlerEntities1 bte = new BugHandlerEntities1(); var data = bte.Issues.Where(a => a.Title == comboBox1.Text).SingleOrDefault(); data.Description = textEditorControl1.Text; data.SolvedBy = comboBox2.Text; if (data.Status == "ReOpened") { MessageBox.Show("Issue is already Re-Opened", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { if (checkBox1.Checked) { data.Status = "ReOpened"; } bte.Entry(data).State = EntityState.Modified; bte.SaveChanges(); MessageBox.Show("Saved"); } } catch (Exception) { MessageBox.Show("Error Occured", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void button1_Click(object sender, EventArgs e) { //SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\admin\Documents\BugHandler.mdf;Integrated Security=True;Connect Timeout=30"); BugHandlerEntities1 bhe = new BugHandlerEntities1(); var regUser = new Login { Username = textBox1.Text.Trim(), Password = textBox2.Text.Trim(), Role = "Client" }; bhe.Logins.Add(regUser); bhe.SaveChanges(); MessageBox.Show("User Saved"); }
private void button1_Click(object sender, EventArgs e) { try { BugHandlerEntities1 bte = new BugHandlerEntities1(); var data = bte.Issues.Where(a => a.Title == comboBox1.Text).SingleOrDefault(); data.Solution = textEditorControl2.Text; data.Status = "On Progress"; bte.Entry(data).State = EntityState.Modified; bte.SaveChanges(); MessageBox.Show("Saved"); } catch (Exception) { MessageBox.Show("Error Occured", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void button1_Click(object sender, EventArgs e) { //to remove all the unnecessary space if (textBox1.Text.Trim() == "" || textBox2.Text.Trim() == "") { MessageBox.Show("One or More Fields Are Empty"); } try { //using local variable for selecting the role of admin or programmer string userrole = ""; if (checkBox1.Checked) { userrole = "Admin"; } else { userrole = "Programmer"; } //to insert data in the database table Login BugHandlerEntities1 bhe = new BugHandlerEntities1(); var InsUser = new Login { Username = textBox1.Text.Trim(), Password = textBox2.Text.Trim(), Role = userrole }; //to show that the data are stored bhe.Logins.Add(InsUser); bhe.SaveChanges(); MessageBox.Show("User Saved"); } catch (Exception) { MessageBox.Show("Error Occured", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }