private void btnSave_Click(object sender, EventArgs e)
{
if (txtName.Text != "")
{
//usp_SEL_TSF_tblFamilyMemberTableAdapter.Fill(comDataSet.usp_SEL_TSF_tblFamilyMember, txtFCardNo.Text, txtName.Text);
//MemberID = Convert.ToInt32(comDataSet.usp_SEL_TSF_tblFamilyMember.Rows[0].ItemArray[0].ToString());
MemberID = Convert.ToInt32(usp_SEL_TSF_tblFamilyMemberTableAdapter.ScalarQuery(txtFCardNo.Text, txtName.Text));
}
bool CHK = DBLayer.CHK_RegNo_Death(txtRegNo.Text);
try
{
string RegNo = txtRegNo.Text;
string Name = txtName.Text;
string FName = txtFName.Text;
string GFName = txtGFName.Text;
string FCardNo = txtFCardNo.Text;
string Orakh = txtOrakh.Text;
string Nukh = txtNukh.Text;
string Gender = cmbGender.Text;
string AgeGroup = cmbAgeGroup.Text;
string Relation = cmbRelation.Text;
DateTime DOD = Convert.ToDateTime(dtpDOD.Text);
DateTime EntryDate = Convert.ToDateTime(dtpEntryDate.Text);
string Reason = txtReasonOfDeath.Text;
string Address = txtAddress.Text;
string Age = txtAge.Text;
string Place = cmbPlace.Text;
string AppName = txtApplicantName.Text;
string AppCNIC = txtApplicantCNIC.Text;
string AppRelation = cmbApplicantRelation.Text;
DateTime DTime = Convert.ToDateTime(dtpDtime.Text);
string DRCNumber = txtDRCN.Text;
bool isPrinted = chkIsPrinted.Checked;
if (CheckField())
{
if (mode == 1)
{
if (CHK)
{
MessageBox.Show("Registration Number Already Exists!!!", "Duplicate", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
usp_SEL_DeathTableAdapter.InsertDeath(RegNo, FCardNo, Name, FName, GFName, Nukh, Orakh, Gender, DOD, Relation, AgeGroup, Reason, Address, EntryDate, Age, Place, DTime, MemberID, AppName, AppCNIC, AppRelation, DRCNumber, false);
Gayab(true);
mode = 0;
usp_SEL_tblFamilyMemberTableAdapter.Update_Death(FCardNo, false, "Death", DOD, MemberID);
MessageBox.Show("Succesfully Saved", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
usp_SEL_DeathTableAdapter.Fill(this.comDataSet.usp_SEL_Death);
}
}
else if (mode == 0)
{
usp_SEL_DeathTableAdapter.UpdateDeath(id, RegNo, FCardNo, Name, FName, GFName, Nukh, Orakh, Gender, DOD, Relation, AgeGroup, Reason, Address, EntryDate, Age, Place, DTime, MemberID, AppName, AppCNIC, AppRelation, DRCNumber, isPrinted);
Gayab(true);
mode = 0;
btnReset.Show();
usp_SEL_DeathTableAdapter.Fill(this.comDataSet.usp_SEL_Death);
usp_SEL_tblFamilyMemberTableAdapter.Update_Death(FCardNo, false, "Death", EntryDate, MemberID);
MessageBox.Show("Succesfully Saved", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
AcceptButton = btnNew;
txtFilter.Focus();
lbl.Text = Header;
}
catch (FormatException)
{
MessageBox.Show("Please insert valid values in respective fields!!!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}