/// <summary> /// Add common parameters before calling a procedure /// </summary> /// <param name="cmd">command object, where parameters will be added</param> /// <param name="invoiceNoteObject"></param> private void AddCommonParams(SqlCommand cmd, InvoiceNoteBase invoiceNoteObject) { AddParameter(cmd, pGuid(InvoiceNoteBase.Property_CompanyId, invoiceNoteObject.CompanyId)); AddParameter(cmd, pInt32(InvoiceNoteBase.Property_InvoiceId, invoiceNoteObject.InvoiceId)); AddParameter(cmd, pNVarChar(InvoiceNoteBase.Property_Note, invoiceNoteObject.Note)); AddParameter(cmd, pDateTime(InvoiceNoteBase.Property_AddedDate, invoiceNoteObject.AddedDate)); AddParameter(cmd, pGuid(InvoiceNoteBase.Property_AddedBy, invoiceNoteObject.AddedBy)); }
/// <summary> /// Fills InvoiceNote object /// </summary> /// <param name="invoiceNoteObject">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(InvoiceNoteBase invoiceNoteObject, SqlDataReader reader, int start) { invoiceNoteObject.Id = reader.GetInt32(start + 0); invoiceNoteObject.CompanyId = reader.GetGuid(start + 1); invoiceNoteObject.InvoiceId = reader.GetInt32(start + 2); invoiceNoteObject.Note = reader.GetString(start + 3); invoiceNoteObject.AddedDate = reader.GetDateTime(start + 4); invoiceNoteObject.AddedBy = reader.GetGuid(start + 5); FillBaseObject(invoiceNoteObject, reader, (start + 6)); invoiceNoteObject.RowState = BaseBusinessEntity.RowStateEnum.NormalRow; }
/// <summary> /// Updates InvoiceNote /// </summary> /// <param name="invoiceNoteObject">Object to be updated</param> /// <returns>Number of rows affected</returns> public long Update(InvoiceNoteBase invoiceNoteObject) { try { SqlCommand cmd = GetSPCommand(UPDATEINVOICENOTE); AddParameter(cmd, pInt32(InvoiceNoteBase.Property_Id, invoiceNoteObject.Id)); AddCommonParams(cmd, invoiceNoteObject); long result = UpdateRecord(cmd); if (result > 0) { invoiceNoteObject.RowState = BaseBusinessEntity.RowStateEnum.NormalRow; } return(result); } catch (SqlException x) { throw new ObjectUpdateException(invoiceNoteObject, x); } }
/// <summary> /// Inserts InvoiceNote /// </summary> /// <param name="invoiceNoteObject">Object to be inserted</param> /// <returns>Number of rows affected</returns> public long Insert(InvoiceNoteBase invoiceNoteObject) { try { SqlCommand cmd = GetSPCommand(INSERTINVOICENOTE); AddParameter(cmd, pInt32Out(InvoiceNoteBase.Property_Id)); AddCommonParams(cmd, invoiceNoteObject); long result = InsertRecord(cmd); if (result > 0) { invoiceNoteObject.RowState = BaseBusinessEntity.RowStateEnum.NormalRow; invoiceNoteObject.Id = (Int32)GetOutParameter(cmd, InvoiceNoteBase.Property_Id); } return(result); } catch (SqlException x) { throw new ObjectInsertException(invoiceNoteObject, x); } }
/// <summary> /// Fills InvoiceNote object /// </summary> /// <param name="invoiceNoteObject">The object to be filled</param> /// <param name="reader">The reader to use to fill a single object</param> protected void FillObject(InvoiceNoteBase invoiceNoteObject, SqlDataReader reader) { FillObject(invoiceNoteObject, reader, 0); }