private void btnDelete_Click(object sender, RoutedEventArgs e)
{
try
{
if (ID != 0)
{
if (MessageBox.Show("Do you want to Delete this '" + txtCity.Text + "'", "DELETE", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
MASTERCITY c = db.MASTERCITies.Where(x => x.CITY_CODE == ID).FirstOrDefault();
var OldData = new JSonHelper().ConvertObjectToJSon(c);
db.MASTERCITies.Remove(c);
db.SaveChanges();
AppLib.EventHistory(this.Tag.ToString(), 2, OldData, "", "MASTERCITY");
MessageBox.Show("Deleted Successfully", "DELETED", MessageBoxButton.OK, MessageBoxImage.Information);
FormClear();
}
}
else
{
MessageBox.Show("Please Select Any City! (Double Click to Select)");
}
}
catch (Exception ex)
{
Nube.ExceptionLogging.SendErrorToText(ex);
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
try
{
if (txtCity.Text == "")
{
MessageBox.Show("Enter City...", "Information", MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
else if (cmbState.Text == "")
{
MessageBox.Show("Enter State...", "Information", MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
else
{
if (MessageBox.Show("Do you wanrt to save this record?", "SAVE CONFIRMATION", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
if (ID != 0)
{
MASTERCITY c = db.MASTERCITies.Where(x => x.CITY_CODE == ID).FirstOrDefault();
var OldData = new JSonHelper().ConvertObjectToJSon(c);
c.CITY_NAME = txtCity.Text;
c.STATE_CODE = Convert.ToDecimal(cmbState.SelectedValue);
db.SaveChanges();
AppLib.lstMASTERCITY = db.MASTERCITies.OrderBy(x => x.CITY_NAME).ToList();
var NewData = new JSonHelper().ConvertObjectToJSon(c);
AppLib.EventHistory(this.Tag.ToString(), 1, OldData, NewData, "MASTERCITY");
MessageBox.Show("Saved Successfully!", "Saved", MessageBoxButton.OK, MessageBoxImage.Information);
FormClear();
}
else
{
MASTERCITY c = new MASTERCITY();
c.CITY_NAME = txtCity.Text;
c.STATE_CODE = Convert.ToDecimal(cmbState.SelectedValue);
db.MASTERCITies.Add(c);
db.SaveChanges();
AppLib.lstMASTERCITY = db.MASTERCITies.OrderBy(x => x.CITY_NAME).ToList();
var NewData = new JSonHelper().ConvertObjectToJSon(c);
AppLib.EventHistory(this.Tag.ToString(), 0, "", NewData, "MASTERCITY");
MessageBox.Show("Saved Successfully!", "Saved", MessageBoxButton.OK, MessageBoxImage.Information);
FormClear();
}
}
}
}
catch (Exception ex)
{
Nube.ExceptionLogging.SendErrorToText(ex);
}
}
