/// <summary>
/// Deletes the bAWithDraw.
/// </summary>
/// <param name="bAWithDraw">The bAWithDraw.</param>
/// <returns>
/// System.String.
/// </returns>
public string DeleteBAWithDraw(BAWithDrawEntity bAWithDraw)
{
const string sql = @"uspDelete_BAWithDraw";
object[] parms = { "@RefID", bAWithDraw.RefId };
return(Db.Delete(sql, true, parms));
}
/// <summary>
/// Gets the bAWithDraw by refdate and reftype.
/// </summary>
/// <param name="bBAWithDrawEntity">The ob bAWithDraw entity.</param>
/// <returns></returns>
public BAWithDrawEntity GetBAWithDrawByRefdateAndReftype(BAWithDrawEntity bBAWithDrawEntity)
{
const string procedures = @"uspGet_BAWithDraw_ForSalary";
object[] parms =
{
"@RefType", bBAWithDrawEntity.RefType, "@PostedDate", bBAWithDrawEntity.PostedDate, "@RefNo",
bBAWithDrawEntity.RefNo
};
return(Db.Read(procedures, true, Make, parms));
}
/// <summary>
/// Takes the specified receipt voucher.
/// </summary>
/// <param name="bAWithDraw">The receipt voucher.</param>
/// <returns></returns>
private object[] Take(BAWithDrawEntity bAWithDraw)
{
return(new object[]
{
"@RefID", bAWithDraw.RefId,
"@RefType", bAWithDraw.RefType,
"@RefDate", bAWithDraw.RefDate,
"@PostedDate", bAWithDraw.PostedDate,
"@RefNo", bAWithDraw.RefNo,
"@CurrencyCode", bAWithDraw.CurrencyCode,
"@ExchangeRate", bAWithDraw.ExchangeRate,
"@ParalellRefNo", bAWithDraw.ParalellRefNo,
"@InwardRefNo", bAWithDraw.InwardRefNo,
"@IncrementRefNo", bAWithDraw.IncrementRefNo,
"@BankID", bAWithDraw.BankId,
"@BankName", bAWithDraw.BankName,
"@JournalMemo", bAWithDraw.JournalMemo,
"@AccountingObjectID", bAWithDraw.AccountingObjectId,
"@TotalAmount", bAWithDraw.TotalAmount,
"@TotalAmountOC", bAWithDraw.TotalAmountOC,
"@TotalTaxAmount", bAWithDraw.TotalTaxAmount,
"@TotalFreightAmount", bAWithDraw.TotalFreightAmount,
"@TotalInwardAmount", bAWithDraw.TotalInwardAmount,
"@Reconciled", bAWithDraw.Reconciled,
"@Posted", bAWithDraw.Posted,
"@PostVersion", bAWithDraw.PostVersion,
"@EditVersion", bAWithDraw.EditVersion,
"@RefOrder", bAWithDraw.RefOrder,
"@RelationRefID", bAWithDraw.RelationRefId,
"@TotalPaymentAmount", bAWithDraw.TotalPaymentAmount,
"@RelationType", bAWithDraw.RelationType,
"@ReceiveName", bAWithDraw.ReceiveName,
"@ReceiveId", bAWithDraw.ReceiveId,
"@ReceiveIssueDate", bAWithDraw.ReceiveIssueDate,
"@ReceiveIssueLocation", bAWithDraw.ReceiveIssueLocation,
"@AccountingObjectBankAccount", bAWithDraw.AccountingObjectBankAccount
});
}
/// <summary>
/// Updates the bAWithDraw.
/// </summary>
/// <param name="bAWithDraw">The bAWithDraw.</param>
/// <returns>
/// System.String.
/// </returns>
/// <exception cref="NotImplementedException"></exception>
public string UpdateBAWithDraw(BAWithDrawEntity bAWithDraw)
{
const string sql = @"uspUpdate_BAWithDraw";
return(Db.Update(sql, true, Take(bAWithDraw)));
}
/// <summary>
/// Inserts the bAWithDraw.
/// </summary>
/// <param name="bAWithDraw">The bAWithDraw.</param>
/// <returns>
/// System.Int32.
/// </returns>
/// <exception cref="NotImplementedException"></exception>
public string InsertBAWithDraw(BAWithDrawEntity bAWithDraw)
{
const string sql = @"uspInsert_BAWithDraw";
return(Db.Insert(sql, true, Take(bAWithDraw)));
}
public List <BAWithDrawEntity> GetBAWithDraws(string connectionString)
{
List <BAWithDrawEntity> buentity = new List <BAWithDrawEntity>();
using (var context = new MISAEntity(connectionString))
{
var querry = context.BAWithDrawDetails.ToList();
var projects = context.Projects.ToList();
var currencys = context.CCies.ToList();
var budgetsource = context.BudgetSources.ToList();
var listitems = context.ListItems.ToList();
var funds = context.Funds.ToList();
var fundstructures = context.FundStructures.ToList();
var budgetproviders = context.BudgetProvidences.ToList();
var accountingobject = context.AccountingObjects.ToList();
var projectexpenses = context.ProjectExpenses.ToList();
var activity = context.Activities.ToList();
var tasks = context.Tasks.ToList();
var stocks = context.Stocks.ToList();
//var topics = context.Topics.ToList();
var fixedassets = context.FixedAssets.ToList();
var departments = context.Departments.ToList();
var purchasepurposes = context.PurchasePurposes.ToList();
var inventoryitems = context.InventoryItems.ToList();
banks = context.BankInfoes.ToList();
var detailfixedassets = context.BAWithDrawDetailFixedAssets.ToList();
var detailparallels = context.BAWithDrawDetailParallels.ToList();
var detailpurchases = context.BAWithDrawDetailPurchases.ToList();
var detailtax = context.BAWithdrawDetailTaxes.ToList();
var resultcontext = context.BAWithDraws.ToList();
foreach (var result in resultcontext)
{
var newresult = new BAWithDrawEntity();
newresult.RefId = result.RefID.ToString();
newresult.RefType = ConvRefType.ConvRefType(result.RefType);
newresult.RefDate = result.RefDate;
newresult.PostedDate = result.PostedDate;
newresult.RefNo = result.RefNo;
newresult.CurrencyCode = result.CCY == null ? null : result.CCY.CurrencyID;
newresult.ExchangeRate = result.ExchangeRate ?? 0;
newresult.ParalellRefNo = result.ParalellRefNo;
newresult.InwardRefNo = result.InwardRefNo;
newresult.IncrementRefNo = result.IncrementRefNo;
newresult.BankId = result.BankAccount == null ? null : banks.FirstOrDefault(x => x.BankAccount == result.BankAccount).BankInfoID.ToString();
newresult.BankName = result.BankName;
newresult.JournalMemo = result.JournalMemo;
newresult.AccountingObjectId = result.AccountingObject == null ? null : result.AccountingObject.AccountingObjectID.ToString();
newresult.TotalAmount = result.TotalAmount;
newresult.TotalAmountOC = result.TotalAmountOC;
newresult.TotalTaxAmount = result.TotalTaxAmount;
newresult.TotalFreightAmount = result.TotalFreightAmount;
newresult.TotalInwardAmount = result.TotalInwardAmount;
newresult.Reconciled = result.Reconciled;
newresult.Posted = result.Posted;
newresult.PostVersion = result.PostVersion;
newresult.EditVersion = result.EditVersion;
newresult.RefOrder = result.RefOrder;
newresult.RelationRefId = result.RelationRefID.ToString();
newresult.TotalPaymentAmount = result.TotalPaymentAmount;
newresult.BAWithDrawDetails = result.BAWithDrawDetails.Count <= 0 ? null : BAWithDrawDetails(result.BAWithDrawDetails.ToList(), result.RefID.ToString());
newresult.BAWithDrawDetailFixedAssets = result.BAWithDrawDetailFixedAssets.Count <= 0 ? null : BAWithDrawDetailFixedAssets(result.BAWithDrawDetailFixedAssets.ToList(), result.RefID.ToString());
newresult.BAWithDrawDetailParallels = result.BAWithDrawDetailParallels.Count <= 0 ? null : BAWithDrawDetailParallels(result.BAWithDrawDetailParallels.ToList(), result.RefID.ToString());
newresult.BAWithDrawDetailPurchases = result.BAWithDrawDetailPurchases.Count <= 0 ? null : BAWithDrawDetailPurchases(result.BAWithDrawDetailPurchases.ToList(), result.RefID.ToString());
newresult.BAWithdrawDetailTaxs = result.BAWithdrawDetailTaxes.Count <= 0 ? null : BAWithdrawDetailTaxs(result.BAWithdrawDetailTaxes.ToList(), result.RefID.ToString());
buentity.Add(newresult);
}
}
return(buentity);
}
