private async void saveButton_Click(object sender, RoutedEventArgs e)
{
val = new Validation();
if (val.isEmpty(customerName) || val.isEmpty(vehicelNo) || val.isEmpty(sellingCenter) || val.isEmpty(destination) || val.isEmpty(date.ToString()) ||
val.isEmpty(driverName) || val.isEmpty(distance.ToString()) || val.isEmpty(arrivalTime.ToString()))
{
await this.ShowMessageAsync("Error", "Data Cannot be Empty", MessageDialogStyle.Affirmative);
}
else
{
int affectedLines = 0;
transport.CustomerName = CustomerName.SelectedItem.ToString();
transport.VehicleNo = VehicleNo.SelectedItem.ToString();
transport.DriverName = DriverName.SelectedItem.ToString();
transport.Date = RequestDate.SelectedDate.Value;
transport.ArrivalTime = Convert.ToInt32(ArrivalTime.Text);
transport.Destination = Desination.Text;
transport.Distance = Convert.ToInt32(Distance.Text);
transport.Income = Convert.ToInt32(Income.Text);
transport.SellingCenter = SellingCenter.SelectedValue.ToString();
try
{
handleDatabase = new HandleDatabase();
affectedLines = handleDatabase.executeTransportaionRequest(transport);
if (affectedLines > 0)
{
await this.ShowMessageAsync("Successfull", "New Entry have been Successfully Registered", MessageDialogStyle.Affirmative);
this.Close();
MainMenu menu = new MainMenu();
menu.Show();
}
else
{
await this.ShowMessageAsync("Error", "Sorry Can not Proceed with transportation", MessageDialogStyle.Affirmative);
this.Close();
MainMenu menu = new MainMenu();
menu.Show();
}
}
catch (SqlException sqlException)
{
Console.WriteLine(sqlException);
}
}
}