public Model(String argConnection, System.String argModel) { mConnection = argConnection; string pstrSql = "SELECT * FROM Model WHERE Model='" + argModel + "'"; SqlDataReader dr = SqlHelper.ExecuteReader(Connection, CommandType.Text, pstrSql); if (dr.Read()) { mModelId = (System.Int32)dr["ModelId"]; mVehicleMake = new VehicleMake(Connection, (int)dr["VehicleMakeId"]); mVehicleCategory = new VehicleCategory(Connection, (int)dr["VehicleCategoryId"]); mDefault = (System.String)dr["Model"]; mExcess = (System.Single)dr["Excess"]; mTypeOfBody = dr["TypeOfBody"].ToString(); mModelType = (System.Int32)dr["ModelType"]; mVehicleCategory = new VehicleCategory(Connection, (System.Int32)dr["VehicleCategoryId"]); } else { Exception ex = new Exception("Identifier does not exist."); ex.Source = "Model.Model()"; throw ex; } dr.Close(); }
public PartVehicleMake(String argConnection, Int32 argPartVehicleMakeId) { mConnection = argConnection; string pstrSql = "SELECT * FROM PartVehicleMake WHERE PartVehicleMakeId=" + argPartVehicleMakeId; SqlDataReader dr = SqlHelper.ExecuteReader(Connection, CommandType.Text, pstrSql); if (dr.Read()) { mPartVehicleMakeId = (System.Int32)dr["PartVehicleMakeId"]; mVehicleMake = new VehicleMake(Connection, (int)dr["VehicleMakeId"]); mPart = new Part(Connection, (int)dr["PartId"]); } else { Exception ex = new Exception("Identifier does not exist."); ex.Source = "PartVehicleMake.PartVehicleMake()"; throw ex; } dr.Close(); }