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