/// <summary>
/// Add common parameters before calling a procedure
/// </summary>
/// <param name="cmd">command object, where parameters will be added</param>
/// <param name="invoiceDetailObject"></param>
private void AddCommonParams(SqlCommand cmd, InvoiceDetailBase invoiceDetailObject)
{
AddParameter(cmd, pNVarChar(InvoiceDetailBase.Property_InvoiceId, 15, invoiceDetailObject.InvoiceId));
AddParameter(cmd, pGuid(InvoiceDetailBase.Property_InventoryId, invoiceDetailObject.InventoryId));
AddParameter(cmd, pGuid(InvoiceDetailBase.Property_EquipmentId, invoiceDetailObject.EquipmentId));
AddParameter(cmd, pNVarChar(InvoiceDetailBase.Property_EquipName, 500, invoiceDetailObject.EquipName));
AddParameter(cmd, pNVarChar(InvoiceDetailBase.Property_EquipDetail, invoiceDetailObject.EquipDetail));
AddParameter(cmd, pGuid(InvoiceDetailBase.Property_CompanyId, invoiceDetailObject.CompanyId));
AddParameter(cmd, pInt32(InvoiceDetailBase.Property_BundleId, invoiceDetailObject.BundleId));
AddParameter(cmd, pInt32(InvoiceDetailBase.Property_Quantity, invoiceDetailObject.Quantity));
AddParameter(cmd, pDouble(InvoiceDetailBase.Property_UnitPrice, invoiceDetailObject.UnitPrice));
AddParameter(cmd, pDouble(InvoiceDetailBase.Property_TotalPrice, invoiceDetailObject.TotalPrice));
AddParameter(cmd, pDateTime(InvoiceDetailBase.Property_CreatedDate, invoiceDetailObject.CreatedDate));
AddParameter(cmd, pNVarChar(InvoiceDetailBase.Property_CreatedBy, 50, invoiceDetailObject.CreatedBy));
}
/// <summary>
/// Fills InvoiceDetail object
/// </summary>
/// <param name="invoiceDetailObject">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(InvoiceDetailBase invoiceDetailObject, SqlDataReader reader, int start)
{
invoiceDetailObject.Id = reader.GetInt32(start + 0);
invoiceDetailObject.InvoiceId = reader.GetString(start + 1);
invoiceDetailObject.InventoryId = reader.GetGuid(start + 2);
invoiceDetailObject.EquipmentId = reader.GetGuid(start + 3);
if (!reader.IsDBNull(4))
{
invoiceDetailObject.EquipName = reader.GetString(start + 4);
}
if (!reader.IsDBNull(5))
{
invoiceDetailObject.EquipDetail = reader.GetString(start + 5);
}
invoiceDetailObject.CompanyId = reader.GetGuid(start + 6);
if (!reader.IsDBNull(7))
{
invoiceDetailObject.BundleId = reader.GetInt32(start + 7);
}
if (!reader.IsDBNull(8))
{
invoiceDetailObject.Quantity = reader.GetInt32(start + 8);
}
if (!reader.IsDBNull(9))
{
invoiceDetailObject.UnitPrice = reader.GetDouble(start + 9);
}
if (!reader.IsDBNull(10))
{
invoiceDetailObject.TotalPrice = reader.GetDouble(start + 10);
}
if (!reader.IsDBNull(11))
{
invoiceDetailObject.CreatedDate = reader.GetDateTime(start + 11);
}
if (!reader.IsDBNull(12))
{
invoiceDetailObject.CreatedBy = reader.GetString(start + 12);
}
FillBaseObject(invoiceDetailObject, reader, (start + 13));
invoiceDetailObject.RowState = BaseBusinessEntity.RowStateEnum.NormalRow;
}
/// <summary>
/// Updates InvoiceDetail
/// </summary>
/// <param name="invoiceDetailObject">Object to be updated</param>
/// <returns>Number of rows affected</returns>
public long Update(InvoiceDetailBase invoiceDetailObject)
{
try
{
SqlCommand cmd = GetSPCommand(UPDATEINVOICEDETAIL);
AddParameter(cmd, pInt32(InvoiceDetailBase.Property_Id, invoiceDetailObject.Id));
AddCommonParams(cmd, invoiceDetailObject);
long result = UpdateRecord(cmd);
if (result > 0)
{
invoiceDetailObject.RowState = BaseBusinessEntity.RowStateEnum.NormalRow;
}
return(result);
}
catch (SqlException x)
{
throw new ObjectUpdateException(invoiceDetailObject, x);
}
}
/// <summary>
/// Inserts InvoiceDetail
/// </summary>
/// <param name="invoiceDetailObject">Object to be inserted</param>
/// <returns>Number of rows affected</returns>
public long Insert(InvoiceDetailBase invoiceDetailObject)
{
try
{
SqlCommand cmd = GetSPCommand(INSERTINVOICEDETAIL);
AddParameter(cmd, pInt32Out(InvoiceDetailBase.Property_Id));
AddCommonParams(cmd, invoiceDetailObject);
long result = InsertRecord(cmd);
if (result > 0)
{
invoiceDetailObject.RowState = BaseBusinessEntity.RowStateEnum.NormalRow;
invoiceDetailObject.Id = (Int32)GetOutParameter(cmd, InvoiceDetailBase.Property_Id);
}
return(result);
}
catch (SqlException x)
{
throw new ObjectInsertException(invoiceDetailObject, x);
}
}
/// <summary>
/// Fills InvoiceDetail object
/// </summary>
/// <param name="invoiceDetailObject">The object to be filled</param>
/// <param name="reader">The reader to use to fill a single object</param>
protected void FillObject(InvoiceDetailBase invoiceDetailObject, SqlDataReader reader)
{
FillObject(invoiceDetailObject, reader, 0);
}
