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