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 button3_Click(object sender, EventArgs e)
{
string nid = textboxsearchNID.Text;
LoginSt ob = DB.LoginSts.SingleOrDefault(x => x.NID == nid);
// Criminal ob = DB.Criminals.SingleOrDefault(st => st.NID ==textboxsearchNID);
if (ob != null)
{
DB.LoginSts.DeleteOnSubmit(ob);
DB.SubmitChanges();
MessageBox.Show("Staff Deleted");
}
else
{
MessageBox.Show("Error");
}
}
private void button1_Click(object sender, EventArgs e)
{
DDBDataContext DB = new DDBDataContext();
LoginSt obp = new LoginSt();
obp.username = textBoxusername.Text;
obp.password = textBoxpassword.Text;
obp.NID = textboxNID.Text;
DB.LoginSts.InsertOnSubmit(obp);
try
{
DB.SubmitChanges();
MessageBox.Show("Inserted.");
}
catch (Exception)
{
MessageBox.Show("Error");
}
}