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