public void removeVehicleModel(Vehicle_modelM VM) { string spName = @"[dbo].[removeVehicleModel]"; using (SqlCommand cmd = new SqlCommand(spName, SQLConnection)) { SqlParameter[] parms = new SqlParameter[3]; string[] names = { "@Vehicle_make", "@Vehicle_model", "@Vehicle_year" }; SqlDbType[] DBtypes = { SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.Int }; Object[] values = { VM.Vehicle_make, VM.Vehicle_model, VM.Year }; for (int i = 0; i < parms.Length; i++) { parms[i] = new SqlParameter(); parms[i].ParameterName = names[i]; parms[i].SqlDbType = DBtypes[i]; parms[i].Value = values[i]; cmd.Parameters.Add(parms[i]); } cmd.CommandType = CommandType.StoredProcedure; cmd.ExecuteNonQuery(); } }
public void addCompatibility(int Part_id, Vehicle_modelM VehicleType) { string spName = @"[dbo].[addCompatibility]"; using (SqlCommand cmd = new SqlCommand(spName, SQLConnection)) { SqlParameter[] parms = new SqlParameter[4]; string[] names = { "@Part_id", "@Vehicle_Make", "@Vehicle_Model", "@Vehicle_Year" }; SqlDbType[] DBtypes = { SqlDbType.Int, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.Int }; Object[] values = { Part_id, VehicleType.Vehicle_make, VehicleType.Vehicle_model, VehicleType.Year }; for (int i = 0; i < parms.Length; i++) { parms[i] = new SqlParameter(); parms[i].ParameterName = names[i]; parms[i].SqlDbType = DBtypes[i]; parms[i].Value = values[i]; cmd.Parameters.Add(parms[i]); } cmd.CommandType = CommandType.StoredProcedure; cmd.ExecuteNonQuery(); } }
public bool checkVehicleModel(Vehicle_modelM vehicle_modelM) { bool exists = false; string spName = @"[dbo].[checkVehicleModel]"; using (SqlCommand cmd = new SqlCommand(spName, SQLConnection)) { SqlParameter[] parms = new SqlParameter[3]; string[] names = { "@Vehicle_make", "@Vehicle_model", "@Year" }; SqlDbType[] DBtypes = { SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.Int }; Object[] values = { vehicle_modelM.Vehicle_make, vehicle_modelM.Vehicle_model, vehicle_modelM.Year }; for (int i = 0; i < parms.Length; i++) { parms[i] = new SqlParameter(); parms[i].ParameterName = names[i]; parms[i].SqlDbType = DBtypes[i]; parms[i].Value = values[i]; cmd.Parameters.Add(parms[i]); } cmd.CommandType = CommandType.StoredProcedure; using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { int test = 0; while (reader.Read()) { if (test > 0) { throw new Exception("Function checkVehicleModel Failed"); } exists = reader.GetBoolean(0); } } } } return(exists); }
public bool checkPartCompatibility(int Part_id, Vehicle_modelM VehicleType) { bool Compatible = false; string spName = @"[dbo].[checkPartCompatibility]"; using (SqlCommand cmd = new SqlCommand(spName, SQLConnection)) { SqlParameter[] parms = new SqlParameter[4]; string[] names = { "@Part_id", "@Vehicle_Make", "@Vehicle_Model", "@Vehicle_Year" }; SqlDbType[] DBtypes = { SqlDbType.Int, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.Int }; Object[] values = { Part_id, VehicleType.Vehicle_make, VehicleType.Vehicle_model, VehicleType.Year }; for (int i = 0; i < parms.Length; i++) { parms[i] = new SqlParameter(); parms[i].ParameterName = names[i]; parms[i].SqlDbType = DBtypes[i]; parms[i].Value = values[i]; cmd.Parameters.Add(parms[i]); } cmd.CommandType = CommandType.StoredProcedure; using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { int test = 0; while (reader.Read()) { if (test > 0) { throw new Exception("Function checkPartCompatibility Failed"); } Compatible = reader.GetBoolean(0); } } } } return(Compatible); }
public List <Catalog_partM> searchCompatiblePart(Vehicle_modelM VM, string searchTerm) { List <Catalog_partM> Parts = new List <Catalog_partM>(); string spName = @"[dbo].[searchCompatiblePart]"; using (SqlCommand cmd = new SqlCommand(spName, SQLConnection)) { SqlParameter[] parms = new SqlParameter[4]; string[] names = { "@Vehicle_make", "@Vehicle_model", "@Vehicle_year", "@Part_name_string" }; SqlDbType[] DBtypes = { SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.Int, SqlDbType.VarChar }; Object[] values = { VM.Vehicle_make, VM.Vehicle_model, VM.Year, searchTerm }; for (int i = 0; i < parms.Length; i++) { parms[i] = new SqlParameter(); parms[i].ParameterName = names[i]; parms[i].SqlDbType = DBtypes[i]; parms[i].Value = values[i]; cmd.Parameters.Add(parms[i]); } cmd.CommandType = CommandType.StoredProcedure; using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { Parts.Add(new Catalog_partM(reader)); } } } } return(Parts); }