/// <summary>
/// method
/// retrieves all the services in the database that match the active filter
/// </summary>
/// <param name="lActiveFilter"></param>
/// <param name="ds"></param>
/// <returns></returns>
public CStatus GetServiceDS(k_ACTIVE_ID lActiveFilter, out DataSet ds)
{
//initialize parameters
ds = null;
//create a status object and check for valid dbconnection
CStatus status = DBConnValid();
if (!status.Status)
{
return(status);
}
//load the paramaters list
CParameterList pList = new CParameterList(SessionID, ClientIP, UserID);
pList.AddInputParameter("pi_nActiveFilter", (long)lActiveFilter);
//get the dataset
CDataSet cds = new CDataSet();
return(cds.GetOracleDataSet(DBConn,
"PCK_VARIABLE.GetServiceRS",
pList,
out ds));
}
/// <summary>
/// Load services label data into dropdownlist
/// </summary>
/// <param name="BaseMstr"></param>
/// <param name="ActiveFilter"></param>
/// <param name="ddl"></param>
/// <returns></returns>
public static CStatus LoadServiceDDL(
CData Data,
k_ACTIVE_ID ActiveFilter,
DropDownList ddl)
{
ddl.Items.Clear();
DataSet dsService = null;
CServiceData data = new CServiceData(Data);
CStatus status = data.GetServiceDS(ActiveFilter, out dsService);
if (!status.Status)
{
return(status);
}
status = CDropDownList.RenderDataSet(
dsService,
ddl,
"SERVICE_LABEL",
"SERVICE_ID");
if (!status.Status)
{
return(status);
}
return(new CStatus());
}
/// <summary>
/// Used to get a dataset of item components that pertain
/// to an item
/// </summary>
/// <param name="lItemID"></param>
/// <param name="ds"></param>
/// <param name="lStatusCode"></param>
/// <param name="strStatus"></param>
/// <returns></returns>
public CStatus GetItemComponentDS(
long lItemID,
k_ACTIVE_ID lActiveFilter,
out DataSet ds)
{
//initialize parameters
ds = null;
//create a status object and check for valid dbconnection
CStatus status = DBConnValid();
if (!status.Status)
{
return(status);
}
//load the paramaters list
CParameterList pList = new CParameterList(SessionID, ClientIP, UserID);
// procedure specific parameters
pList.AddInputParameter("pi_nItemID", lItemID);
pList.AddInputParameter("pi_nActiveFilter", (long)lActiveFilter);
//get the dataset
CDataSet cds = new CDataSet();
return(cds.GetOracleDataSet(
DBConn,
"PCK_ITEM_COMPONENT.GetItemComponentRS",
pList,
out ds));
}
/// <summary>
/// method
/// loads all the item groups that satisfy the active filter into a ddl
/// </summary>
/// <param name="Data"></param>
/// <param name="ddl"></param>
/// <param name="ActiveFilter"></param>
/// <returns></returns>
public static CStatus LoadItemGroupDDL(
CData Data,
DropDownList ddl,
k_ACTIVE_ID ActiveFilter)
{
//get the dataset
DataSet dsItemGroups = null;
CItemGroupData data = new CItemGroupData(Data);
CStatus status = data.GetItemGroupDS(ActiveFilter, out dsItemGroups);
if (!status.Status)
{
return(status);
}
//render the dataset
status = CDropDownList.RenderDataSet(
dsItemGroups,
ddl,
"ITEM_GROUP_LABEL",
"ITEM_GROUP_ID");
if (!status.Status)
{
return(status);
}
return(new CStatus());
}
public CItemComponentDataItem(DataSet ds)
{
if (!CDataUtils.IsEmpty(ds))
{
ItemID = CDataUtils.GetDSLongValue(ds, "ITEM_ID");
ItemComponentID = CDataUtils.GetDSLongValue(ds, "ITEM_COMPONENT_ID");
ItemComponentLabel = CDataUtils.GetDSStringValue(ds, "ITEM_COMPONENT_LABEL");
SortOrder = CDataUtils.GetDSLongValue(ds, "SORT_ORDER");
ActiveID = (k_ACTIVE_ID)CDataUtils.GetDSLongValue(ds, "ACTIVE_ID");
}
}
