/// <summary>
/// method
/// retrieves a single service from the database
/// </summary>
/// <param name="lServiceID"></param>
/// <param name="di"></param>
/// <returns></returns>
public CStatus GetServiceDI(long lServiceID, out CServiceDataItem di)
{
//initialize parameters
di = 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_nServiceID", lServiceID);
//get the dataset
CDataSet cds = new CDataSet();
DataSet ds = null;
status = cds.GetOracleDataSet(DBConn,
"PCK_VARIABLE.GetServiceDI",
pList,
out ds);
if (!status.Status)
{
return(status);
}
di = new CServiceDataItem(ds);
return(status);
}
/// <summary>
/// method
/// inserts a service record into the database
/// </summary>
/// <param name="di"></param>
/// <param name="lServiceID"></param>
/// <returns></returns>
public CStatus InsertService(CServiceDataItem di, out long lServiceID)
{
//initialize parameters
lServiceID = 0;
//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);
//add the rest of the parameters
pList.AddInputParameter("pi_vServiceLabel", di.ServiceLabel);
pList.AddInputParameter("pi_nIsActive", (long)((di.IsActive) ? k_TRUE_FALSE_ID.True : k_TRUE_FALSE_ID.False));
pList.AddOutputParameter("po_nServiceID", di.ServiceID);
//execute the SP
status = DBConn.ExecuteOracleSP("PCK_VARIABLE.InsertService", pList);
if (status.Status)
{
lServiceID = pList.GetParamLongValue("po_nServiceID");
}
return(status);
}
/// <summary>
/// override
/// clears the dialog and loads the service specified with the
/// long id property if the dialog is loaded in update mode
/// </summary>
/// <param name="lEditMode"></param>
/// <returns></returns>
public override CStatus LoadControl(k_EDIT_MODE lEditMode)
{
EditMode = lEditMode;
txtService.Text = string.Empty;
txtService.Focus();
chkActive.Checked = false;
if (EditMode == k_EDIT_MODE.INSERT)
{
chkActive.Checked = true;
}
else if (EditMode == k_EDIT_MODE.UPDATE)
{
if (LongID < 1)
{
return(new CStatus(false, k_STATUS_CODE.Failed, "TODO"));
}
CServiceData service = new CServiceData(BaseMstr.BaseData);
CServiceDataItem di = null;
CStatus status = service.GetServiceDI(LongID, out di);
if (!status.Status)
{
return(status);
}
txtService.Text = di.ServiceLabel;
OriginalLabel = di.ServiceLabel;
chkActive.Checked = di.IsActive;
}
return(new CStatus());
}
/// <summary>
/// override
/// saves the values in the dialog and fires the save
/// event if the save was successful
/// </summary>
/// <returns></returns>
public override CStatus SaveControl()
{
CServiceDataItem di = new CServiceDataItem();
di.ServiceLabel = txtService.Text;
di.IsActive = chkActive.Checked;
CServiceData service = new CServiceData(BaseMstr.BaseData);
CStatus status = new CStatus();
switch (EditMode)
{
case k_EDIT_MODE.INSERT:
long lServiceID = -1;
status = service.InsertService(di, out lServiceID);
if (status.Status)
{
LongID = lServiceID;
EditMode = k_EDIT_MODE.UPDATE;
}
break;
case k_EDIT_MODE.UPDATE:
di.ServiceID = LongID;
status = service.UpdateService(di);
break;
default:
status.Status = false;
status.StatusCode = k_STATUS_CODE.Failed;
status.StatusComment = Resources.ErrorMessages.ERROR_INVALID_EDITMODE;
break;
}
if (!status.Status)
{
return(status);
}
if (_Save != null)
{
CAppUserControlArgs args = new CAppUserControlArgs(
k_EVENT.INSERT,
k_STATUS_CODE.Success,
string.Empty,
LongID.ToString());
_Save(this, args);
}
return(new CStatus());
}
