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