void FillAvgPrice_Age() { //Calculate average price of the vehicles in the database double temp = ManageDB.CalcAvgPriceOfVehicles(); if (0 == temp) { AvgPriceLbl.Content = ""; } else { AvgPriceLbl.Content = temp.ToString("F") + "лв."; } //Calculate average age of the vehicles in the database temp = ManageDB.CalcAvgAgeOfVehicles(); if (0 == temp) { AvgAgeLbl.Content = ""; } else { AvgAgeLbl.Content = temp.ToString("F") + "г."; } }
void CheckClientInsurancesPreview() { int count = -1; //Check data validity in Egn text control if (null == EgnTxt.Text) { //Egn text control is empty MessageBox.Show("Невалидно ЕГН!"); } else if (10 != EgnTxt.Text.Length) { //Egn text control contains invalid input MessageBox.Show("Невалидно ЕГН!"); } else { //Get the number of insurances for current client count = ManageDB.GetInsuranceCountByEgn(EgnTxt.Text); //Check the number of insurances found if (count == -1) { //No insurances found - no need to open preview //Display error msg MessageBox.Show("Няма застраховки на този клиент!"); } else { //Open preview of client insurances CheckClientInsurancesPreview preview = new CheckClientInsurancesPreview(count, EgnTxt.Text); preview.Show(); } } }
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("Въведени са некоректни данни!"); } }
void CheckInsurancesByVinPreview() { //Check Vin text control for invalid data if (VinTxt.Text.Length != 0) { List <Insurance> tempInsurances = new List <Insurance>(); //Check if vehicle is in the database if (false != ManageDB.CheckForValidInsurancesByVIN(VinTxt.Text, ref tempInsurances)) { //Check if there are insurances for the current vehicle if (null != tempInsurances) { //Open preview of the insurances CheckInsurancesByVinPreview preview = new CheckInsurancesByVinPreview(VinTxt.Text, tempInsurances); preview.Show(); } else { //No insurances found - no need to open preview //Show error msg MessageBox.Show("Няма валидни застраховки за това МПС!"); } } else { //Vehicle is not in database //Show error msg MessageBox.Show("Несъществуващ VIN!"); } } else { //Input in Vin text control is invalid //Show error msg MessageBox.Show("Некоректен VIN!"); } }
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("Няма намерени застраховки за този клиент!"); } }