private void button3_Click(object sender, EventArgs e) { //dataGridView1.Refresh(); ProjectLINQDataContext pl2 = new ProjectLINQDataContext(); Criminal_Info cif = pl2.Criminal_Infos.SingleOrDefault(Criminal_Info => Criminal_Info.Criminal_ID == int.Parse(textBox2.Text)); try { if (pl2 != null) { pl2.Criminal_Infos.DeleteOnSubmit(cif); pl2.SubmitChanges(); MessageBox.Show("Deleted Successfully"); dataGridView1.DataSource = pl2.Criminal_Infos; dataGridView1.Refresh(); textBox2.Text = null; textBox3.Text = null; textBox4.Text = null; comboBox1.Text = null; textBox6.Text = null; textBox7.Text = null; } else { MessageBox.Show("Data not found"); } } catch (Exception ee) { MessageBox.Show(ee.Message); } }
private void button1_Click(object sender, EventArgs e) { AdminLogin al = pl.AdminLogins.Single(AdminLogin => AdminLogin.Userid == 1); try { if (textBox3.Text == textBox4.Text && textBox3.Text != "" && textBox4.Text != "") { al.Password = textBox4.Text; al.Email = textBox2.Text; al.UserName = textBox1.Text; pl.SubmitChanges(); MessageBox.Show("Profile Successfully Updated !"); this.Hide(); Add_New_Criminal_Information a = new Add_New_Criminal_Information(); a.ShowDialog(); } else { MessageBox.Show("Password Doesn't Match !"); } } catch (Exception ee) { MessageBox.Show(ee.Message); } }
private void button1_Click(object sender, EventArgs e) { try { Criminal_Info cf = new Criminal_Info(); cf.Finger_Print = str1; cf.Photo = str; cf.Name = textBox1.Text; cf.NID_No_ = int.Parse(textBox3.Text); cf.Gender = g; cf.DOB = textBox6.Text; cf.Birth_Place = textBox2.Text; cf.Blood_Group = comboBox3.Text; DateTime current = DateTime.Now; int age = current.Year - int.Parse(textBox6.Text); cf.Age = age; db.Criminal_Infos.InsertOnSubmit(cf); db.SubmitChanges(); MessageBox.Show("Information Inserted"); } catch (Exception ee) { MessageBox.Show(ee.Message); } }
private void button2_Click(object sender, EventArgs e) { ProjectLINQDataContext pl = new ProjectLINQDataContext(); DataGridViewRow newrow = dataGridView1.Rows[indexRow]; Criminal_Info ci = pl.Criminal_Infos.Single(Criminal_Info => Criminal_Info.Criminal_ID == int.Parse(textBox2.Text)); try { if (ci != null) { ci.Name = textBox3.Text; ci.DOB = textBox4.Text; ci.Blood_Group = comboBox1.Text; ci.Birth_Place = textBox7.Text; ci.NID_No_ = int.Parse(textBox6.Text); pl.SubmitChanges(); newrow.Cells[1].Value = textBox3.Text; newrow.Cells[1].Value = textBox3.Text; newrow.Cells[3].Value = textBox4.Text; newrow.Cells[4].Value = comboBox1.Text; newrow.Cells[5].Value = textBox7.Text; newrow.Cells[6].Value = textBox6.Text; MessageBox.Show("Profile Successfully Updated !"); textBox2.Text = null; textBox3.Text = null; textBox4.Text = null; comboBox1.Text = null; textBox6.Text = null; textBox7.Text = null; } else { MessageBox.Show("Data Not found"); } } catch (Exception ee) { MessageBox.Show(ee.Message); } }
private void button1_Click(object sender, EventArgs e) { try { CrimeInfo ci = new CrimeInfo(); ci.Criminal_ID = int.Parse(textBox1.Text); ci.Crime = comboBox1.Text; ci.Year = int.Parse(textBox3.Text); ci.Area = textBox4.Text; ci.Age = int.Parse(textBox2.Text); db.CrimeInfos.InsertOnSubmit(ci); db.SubmitChanges(); MessageBox.Show("Information Inserted !!"); this.Hide(); Matched_Criminal_History_Form f = new Matched_Criminal_History_Form(int.Parse(textBox1.Text)); f.ShowDialog(); } catch (Exception ee) { MessageBox.Show(ee.Message); } }
private void button1_Click(object sender, EventArgs e) { try { AdminLogin al = pl.AdminLogins.Single(AdminLogin => AdminLogin.Email == email); if (textBox1.Text == textBox2.Text && textBox1.Text != "" && textBox2.Text != "") { al.Password = textBox1.Text; pl.SubmitChanges(); MessageBox.Show("Password Successfully Changed !"); this.Hide(); adminLogin a = new adminLogin(); a.ShowDialog(); } else { MessageBox.Show("Password Doesn't Match !!"); } } catch (Exception ex) { } }