/// <summary> /// Add common parameters before calling a procedure /// </summary> /// <param name="cmd">command object, where parameters will be added</param> /// <param name="localizeResourceObject"></param> private void AddCommonParams(SqlCommand cmd, LocalizeResourceBase localizeResourceObject) { AddParameter(cmd, pGuid(LocalizeResourceBase.Property_CompanyId, localizeResourceObject.CompanyId)); AddParameter(cmd, pInt32(LocalizeResourceBase.Property_LanguageId, localizeResourceObject.LanguageId)); AddParameter(cmd, pNVarChar(LocalizeResourceBase.Property_ResourceName, 200, localizeResourceObject.ResourceName)); AddParameter(cmd, pNVarChar(LocalizeResourceBase.Property_ResourceValue, localizeResourceObject.ResourceValue)); }
/// <summary> /// Fills LocalizeResource object /// </summary> /// <param name="localizeResourceObject">The object to be filled</param> /// <param name="reader">The reader to use to fill a single object</param> /// <param name="start">The ordinal position from which to start reading the reader</param> protected void FillObject(LocalizeResourceBase localizeResourceObject, SqlDataReader reader, int start) { localizeResourceObject.Id = reader.GetInt32(start + 0); localizeResourceObject.CompanyId = reader.GetGuid(start + 1); localizeResourceObject.LanguageId = reader.GetInt32(start + 2); localizeResourceObject.ResourceName = reader.GetString(start + 3); localizeResourceObject.ResourceValue = reader.GetString(start + 4); FillBaseObject(localizeResourceObject, reader, (start + 5)); localizeResourceObject.RowState = BaseBusinessEntity.RowStateEnum.NormalRow; }
/// <summary> /// Updates LocalizeResource /// </summary> /// <param name="localizeResourceObject">Object to be updated</param> /// <returns>Number of rows affected</returns> public long Update(LocalizeResourceBase localizeResourceObject) { try { SqlCommand cmd = GetSPCommand(UPDATELOCALIZERESOURCE); AddParameter(cmd, pInt32(LocalizeResourceBase.Property_Id, localizeResourceObject.Id)); AddCommonParams(cmd, localizeResourceObject); long result = UpdateRecord(cmd); if (result > 0) { localizeResourceObject.RowState = BaseBusinessEntity.RowStateEnum.NormalRow; } return(result); } catch (SqlException x) { throw new ObjectUpdateException(localizeResourceObject, x); } }
/// <summary> /// Inserts LocalizeResource /// </summary> /// <param name="localizeResourceObject">Object to be inserted</param> /// <returns>Number of rows affected</returns> public long Insert(LocalizeResourceBase localizeResourceObject) { try { SqlCommand cmd = GetSPCommand(INSERTLOCALIZERESOURCE); AddParameter(cmd, pInt32Out(LocalizeResourceBase.Property_Id)); AddCommonParams(cmd, localizeResourceObject); long result = InsertRecord(cmd); if (result > 0) { localizeResourceObject.RowState = BaseBusinessEntity.RowStateEnum.NormalRow; localizeResourceObject.Id = (Int32)GetOutParameter(cmd, LocalizeResourceBase.Property_Id); } return(result); } catch (SqlException x) { throw new ObjectInsertException(localizeResourceObject, x); } }
/// <summary> /// Fills LocalizeResource object /// </summary> /// <param name="localizeResourceObject">The object to be filled</param> /// <param name="reader">The reader to use to fill a single object</param> protected void FillObject(LocalizeResourceBase localizeResourceObject, SqlDataReader reader) { FillObject(localizeResourceObject, reader, 0); }