private void btnDeleterecord_Click(object sender, EventArgs e)
{
int rowNum = examineeDataGridView.CurrentCell.RowIndex;
string examinID = examineeDataGridView[0, rowNum].Value.ToString();
DialogResult answer = MessageBox.Show("Are you sure you want to delete " + examinID + "?", "Confirm", MessageBoxButtons.OKCancel);
if (answer == DialogResult.OK)
{
using (ExamineeDataContext dbContext = new ExamineeDataContext())
{
try
{
Examinee currentExaminee = (from exe in dbContext.Examinees
where exe.ExamineeID == Convert.ToInt32(examinID)
select exe).SingleOrDefault();
dbContext.Examinees.DeleteOnSubmit(currentExaminee);
dbContext.SubmitChanges();
RefreshGridView();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
}
private void btnModify_Click(object sender, EventArgs e)
{
int rowNum = examineeDataGridView.CurrentCell.RowIndex;
string examinID = examineeDataGridView[0, rowNum].Value.ToString();
Examinee currentExaminee;
using (ExamineeDataContext dbContext = new ExamineeDataContext())
{
currentExaminee = (from exe in dbContext.Examinees
where Convert.ToString(exe.ExamineeID) == examinID
select exe).SingleOrDefault();
}
frmAddModifyexaminee secondForm = new frmAddModifyexaminee();
secondForm.isAdd = false;
secondForm.currentExaminee = currentExaminee;
DialogResult result = secondForm.ShowDialog();
if (result == DialogResult.OK || result == DialogResult.Retry)
{
RefreshGridView();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (isAdd)
{
if (Validator.IsPresent(examineeIDTextBox) &&
Validator.IsPresent(examineeFirstnameTextBox) &&
Validator.IsPresent(examineeLastnameTextBox) &&
Validator.IsPresent(examineeEmailTextBox))
{
Examinee newExaminee = new Examinee // create product using provided data
{
ExamineeID = Convert.ToInt32(examineeIDTextBox.Text),
ExamineeFirstname = examineeFirstnameTextBox.Text,
ExamineeLastname = examineeLastnameTextBox.Text,
ExamineeEmail = examineeEmailTextBox.Text
};
using (ExamineeDataContext dbContext = new ExamineeDataContext())
{
dbContext.Examinees.InsertOnSubmit(newExaminee);
dbContext.SubmitChanges();
}
DialogResult = DialogResult.OK;
}
else // validation failed
{
DialogResult = DialogResult.Cancel;
}
}
else // it is Modify
{
if (Validator.IsPresent(examineeIDTextBox) &&
Validator.IsPresent(examineeFirstnameTextBox) &&
Validator.IsPresent(examineeLastnameTextBox) &&
Validator.IsPresent(examineeEmailTextBox))
{
try
{
int examinID = Convert.ToInt32(examineeIDTextBox.Text);
// ExamineeDataContext db2 = new ExamineeDataContext();
Examinee examin2 = new Examinee();
examin2 = db2.Examinees.Single(x => x.ExamineeID == examinID);
examin2.ExamineeFirstname = examineeFirstnameTextBox.Text;
examin2.ExamineeLastname = examineeLastnameTextBox.Text;
examin2.ExamineeID = Convert.ToInt32(examineeIDTextBox.Text);
examin2.ExamineeEmail = examineeEmailTextBox.Text;
db2.SubmitChanges();
}
catch (DBConcurrencyException)
{
MessageBox.Show("Other user changed or deleted data. Try Again", "Concurrency Error");
}
//Handling for general exception
catch (Exception ex)
{
MessageBox.Show("Other error while saving changes: " + ex.Message,
ex.GetType().ToString());
}
}
else // validation failed
{
DialogResult = DialogResult.Cancel;
}
}
}