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 button2_Click(object sender, EventArgs e)
{
try
{
Criminal_Info ci = db.Criminal_Infos.Single(Criminal_Info => Criminal_Info.Finger_Print == path1);
if (ci != null)
{
MessageBox.Show("Fingerprint Macthed");
this.Hide();
Matched_Criminal_History_Form fp = new Matched_Criminal_History_Form(ci.Criminal_ID);
fp.ShowDialog();
}
else
{
MessageBox.Show("Fingerprint doesn't Match");
this.Hide();
Add_New_Criminal_Information al = new Add_New_Criminal_Information();
al.ShowDialog();
}
}
catch (Exception ex)
{
// MessageBox.Show(ex.Message);
MessageBox.Show("Fingerprint doesn't Match");
this.Hide();
Add_New_Criminal_Information al = new Add_New_Criminal_Information();
al.ShowDialog();
}
}
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);
}
}
public Matched_Criminal_History_Form(int s)
{
InitializeComponent();
this.s = s;
using (data)
{
Criminal_Info ci = data.Criminal_Infos.Single(Criminal_Info => Criminal_Info.Criminal_ID == s);
if (ci != null)
{
textBox7.Text = ci.Criminal_ID.ToString();
textBox1.Text = ci.Name;
textBox8.Text = ci.Gender;
textBox3.Text = ci.DOB;
DateTime current = DateTime.Now;
int age = current.Year - int.Parse(ci.DOB);
textBox4.Text = age.ToString();
textBox2.Text = ci.Blood_Group;
textBox5.Text = ci.Birth_Place;
textBox6.Text = ci.NID_No_.ToString();
pictureBox1.Image = Image.FromFile(ci.Photo);
}
}
}
partial void DeleteCriminal_Info(Criminal_Info instance);
partial void UpdateCriminal_Info(Criminal_Info instance);
partial void InsertCriminal_Info(Criminal_Info instance);