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