private void comboBox1_SelectedIndexChanged(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");
con.Open();
SqlCommand sqlCmd = new SqlCommand("Select * from Issue where Title ='" + comboBox1.Text + "'", con);
sqlCmd.ExecuteNonQuery();
SqlDataReader sdr;
sdr = sqlCmd.ExecuteReader();
while (sdr.Read())
{
string description = (string)sdr["Description"].ToString();
textEditorControl1.Text = description;
string solution = (string)sdr["Solution"].ToString();
textEditorControl2.Text = solution;
BugHandlerEntities1 bte = new BugHandlerEntities1();
var item = bte.Issues.Where(a => a.Title == comboBox1.Text).SingleOrDefault();
byte[] arr = item.Image;
MemoryStream ms = new MemoryStream(arr);
pictureBox1.Image = Image.FromStream(ms);
}
con.Close();
}
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);
}
}
//connecting to the database and loading the windows
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");
SqlDataAdapter sda = new SqlDataAdapter("Select Role from Login where Username = '******' and Password = '******' ",con);
DataTable dt = new System.Data.DataTable();
sda.Fill(dt);
if(dt.Rows.Count == 1)
{
BugHandlerEntities1 bte = new BugHandlerEntities1();
var role = bte.Logins.Where(a => a.Username == textBox1.Text).SingleOrDefault();
SessionModule session = new SessionModule();
session.Username = role.Username;
if (role.Role=="Admin")
{
BugHandlerAdmin bhs = new BugHandlerAdmin(session);
this.Hide();
bhs.Show();
}
else if (role.Role == "Client")
{
BugHandlerSoftware abc = new BugHandlerSoftware(session);
this.Hide();
abc.Show();
}
else
{
BugHandlerProgrammer bhp = new BugHandlerProgrammer(session);
this.Hide();
bhp.Show();
}
}
//to display error in wrong password
else
{
MessageBox.Show("Incorrect Username or Password!");
}
}
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);
}
}