private void BtnSave_Click(object sender, EventArgs e)
 {
     try
     {
         using (DBAuditDataContext dc = new DBAuditDataContext())
         {
             //var c = dc.ProAddLocation(TxtName.Text, TxtNotes.Text);
             dc.ProAddLocation(TxtName.Text, int.Parse(ComboSectors.SelectedValue.ToString()), TxtNotes.Text);
             MessageBox.Show(Resources.MsgLocationAdded, Resources.AppName, MessageBoxButtons.OK, MessageBoxIcon.Information);
             Close();
             new FrmNewLocation().Show();
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }