public List <VehicleInformationClass> GetVendorInformation() { VehicleInformationClass vehicleObj = null; List <VehicleInformationClass> vehicleses = new List <VehicleInformationClass>(); string connectionString = @"server=DUET-559FE4FA51\SQLEXPRESS;integrated security = SSPI; database = VehicleInformationDB;"; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); string queryString = "SELECT * FROM vehicleInformationTabl"; SqlCommand command = new SqlCommand(queryString, connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { vehicleObj = new VehicleInformationClass(); vehicleObj.ModelYear = (reader["modelYear"]).ToString(); vehicleObj.Department = (reader["department"]).ToString(); vehicleObj.VinNumber = (reader["vinNumber"]).ToString(); vehicleObj.VehicleNumber = (reader["vehicleNumber"]).ToString(); vehicleObj.Colour = (reader["colour"]).ToString(); vehicleObj.ModelNumber = (reader["modelNumber"]).ToString(); vehicleObj.EnginNumber = (reader["enginNumber"]).ToString(); vehicleObj.Transmistion = (reader["Transmistion"]).ToString(); vehicleObj.TrialSize = (reader["trialSize"]).ToString(); vehicleObj.CompanyName = (reader["companyName"]).ToString(); vehicleObj.AccountNumber = (reader["accountNumber"]).ToString(); vehicleses.Add(vehicleObj); } connection.Close(); return(vehicleses); }
public void saveVehicleInformation(VehicleInformationClass vehicleInformationObj) { string connectionString = @"server=DUET-559FE4FA51\SQLEXPRESS;integrated security = SSPI; database = VehicleInformationDB;"; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); string insertString = "INSERT INTO vehicleInformationTabl VALUES('" + vehicleInformationObj.ModelYear + "','" + vehicleInformationObj.Department + "','" + vehicleInformationObj.VinNumber + "','" + vehicleInformationObj.VehicleNumber + "','" + vehicleInformationObj.Colour + "','" + vehicleInformationObj.ModelNumber + "','" + vehicleInformationObj.EnginNumber + "','" + vehicleInformationObj.Transmistion + "','" + vehicleInformationObj.TrialSize + "','" + vehicleInformationObj.CompanyName + "','" + vehicleInformationObj.AccountNumber + "')"; SqlCommand command = new SqlCommand(insertString, connection); command.ExecuteNonQuery(); connection.Close(); }
private void vehicleSarchButton_Click(object sender, EventArgs e) { string vinNumberOf; vinNumberOf = vehicleSarchTextBox.Text; VehicleInformationClass vehicleObjc = null; string connectionString = @"server=DUET-559FE4FA51\SQLEXPRESS;integrated security = SSPI; database = VehicleInformationDB;"; SqlConnection connection = new SqlConnection(connectionString); connection.Open(); string queryString = "SELECT * FROM vehicleInformationTabl WHERE vinNumber='" + vinNumberOf + "'"; SqlCommand command = new SqlCommand(queryString, connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { vehicleObjc = new VehicleInformationClass(); vehicleObjc.ModelYear = (reader["modelYear"]).ToString(); vehicleModelYearTextBox.Text = (reader["modelYear"]).ToString(); vehicleObjc.Department = (reader["department"]).ToString(); departmentCcomboBox.Text = (reader["department"]).ToString(); vehicleObjc.VinNumber = (reader["vinNumber"]).ToString(); vehicleVenNumTextBox.Text = (reader["vinNumber"]).ToString(); vehicleObjc.VehicleNumber = (reader["vehicleNumber"]).ToString(); vehicleNumberTextBox.Text = (reader["vehicleNumber"]).ToString(); vehicleObjc.Colour = (reader["colour"]).ToString(); colorComboBox.Text = (reader["colour"]).ToString(); vehicleObjc.ModelNumber = (reader["modelNumber"]).ToString(); vehicleModelNumberTextBox.Text = (reader["modelNumber"]).ToString(); vehicleObjc.EnginNumber = (reader["enginNumber"]).ToString(); vehicleEnginNumberYextBox.Text = (reader["enginNumber"]).ToString(); vehicleObjc.Transmistion = (reader["Transmistion"]).ToString(); vehicleTranansmistionTextBox.Text = (reader["Transmistion"]).ToString(); vehicleObjc.TrialSize = (reader["trialSize"]).ToString(); vehicleTrilSizeTextBox.Text = (reader["trialSize"]).ToString(); vehicleObjc.CompanyName = (reader["companyName"]).ToString(); vehicleCompnyTextBox.Text = (reader["companyName"]).ToString(); vehicleObjc.AccountNumber = (reader["accountNumber"]).ToString(); vehicleAccountTextBox.Text = (reader["accountNumber"]).ToString(); } MessageBox.Show("modeYear=" + vehicleObjc.ModelYear + "\n vinNumber=" + vehicleObjc.VinNumber + "\n vehicleNumber=" + vehicleObjc.VehicleNumber + "\n modelNumber=" + vehicleObjc.ModelNumber + "\n enginNumber" + vehicleObjc.EnginNumber + "\n Transmistion" + vehicleObjc.Transmistion + "\n trialSize" + vehicleObjc.TrialSize + "\n companyName" + vehicleObjc.CompanyName + "\n accountNumber" + vehicleObjc.AccountNumber); connection.Close(); }
private void saveButton_Click(object sender, EventArgs e) { VehicleInformationClass vehicleObj = new VehicleInformationClass(); vehicleObj.ModelYear = vehicleModelYearTextBox.Text; vehicleObj.Department = departmentCcomboBox.Text; vehicleObj.VinNumber = vehicleVenNumTextBox.Text; vehicleObj.VehicleNumber = vehicleNumberTextBox.Text; vehicleObj.Colour = colorComboBox.Text; vehicleObj.ModelNumber = vehicleModelNumberTextBox.Text; vehicleObj.EnginNumber = vehicleEnginNumberYextBox.Text; vehicleObj.Transmistion = vehicleTranansmistionTextBox.Text; vehicleObj.TrialSize = vehicleTrilSizeTextBox.Text; vehicleObj.CompanyName = vehicleCompnyTextBox.Text; vehicleObj.AccountNumber = vehicleAccountTextBox.Text; VehicleInformationGetway vehicleStObj = new VehicleInformationGetway(); vehicleStObj.saveVehicleInformation(vehicleObj); MessageBox.Show("The information Save "); }