public string DeleteFAIncrement(FAIncrementEntity faIncrement)
{
const string sql = @"uspDelete_FixedAssetIncrement";
object[] parms = { "@RefID", faIncrement.RefId };
return(Db.Delete(sql, true, parms));
}
/// <summary>
/// Takes the specified receipt voucher.
/// </summary>
/// <param name="faIncrement">The receipt voucher.</param>
/// <returns></returns>
private object[] Take(FAIncrementEntity faIncrement)
{
return(new object[]
{
@"RefId", faIncrement.RefId,
@"RefTypeId", faIncrement.RefTypeId,
@"RefNo", faIncrement.RefNo,
@"RefDate", faIncrement.RefDate,
@"PostedDate", faIncrement.PostedDate,
@"CurrencyCode", faIncrement.CurrencyCode,
@"ExchangeRate", faIncrement.ExchangeRate,
@"AccountingObjectType", faIncrement.AccountingObjectType,
@"CustomerID", faIncrement.CustomerId,
@"VendorID", faIncrement.VendorId,
@"AccountingObjectID", faIncrement.AccountingObjectId,
@"EmployeeID", faIncrement.EmployeeId,
@"Trader", faIncrement.Trader,
@"DocumentInclude", faIncrement.DocumentInclude,
@"TotalAmountOC", faIncrement.TotalAmountOC,
@"TotalAmountExchange", faIncrement.TotalAmountExchange,
@"JournalMemo", faIncrement.JournalMemo,
@"BankID", faIncrement.BankId
});
}
public string UpdateFAIncrement(FAIncrementEntity faIncrement)
{
const string sql = @"uspUpdate_FixedAssetIncrement";
return(Db.Update(sql, true, Take(faIncrement)));
}
public int InsertFAIncrement(FAIncrementEntity faIncrement)
{
const string sql = @"uspInsert_FixedAssetIncrement";
return(Db.Insert(sql, true, Take(faIncrement)));
}
internal static FixedAssetIncrementModel FromDataTransferObject(FAIncrementEntity entity)
{
return(entity == null ? null : AutoMapper.Mapper.Map <FAIncrementEntity, FixedAssetIncrementModel>(entity));
}
