protected VLLibraryColumn ExecuteAndGetLibraryColumn(DbCommand cmd) { VLLibraryColumn _retObject = null; try { cmd.Connection.Open(); using (DbDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows == false) { return(null); } reader.Read(); _retObject = new VLLibraryColumn(reader); } } finally { cmd.Connection.Close(); } return(_retObject); }
internal override VLLibraryColumn UpdateLibraryColumnImpl(Int32 accessToken, VLLibraryColumn column, DateTime currentTimeUtc) { try { DbCommand command = CreateCommand("valis_librarycolumns_Update"); AddParameter(command, "@accessToken", accessToken, DbType.Int32); AddParameter(command, "@question", column.Question, DbType.Int32); AddParameter(command, "@columnId", column.ColumnId, DbType.Byte); AddParameter(command, "@displayOrder", column.DisplayOrder, DbType.Byte); AddParameter(command, "@attributeFlags", column.AttributeFlags, DbType.Int32); AddParameter(command, "@currentTimeUtc", currentTimeUtc, DbType.DateTime); AddParameter(command, "@textsLanguage", column.TextsLanguage, DbType.Int16); AddParameter(command, "@columnText", column.ColumnText, DbType.String); return(ExecuteAndGetLibraryColumn(command)); } catch (SqlException ex) { if (ex.Class == 14 && ex.State == 10) { throw new VLInvalidAccessTokenException(SR.GetString(SR.Invalid_accessToken_while_calling_LibrariesDao, "UpdateLibraryColumnImpl"), ex); } else { throw new VLDataException(SR.GetString(SR.Exception_occured_at_LibrariesDao, "UpdateLibraryColumnImpl"), ex); } } catch (Exception ex) { throw new VLDataException(SR.GetString(SR.Exception_occured_at_LibrariesDao, "UpdateLibraryColumnImpll"), ex); } }
/// <summary> /// /// </summary> /// <param name="accessToken"></param> /// <param name="obj"></param> /// <param name="textsLanguage"></param> /// <returns></returns> public VLLibraryColumn CreateLibraryColumn(Int32 accessToken, VLLibraryColumn column, short textsLanguage = 0) { if (column == null) { throw new ArgumentNullException("column"); } try { return(CreateLibraryColumnImpl(accessToken, column, Utility.UtcNow(), textsLanguage)); } catch { throw; } }
/// <summary> /// /// </summary> /// <param name="accessToken"></param> /// <param name="obj"></param> /// <returns></returns> public VLLibraryColumn UpdateLibraryColumn(Int32 accessToken, VLLibraryColumn column) { if (column == null) { throw new ArgumentNullException("column"); } try { return(UpdateLibraryColumnImpl(accessToken, column, Utility.UtcNow())); } catch { throw; } }
protected Collection <VLLibraryColumn> ExecuteAndGetLibraryColumns(DbCommand cmd) { var collection = new Collection <VLLibraryColumn>(); try { cmd.Connection.Open(); using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var _object = new VLLibraryColumn(reader); collection.Add(_object); } } } finally { cmd.Connection.Close(); } return(collection); }
internal abstract VLLibraryColumn CreateLibraryColumnImpl(Int32 accessToken, VLLibraryColumn column, DateTime currentTimeUtc, short textsLanguage);
internal abstract VLLibraryColumn UpdateLibraryColumnImpl(Int32 accessToken, VLLibraryColumn column, DateTime currentTimeUtc);