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); } } }