private void IssueLiabBtn_Click(object sender, RoutedEventArgs e) { //Check input first if (false != CheckLiabData()) { Customer tempCust = new Customer(); Vehicle tempVeh = new Vehicle(); //Check for existing owner in DB if (false == ManageDB.CheckForOwnerInDB(EgnTxt.Text, ref tempCust)) { tempCust = new Customer(OwnerNameTxt.Text, EgnTxt.Text); ManageDB.AddCustInDB(tempCust); } //Check for existing car in DB if (false == ManageDB.CheckForVehInDB(VinTxt.Text, ref tempVeh)) { tempVeh = new Vehicle(MakeTxt.Text, ModelTxt.Text, int.Parse(YearTxt.Text), int.Parse(MonthTxt.Text), " ", (VehicleType)VehTypeCmb.SelectedIndex, (CoupeType)7, int.Parse(PowerTxt.Text), " ", VinTxt.Text, tempCust.CustomerId); ManageDB.AddVehInDB(tempVeh); } //Calculate Liability Insurance price double price = Calculations.CalcLiabPrice((VehicleType)VehTypeCmb.SelectedIndex, int.Parse(ExpTxt.Text), int.Parse(PowerTxt.Text), int.Parse(EngCapTxt.Text), FuelTypeCmb.SelectedIndex, int.Parse(YearTxt.Text)); DateTime issueDate = DateTime.Now; DateTime dueDate = DateTime.Now.AddYears(1); //Get the id of the new policy int insuranceNumb = ManageDB.GetInsuranceCount() + 1; Insurance tempIns = new Insurance(insuranceNumb, tempCust.CustomerId, tempVeh.VehicleId, price, issueDate, dueDate, (InsuranceType)1, 0); //Save insurance in DB ManageDB.AddInsuranceInDB(tempIns); //Preview insurance IssueLiabPreview previewWin = new IssueLiabPreview(tempIns, tempVeh, tempCust); previewWin.Show(); ClearAllControls(); } else { //Invalid input -> show error msg MessageBox.Show("Въведени са некоректни данни!"); } }
public void FillData(int count, string Egn) { //count and Egn are not checked for validity, since they are checked in RefPage.xaml.cs Customer temp = new Customer(); List <Insurance> listOfInsurances = new List <Insurance>(); //Check for the owner in the Database if (ManageDB.CheckForOwnerInDB(Egn, ref temp)) { ClientNameLbl.Content = temp.Name; //Get list of the insurances for the current client by EGN from Database ManageDB.GetClientInsurances(Egn, ref listOfInsurances); DataGrid.ItemsSource = listOfInsurances; //Display only needed columns from Database var col = new DataGridTextColumn(); col.Header = "Застраховка №"; col.Binding = new Binding("Id"); DataGrid.Columns.Add(col); col = new DataGridTextColumn(); col.Header = "МПС №"; col.Binding = new Binding("VehicleID"); DataGrid.Columns.Add(col); col = new DataGridTextColumn(); col.Header = "Премия(лв.)"; col.Binding = new Binding("PolicyPrice"); DataGrid.Columns.Add(col); col = new DataGridTextColumn(); col.Header = "Валидна от"; col.Binding = new Binding("IssueDate"); DataGrid.Columns.Add(col); col = new DataGridTextColumn(); col.Header = "Валидна до"; col.Binding = new Binding("DueDate"); DataGrid.Columns.Add(col); col = new DataGridTextColumn(); col.Header = "Тип застраховка"; col.Binding = new Binding("TypeOfInsurance"); DataGrid.Columns.Add(col); col = new DataGridTextColumn(); col.Header = "Застрахователна сума в лв. (Каско)"; col.Binding = new Binding("InsuranceMoney"); DataGrid.Columns.Add(col); //Set the data grid to read only to prevent change of the data from Database DataGrid.IsReadOnly = true; } else { ClientNameLbl.Content = ""; DataGrid.Visibility = Visibility.Hidden; PrintBtn.IsEnabled = false; MessageBox.Show("Няма намерени застраховки за този клиент!"); } }