private void DeletePersonal_Click(object sender, EventArgs e)
{
try
{
string query = "";
if (StaffIDtextBox.Text.Trim() == "")
{
MessageBox.Show("Please Enter Staff ID");
StaffIDtextBox.Focus();
return;
}
query = "DELETE FROM Personal_Info WHERE StaffID = " + stfID;
if (DbAccess.ExecuteToDB(query))
{
if (stfID != 0)
{
MessageBox.Show("Delete Successfully!!!");
}
else
{
MessageBox.Show("Failed To Delete!!!");
}
}
}
catch (Exception ex)
{
MessageBox.Show("Connection Error!!!");
}
finally
{
Reset();
}
}
private void SavePersonal_Click(object sender, EventArgs e)
{
string query = ""; int DistrictKey = ((KeyValuePair <int, string>)District.SelectedItem).Key;
string que = ""; int ThanaKey = ((KeyValuePair <int, string>)Thana.SelectedItem).Key;
string qu = ""; int MarriedKey = ((KeyValuePair <int, string>)MarriedCombox.SelectedItem).Key;
String DistrictValue = ((KeyValuePair <int, string>)District.SelectedItem).Value;
String ThanaValue = ((KeyValuePair <int, string>)Thana.SelectedItem).Value;
String MarriedValue = ((KeyValuePair <int, string>)MarriedCombox.SelectedItem).Value;
if (StaffIDtextBox.Text.Trim() == "")
{
MessageBox.Show("Please Enter Staff ID");
StaffIDtextBox.Focus();
return;
}
if (ContacttextBox.Text.Trim() == "")
{
MessageBox.Show("Please Enter Contact Number");
ContacttextBox.Focus();
return;
}
if (DOB.Text == "")
{
MessageBox.Show("Please Enter Date of Birth");
DOB.Focus();
return;
}
if (DistrictKey < 1)
{
MessageBox.Show("Please Enter District");
District.Focus();
return;
}
if (ThanaKey < 1)
{
MessageBox.Show("Please Enter Thana");
District.Focus();
return;
}
if (PostCodetextBox.Text.Trim() == "")
{
MessageBox.Show("Please Enter Post Code");
PostCodetextBox.Focus();
return;
}
if (VillagetextBox.Text.Trim() == "")
{
MessageBox.Show("Please Enter Village Name");
VillagetextBox.Focus();
return;
}
if (PresentAddresstextBox.Text.Trim() == "")
{
MessageBox.Show("Please Enter Present Address");
PresentAddresstextBox.Focus();
return;
}
if (PermanentadresstextBox.Text.Trim() == "")
{
MessageBox.Show("Please Enter Permanent Address");
PermanentadresstextBox.Focus();
return;
}
if (MarriedKey < 1)
{
MessageBox.Show("Please Enter Marital Status");
District.Focus();
return;
}
if (FathersNametextBox.Text.Trim() == "")
{
MessageBox.Show("Please Enter Father's name");
FathersNametextBox.Focus();
return;
}
if (MothersNametextBox.Text.Trim() == "")
{
MessageBox.Show("Please Enter Mother's Name");
MothersNametextBox.Focus();
return;
}
if (ParentsAddresstextBox.Text.Trim() == "")
{
MessageBox.Show("Please Enter Present Address");
ParentsAddresstextBox.Focus();
return;
}
query = "SELECT COUNT(*) AS Count FROM Personal_Info WHERE StaffID = " + StaffIDtextBox.Text + "";
if (stfID == 0)
{
if (DbAccess.NumberOfRecords(query) > 0)
{
MessageBox.Show("This Username already exists! Please try another ID!");
StaffIDtextBox.Focus();
return;
}
}
else
{
if (DbAccess.NumberOfRecords(query) > 1)
{
MessageBox.Show("Update Not Successfully Done!");
StaffIDtextBox.Focus();
return;
}
}
try
{
if (stfID == 0)
{
query = "INSERT INTO Personal_Info(StaffID,Contact,[Date of Birth],District,Thana,[Post Code],Village,[Present Address],[Permanent Address],[Marital Status],[Father's Name],[Mother's Name],[Parent's Address]) VALUES(" + Convert.ToInt32(StaffIDtextBox.Text) + ", '" + ContacttextBox.Text + "', '" + DOB.Value.ToString("yyyy/MM/dd") + "', '" + DistrictValue + "', '" + ThanaValue + "', '" + PostCodetextBox.Text + "', '" + VillagetextBox.Text + "', '" + PresentAddresstextBox.Text + "', '" + PermanentadresstextBox.Text + "', '" + MarriedValue + "', '" + FathersNametextBox.Text + "', '" + MothersNametextBox.Text + "', '" + ParentsAddresstextBox.Text + "')";
}
else
{
query = "UPDATE Personal_Info SET Contact = '" + ContacttextBox.Text + "', [Date of Birth] = '" + DOB.Text + "', District= '" + District.Text + "', Thana = '" + Thana.Text + "', [Post Code] = '" + PostCodetextBox.Text + "', Village = '" + VillagetextBox.Text + "',[Present Address] = '" + PresentAddresstextBox.Text + "', [Permanent Address] = '" + PermanentadresstextBox.Text + "', [Marital Status] = '" + MarriedValue + "',[Father's Name] = '" + FathersNametextBox.Text + "', [Mother's Name]= '" + MothersNametextBox.Text + "',[Parent's Address] = '" + ParentsAddresstextBox.Text + "' WHERE StaffID = " + stfID;
}
if (DbAccess.ExecuteToDB(query))
{
if (stfID == 0)
{
MessageBox.Show("Saved Successfully!!!");
}
else
{
MessageBox.Show("Update Successfully!!!");
}
}
else
{
MessageBox.Show("Failed To Save!!!");
}
}
catch (Exception ex)
{
MessageBox.Show("Connection Error!!!");
}
finally
{
Reset();
}
}
