public static DataSet GetParameter1(string paramNo, string buildType)
{
StoredProc storedProc = new StoredProc("upGetParameterByParamNo");
storedProc.StoredProcParams.Add(new StoredProcParam("@ParamNo", paramNo));
storedProc.StoredProcParams.Add(new StoredProcParam("@BuildType", buildType));
return storedProc.ExecuteDataSet();
}
public static DataSet GetModule(int moduleId)
{
StoredProc storedProc = new StoredProc("upGetModule");
storedProc.StoredProcParams.Add(new StoredProcParam("@ID", moduleId.ToString()));
return storedProc.ExecuteDataSet();
}
public static DataSet GetFrameOrder(int rulesetID)
{
StoredProc storedProc = new StoredProc("upGetFrameOrderByRulesetID");
storedProc.StoredProcParams.Add(new StoredProcParam("@RulesetID", rulesetID.ToString()));
return storedProc.ExecuteDataSet();
}
public static DataSet GetVehicleBuild(int rulesetID)
{
StoredProc storedProc = new StoredProc("upGetVehicleBuildByRuleset");
storedProc.StoredProcParams.Add(new StoredProcParam("@RulesetID", rulesetID.ToString()));
return storedProc.ExecuteDataSet();
}
public static DataSet GetVehicleFrameParameterIDs(string frame, int buildTypeId, int vehicleInstId)
{
StoredProc storedProc = new StoredProc("upGetVehicleFrameParameterIDs");
storedProc.StoredProcParams.Add(new StoredProcParam("@Frame", frame.ToString()));
storedProc.StoredProcParams.Add(new StoredProcParam("@BuildTypeID", buildTypeId.ToString()));
storedProc.StoredProcParams.Add(new StoredProcParam("@VehicleInstID", vehicleInstId.ToString()));
return storedProc.ExecuteDataSet();
}
public static DataSet GetRuleset()
{
StoredProc storedProc = new StoredProc("upGetRuleset");
return storedProc.ExecuteDataSet();
}
public static DataSet GetParameterOptionsBuildType(int buildType)
{
StoredProc storedProc = new StoredProc("upGetVehicleInstParameterOptions");
storedProc.StoredProcParams.Add(new StoredProcParam("@BuildType", buildType.ToString()));
return storedProc.ExecuteDataSet();
}
public static DataSet GetParamType()
{
StoredProc storedProc = new StoredProc("upGetParamTypes");
return storedProc.ExecuteDataSet();
}
public static DataSet GetModel()
{
StoredProc storedProc = new StoredProc("upGetModels");
return storedProc.ExecuteDataSet();
}
public static DataSet GetModel(string model)
{
StoredProc storedProc = new StoredProc("upGetVehicleCodeByCode");
storedProc.StoredProcParams.Add(new StoredProcParam("@Vehicle", model.ToString()));
return storedProc.ExecuteDataSet();
}
public static DataSet GetParametersOwned(int vehicleId, string userId)
{
StoredProc storedProc = new StoredProc("upGetParametersOwned");
storedProc.StoredProcParams.Add(new StoredProcParam("@VehicleID", vehicleId.ToString()));
storedProc.StoredProcParams.Add(new StoredProcParam("@UserID", userId));
return storedProc.ExecuteDataSet();
}
public static DataSet GetSuperUser(string userId)
{
StoredProc storedProc = new StoredProc("upGetSuperUser");
storedProc.StoredProcParams.Add(new StoredProcParam("@UserID", userId));
return storedProc.ExecuteDataSet();
}
public static DataSet GetParamsNotApproved(string vehicleInstId)
{
StoredProc storedProc = new StoredProc("upGetParamsNotApproved");
storedProc.StoredProcParams.Add(new StoredProcParam("@VehicleInstID", vehicleInstId));
return storedProc.ExecuteDataSet();
}
public static DataSet GetModuleBTExceptions(int moduleId)
{
StoredProc storedProc = new StoredProc("upGetModuleBuildTypeExceptions");
storedProc.StoredProcParams.Add(new StoredProcParam("@ModuleID", moduleId.ToString()));
return storedProc.ExecuteDataSet();
}
public static DataSet GetOptions()
{
StoredProc storedProc = new StoredProc("upGetOptions");
return storedProc.ExecuteDataSet();
}
public static DataSet GetFrame(Constants.BuildTypeCriteria buildType)
{
StoredProc storedProc = new StoredProc("upGetFramesByBuildType");
storedProc.StoredProcParams.Add(new StoredProcParam("@BuildTypeID", buildType.ID.ToString()));
return storedProc.ExecuteDataSet();
}
public static DataSet GetOptions(int paramGroupId)
{
StoredProc storedProc = new StoredProc("upGetParameterGroupOptions");
storedProc.StoredProcParams.Add(new StoredProcParam("@ParamGroupID", paramGroupId.ToString()));
return storedProc.ExecuteDataSet();
}
public static DataSet GetVehicleInst(int buildTypeId)
{
StoredProc storedProc = new StoredProc("upGetVehicleInstByBuildType");
storedProc.StoredProcParams.Add(new StoredProcParam("@BuildTypeID", buildTypeId.ToString()));
return storedProc.ExecuteDataSet();
}
public static DataSet GetVehicleInstsForExtract(string vehicleId)
{
StoredProc storedProc = new StoredProc("upGetVehicleInstsForExtract");
storedProc.StoredProcParams.Add(new StoredProcParam("@VehicleID", vehicleId));
return storedProc.ExecuteDataSet();
}
public static DataSet GetHistoryOfParamInst(int vehicleInstId, int paramId)
{
StoredProc storedProc = new StoredProc("upGetHistoryOfParamInst");
storedProc.StoredProcParams.Add(new StoredProcParam("@ParamID", paramId.ToString()));
storedProc.StoredProcParams.Add(new StoredProcParam("@VehicleInstID", vehicleInstId.ToString()));
return storedProc.ExecuteDataSet();
}
public static DataSet GetParameterSpecificationWithOptions(int buildTypeId)
{
StoredProc storedProc = new StoredProc("upGetParameterSpecificationWithOptions");
storedProc.StoredProcParams.Add(new StoredProcParam("@BuildTypeID", buildTypeId.ToString()));
return storedProc.ExecuteDataSet();
}
public static DataSet GetRuleset(int id)
{
StoredProc storedProc = new StoredProc("upGetRuleset");
storedProc.StoredProcParams.Add(new StoredProcParam("@ID", id.ToString()));
return storedProc.ExecuteDataSet();
}
public static DataSet GetVehicleStatus()
{
StoredProc storedProc = new StoredProc("upGetVehicleStatus");
return storedProc.ExecuteDataSet();
}
public static DataSet GetVehicleBuild(Constants.VehicleCriteria vehicle)
{
StoredProc storedProc = new StoredProc("upGetVehicleBuildByVehicle");
storedProc.StoredProcParams.Add(new StoredProcParam("@VehicleID", vehicle.ID.ToString()));
return storedProc.ExecuteDataSet();
}
public static DataSet GetModule(Constants.VehicleInstCriteria vInst)
{
StoredProc storedProc = new StoredProc("upGetModulesByVehicleInstance");
storedProc.StoredProcParams.Add(new StoredProcParam("@VehicleInstID", vInst.ID.ToString()));
return storedProc.ExecuteDataSet();
}
public static DataSet GetVehicleBuild(Constants.ModelCriteria model)
{
StoredProc storedProc = new StoredProc("upGetVehicleBuildByModel");
storedProc.StoredProcParams.Add(new StoredProcParam("@ModelID", model.ID.ToString()));
return storedProc.ExecuteDataSet();
}
public static DataSet GetParameter(string paramID)
{
StoredProc storedProc = new StoredProc("upGetParameter");
storedProc.StoredProcParams.Add(new StoredProcParam("@ParamID", paramID));
return storedProc.ExecuteDataSet();
}
