/// <summary> /// Execute /// </summary> /// <returns></returns> protected override bool Execute() { //Validation of parameters and user have been successful. We may now proceed to read from the database var adoCopyright = new Copyright_ADO(); //First we must check if the group exists already (we can't have duplicates) if (adoCopyright.Exists(Ado, DTO.CprCode)) { //This copyright exists already, we can't proceed Log.Instance.Debug("Copyright exists already - create request refused"); Response.error = Label.Get("error.duplicate"); return(false); } //Create the copyright - and retrieve the newly created Id int newId = adoCopyright.Create(Ado, DTO, SamAccountName); if (newId == 0) { Log.Instance.Debug("Can't create copyright"); Response.error = Label.Get("error.create"); return(false); } Response.data = JSONRPC.success; return(true); }
internal Copyright_DTO_Create ReadFromValue(string CprValue) { ADO Ado = new ADO("defaultConnection"); try { Copyright_DTO_Create dto = new Copyright_DTO_Create(); Copyright_ADO cAdo = new Copyright_ADO(); Copyright_DTO_Read readDTO = new Copyright_DTO_Read(); readDTO.CprValue = CprValue; var retval = cAdo.Read(Ado, readDTO); if (retval.hasData) { dto.CprCode = retval.data[0].CprCode; dto.CprValue = CprValue; dto.CprUrl = retval.data[0].CprUrl; } return(dto); } catch (Exception ex) { throw ex; } finally { Ado.Dispose(); } }
/// <summary> /// Execute /// </summary> /// <returns></returns> protected override bool Execute() { Copyright_ADO adoCopyright = new Copyright_ADO(); //First we must check if the amended Copyright code exists already (we can't have duplicates) if (!DTO.CprCodeNew.Equals(DTO.CprCodeOld)) { if (adoCopyright.Exists(Ado, DTO.CprCodeNew)) { //The proposed new copyright code exists already, we can't proceed Log.Instance.Debug("Copyright code exists already - create request refused"); Response.error = Label.Get("error.duplicate"); return(false); } } //Update and retrieve the number of updated rows int nUpdated = adoCopyright.Update(Ado, DTO, SamAccountName); if (nUpdated == 0) { Log.Instance.Debug("Can't update Copyright"); Response.error = Label.Get("error.update"); return(true); } Response.data = JSONRPC.success; return(true); }
/// <summary> /// Execute /// </summary> /// <returns></returns> protected override bool Execute() { //Validation of parameters and user have been successful. We may now proceed to read from the database var adoCopyright = new Copyright_ADO(); //Copyrights are returned as an ADO result ADO_readerOutput result = adoCopyright.Read(Ado, DTO); if (!result.hasData) { return(false); } Response.data = result.data; return(true); }
/// <summary> /// Execute /// </summary> /// <returns></returns> protected override bool Execute() { Copyright_ADO adoCopyright = new Copyright_ADO(); if (adoCopyright.IsInUse(Ado, DTO.CprCode)) { Log.Instance.Debug("Delete request for Copyright Code: " + DTO.CprCode + " refused because it is in use by at least one related entity"); Response.error = Label.Get("error.delete"); return(false); } //attempting to delete. The number of entities deleted are passed to the entitiesDeleted variable (this is 1 for a successful delete) int nDeleted = adoCopyright.Delete(Ado, DTO, SamAccountName); if (nDeleted == 0) { Log.Instance.Debug("No record found for delete request"); Response.error = Label.Get("error.delete"); return(false); } Response.data = JSONRPC.success; return(true); }