private void BtnCarDetails_Click(object sender, RoutedEventArgs e) { FinalPage finalPage = new FinalPage(); finalPage.Show(); this.Close(); }
//Logic for clearing the fields private void btnClear_Click(object sender, RoutedEventArgs e) { clear(); FinalPage finPage = new FinalPage(); this.Close(); finPage.ShowDialog(); try { this.Show(); } catch { } }
/*Logic for loggimg into * Admin Section*/ private void Btnlogin_Click(object sender, RoutedEventArgs e) { string configManager = ConfigurationManager.ConnectionStrings["databaseConnString"].ConnectionString; using (SqlConnection sqlCon = new SqlConnection(configManager)) { String query = "select count(1) from Admin where UserName=@UserName AND Password=@Password"; SqlCommand sqlCmd = new SqlCommand(query, sqlCon); StringBuilder sb = new StringBuilder(); sqlCmd.Parameters.AddWithValue("@UserName", txtName.Text); sqlCmd.Parameters.AddWithValue("@Password", pwdPassword.Password); try { sqlCon.Open(); sqlCmd.CommandType = CommandType.Text; int count = Convert.ToInt32(sqlCmd.ExecuteScalar()); if (count == 1) { FinalPage finalPage = new FinalPage(); finalPage.Show(); this.Close(); } else { MessageBox.Show("Username or Password incorrect."); } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { sqlCon.Close(); } } }
/*Logic for adding new information * to the CAR table*/ private void BtnAdd_Click(object sender, RoutedEventArgs e) { try { StringBuilder sb = new StringBuilder(); int invalid = 0; using (cims) { CAR car = new CAR(); if (!(Regex.IsMatch(txtmodel.Text, @"^\w+\s*\w*$"))) { invalid = 1; sb.Append(Environment.NewLine + "Model cannot be blank and must be in proper format."); } else { car.Model = txtmodel.Text; } if (cmbManufacturer.SelectedValue != null) { car.ManufacturerId = Convert.ToInt32(cmbManufacturer.SelectedValue.ToString()); } else { invalid = 1; sb.Append(Environment.NewLine + "Please Select Manufacturer."); } if (cmbType.SelectedValue != null) { car.TypeId = Convert.ToInt32(cmbType.SelectedValue.ToString()); } else { invalid = 1; sb.Append(Environment.NewLine + "Please Select Car Type."); } if (!(Regex.IsMatch(txtEngine.Text, @"^[0-9].[0-9]L$"))) { invalid = 1; sb.Append(Environment.NewLine + "Engine should be in proper format(e.g. 3.5L)."); } else { car.Engine = txtEngine.Text; } if (!(Regex.IsMatch(txtBHP.Text, @"^\d+$"))) { invalid = 1; sb.Append(Environment.NewLine + "BHP cannot be blank and must be numeric."); } else { car.BHP = Convert.ToInt32(txtBHP.Text); } if (cmbTransmission.SelectedValue != null) { car.TransmissionId = Convert.ToInt32(cmbTransmission.SelectedValue.ToString()); } else { invalid = 1; sb.Append(Environment.NewLine + "Please Select Car Transmission."); } if (!(Regex.IsMatch(txtMileage.Text, @"^\d+$"))) { invalid = 1; sb.Append(Environment.NewLine + "Mileage cannot be blank and must be numeric."); } else { car.Mileage = Convert.ToInt32(txtMileage.Text); } if (!(Regex.IsMatch(txtSeat.Text, @"^\d+$"))) { invalid = 1; sb.Append(Environment.NewLine + "Seat cannot be blank and must be numeric."); } else { car.Seat = Convert.ToInt32(txtSeat.Text); } if (!(Regex.IsMatch(txtAirbagDetails.Text, @"^\w+$"))) { invalid = 1; sb.Append(Environment.NewLine + "Airbag details cannot be blank."); } else { car.AirBagDetails = txtAirbagDetails.Text; } if (!(Regex.IsMatch(txtBootspace.Text, @"^\d+\s*\w*$"))) { invalid = 1; sb.Append(Environment.NewLine + "Bootspace cannot be blank."); } else { car.BootSpace = txtBootspace.Text; } if (!(Regex.IsMatch(txtPrice.Text, @"^\d+$"))) { invalid = 1; sb.Append(Environment.NewLine + "Price cannot be blank and must be numeric."); } else { car.Price = Convert.ToInt64(txtPrice.Text); } if (invalid == 1) { MessageBox.Show(sb.ToString()); } else { cims.CARs.Add(car); cims.SaveChanges(); MessageBox.Show("1 Record Added"); } } FinalPage finPage = new FinalPage(); this.Close(); finPage.ShowDialog(); try { this.Show(); } catch { } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }