/// <summary>
/// Deletes the FADecrement entity.
/// </summary>
/// <param name="faDecrement">The FADecrement.</param>
/// <returns></returns>
public string DeleteFADecrement(FADecrementEntity faDecrement)
{
const string sql = @"uspDelete_FixedAssetDecrement";
object[] parms = { "@RefID", faDecrement.RefId };
return(Db.Delete(sql, true, parms));
}
/// <summary>
/// Takes the specified receipt voucher.
/// </summary>
/// <param name="faDecrement">The receipt voucher.</param>
/// <returns></returns>
private object[] Take(FADecrementEntity faDecrement)
{
return(new object[]
{
@"RefId", faDecrement.RefId,
@"RefTypeId", faDecrement.RefTypeId,
@"RefNo", faDecrement.RefNo,
@"RefDate", faDecrement.RefDate,
@"PostedDate", faDecrement.PostedDate,
@"CurrencyCode", faDecrement.CurrencyCode,
@"ExchangeRate", faDecrement.ExchangeRate,
@"AccountingObjectType", faDecrement.AccountingObjectType,
@"CustomerID", faDecrement.CustomerId,
@"VendorID", faDecrement.VendorId,
@"AccountingObjectID", faDecrement.AccountingObjectId,
@"EmployeeID", faDecrement.EmployeeId,
@"TotalAmountOC", faDecrement.TotalAmountOC,
@"TotalAmountExchange", faDecrement.TotalAmountExchange,
@"JournalMemo", faDecrement.JournalMemo,
@"DocumentInclude", faDecrement.DocumentInclude,
@"Trader", faDecrement.Trader,
@"BankID", faDecrement.BankId
});
}
internal static FixedAssetDecrementModel FromDataTransferObject(FADecrementEntity entity)
{
return(entity == null ? null : AutoMapper.Mapper.Map <FADecrementEntity, FixedAssetDecrementModel>(entity));
}
/// <summary>
/// Updates the FADecrement entity.
/// </summary>
/// <param name="faDecrement">The FADecrement.</param>
/// <returns></returns>
public string UpdateFADecrement(FADecrementEntity faDecrement)
{
const string sql = @"uspUpdate_FixedAssetDecrement";
return(Db.Update(sql, true, Take(faDecrement)));
}
/// <summary>
/// Inserts the FADecrement.
/// </summary>
/// <param name="faDecrement">The FADecrement.</param>
/// <returns></returns>
public int InsertFADecrement(FADecrementEntity faDecrement)
{
const string sql = @"uspInsert_FixedAssetDecrement";
return(Db.Insert(sql, true, Take(faDecrement)));
}
