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