private void Update_Click(object sender, EventArgs e)
{
string nid = textboxsearchNID.Text;
Criminal obp = DB.Criminals.SingleOrDefault(x => x.NID == nid);
// Criminal obp = DB.Criminals.SingleOrDefault(st => st.NID == textboxsearchNID);
if (obp != null)
{
obp.DOB = textboxDOB.Text;
obp.date = textboxregDate.Text;
obp.regno = textboxregno.Text;
obp.NID = textBoxNID.Text;
obp.name = textBoxName.Text;
obp.gender = textBoxGender.Text;
obp.age = textBoxAge.Text;
obp.phone = textBoxPhone.Text;
obp.address = textBoxAddress.Text;
obp.Crime = textboxCrime.Text;
obp.bloodgroup = textBoxBlood.Text;
DB.SubmitChanges();
MessageBox.Show("Criminal Updated");
}
else
{
MessageBox.Show("Error");
}
}
private void button4_Click(object sender, EventArgs e)
{
string nid = textboxsearchNID.Text;
Criminal obp = DB.Criminals.SingleOrDefault(x => x.NID == nid);
//Criminal obp = DB.Criminals.SingleOrDefault(st => st.NID == textboxsearchNID);
if (obp != null)
{
textboxregno.Text = obp.regno;
textBoxNID.Text = obp.NID;
textboxregDate.Text = obp.date;
textboxDOB.Text = obp.DOB;
textBoxName.Text = obp.name;
textBoxGender.Text = obp.gender;
textBoxAge.Text = obp.age;
textBoxPhone.Text = obp.phone;
textBoxAddress.Text = obp.address;
textboxCrime.Text = obp.Crime;
textBoxBlood.Text = obp.bloodgroup;
}
else
{
MessageBox.Show("Invalid Search");
}
}
private void button1_Click(object sender, EventArgs e)
{
Criminal obp = new Criminal();
obp.DOB = textboxDOB.Text;
obp.date = textboxregDate.Text;
obp.regno = textboxregno.Text;
obp.NID = textBoxNID.Text;
obp.name = textBoxName.Text;
obp.gender = textBoxGender.Text;
obp.age = textBoxAge.Text;
obp.phone = textBoxPhone.Text;
obp.address = textBoxAddress.Text;
obp.Crime = textboxCrime.Text;
obp.bloodgroup = textBoxBlood.Text;
DB.Criminals.InsertOnSubmit(obp);
try
{
DB.SubmitChanges();
MessageBox.Show("Inserted.");
}
catch (Exception)
{
MessageBox.Show("Error");
}
}
private void button5_Click(object sender, EventArgs e)
{
string nid = textboxsearchNID.Text;
Criminal ob = DB.Criminals.SingleOrDefault(x => x.NID == nid);
// Criminal ob = DB.Criminals.SingleOrDefault(st => st.NID ==textboxsearchNID);
if (ob != null)
{
DB.Criminals.DeleteOnSubmit(ob);
DB.SubmitChanges();
MessageBox.Show("Criminal Deleted");
}
else
{
MessageBox.Show("Error");
}
}
partial void DeleteCriminal(Criminal instance);
partial void UpdateCriminal(Criminal instance);
partial void InsertCriminal(Criminal instance);
