public string DeleteItemTransaction(ItemTransactionEntity itemTransaction)
{
const string sql = @"uspDelete_ItemTransaction";
object[] parms = { "@RefID", itemTransaction.RefId };
return(Db.Delete(sql, true, parms));
}
/// <summary>
/// Takes the specified take.
/// </summary>
/// <param name="take">The take.</param>
/// <returns></returns>
private object[] Take(ItemTransactionEntity take)
{
return(new object[]
{
"@RefID", take.RefId,
"@RefTypeID", take.RefTypeId,
"@RefNo", take.RefNo,
"@RefDate", take.RefDate,
"@PostedDate", take.PostedDate,
"@AccountingObjectID", take.AccountingObjectId,
"@CustomerID", take.CustomerId,
"@VendorID", take.VendorId,
"@EmployeeID", take.EmployeeId,
"@Trader", take.Trader,
"@CurrencyCode", take.CurrencyCode,
"@StockID", take.StockId,
"@TotalAmountOC", take.TotalAmount,
"@ExchangeRate", take.ExchangeRate,
"@TotalAmountExchange", take.TotalAmountExchange,
"@JournalMemo", take.JournalMemo,
"@DocumentInclude", take.DocumentInclude,
"@AccountingObjectType", take.AccountingObjectType,
"@TaxCode", take.TaxCode,
"@BankID", take.BankId,
});
}
internal static ItemTransactionModel FromDataTransferObject(ItemTransactionEntity entity)
{
return(entity == null ? null : AutoMapper.Mapper.Map <ItemTransactionEntity, ItemTransactionModel>(entity));
}
public string UpdateItemTransaction(ItemTransactionEntity itemTransaction)
{
const string sql = @"uspUpdate_ItemTransaction";
return(Db.Update(sql, true, Take(itemTransaction)));
}
public int InsertItemTransaction(ItemTransactionEntity itemTransaction)
{
const string sql = @"uspInsert_ItemTransaction";
return(Db.Insert(sql, true, Take(itemTransaction)));
}
public ItemTransactionEntity GetItemTransactionByRefdateAndReftype(ItemTransactionEntity itemTransaction)
{
throw new NotImplementedException();
}
