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