/// <summary> /// Deletes the bADeposit. /// </summary> /// <param name="bADeposit">The bADeposit.</param> /// <returns> /// System.String. /// </returns> public string DeleteBADeposit(BADepositEntity bADeposit) { const string sql = @"uspDelete_BADeposit"; object[] parms = { "@RefID", bADeposit.RefId }; return(Db.Delete(sql, true, parms)); }
/// <summary> /// Gets the bADeposit by refdate and reftype. /// </summary> /// <param name="bBADepositEntity">The ob bADeposit entity.</param> /// <returns></returns> public BADepositEntity GetBADepositByRefdateAndReftype(BADepositEntity bBADepositEntity) { const string procedures = @"uspGet_BADeposit_ForSalary"; object[] parms = { "@RefType", bBADepositEntity.RefType, "@PostedDate", bBADepositEntity.PostedDate, "@RefNo", bBADepositEntity.RefNo }; return(Db.Read(procedures, true, Make, parms)); }
/// <summary> /// Takes the specified receipt voucher. /// </summary> /// <param name="bADeposit">The receipt voucher.</param> /// <returns></returns> private object[] Take(BADepositEntity bADeposit) { return(new object[] { "@RefID", bADeposit.RefId, "@RefType", bADeposit.RefType, "@RefNo", bADeposit.RefNo, "@RefDate", bADeposit.RefDate, "@PostedDate", bADeposit.PostedDate, "@CurrencyCode", bADeposit.CurrencyCode, "@ExchangeRate", bADeposit.ExchangeRate, "@ParalellRefNo", bADeposit.ParalellRefNo, "@OutwardRefNo", bADeposit.OutwardRefNo, "@AccountingObjectID", bADeposit.AccountingObjectId, "@BankID", bADeposit.BankId, "@InvType", bADeposit.InvType, "@InvDate", bADeposit.InvDate, "@InvSeries", bADeposit.InvSeries, "@InvNo", bADeposit.InvNo, "@JournalMemo", bADeposit.JournalMemo, "@TotalAmount", bADeposit.TotalAmount, "@TotalAmountOC", bADeposit.TotalAmountOC, "@TotalTaxAmount", bADeposit.TotalTaxAmount, "@TotalOutwardAmount", bADeposit.TotalOutwardAmount, "@Reconciled", bADeposit.Reconciled, "@Posted", bADeposit.Posted, "@PostVersion", bADeposit.PostVersion, "@EditVersion", bADeposit.EditVersion, "@RefOrder", bADeposit.RefOrder, "@InvoiceForm", bADeposit.InvoiceForm, "@InvoiceFormNumberID", bADeposit.InvoiceFormNumberId, "@InvSeriesPrefix", bADeposit.InvSeriesPrefix, "@InvSeriesSuffix", bADeposit.InvSeriesSuffix, "@PayForm", bADeposit.PayForm, "@ComPanyTaxcode", bADeposit.ComPanyTaxcode, "@AccountingObjectContactName", bADeposit.AccountingObjectContactName, "@ListNo", bADeposit.ListNo, "@ListDate", bADeposit.ListDate, "@IsAttachList", bADeposit.IsAttachList, "@ListCommonNameInventory", bADeposit.ListCommonNameInventory, "@BUCommitmentRequestId", bADeposit.BUCommitmentRequestId, "@TotalReceiptAmount", bADeposit.TotalReceiptAmount, "@Payer", bADeposit.Payer, }); }
public List <BADepositEntity> GetBADeposits(string connectionString) { List <BADepositEntity> buentity = new List <BADepositEntity>(); using (var context = new MISAEntity(connectionString)) { var querry = context.BADepositDetails.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 topics = context.Topics.ToList(); banks = context.BankInfoes.ToList(); var department = context.Departments.ToList(); var resultcontext = context.BADeposits.Where(x => x.RefType != 154).Where(x => x.RefType != 155).ToList(); var fixedasset = context.FixedAssets.ToList(); var inventoryitems = context.InventoryItems.ToList(); var stocks = context.Stocks.ToList(); var invoiceformnumber = context.InvoiceFormNumbers.ToList(); //Detail var parallel = context.BADepositDetailParallels.ToList(); var detailfixedassets = context.BADepositDetailFixedAssets.ToList(); var sales = context.BADepositDetailSales.ToList(); var taxs = context.BADepositDetailTaxes.ToList(); foreach (var result in resultcontext) { var newresult = new BADepositEntity(); 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.OutwardRefNo = result.OutwardRefNo; newresult.AccountingObjectId = result.AccountingObject == null ? null : result.AccountingObject.AccountingObjectID.ToString(); newresult.BankId = result.BankAccount == null ? null : banks.FirstOrDefault(x => x.BankAccount == result.BankAccount).BankInfoID.ToString(); newresult.InvType = result.InvType; newresult.InvDate = result.InvDate; newresult.InvSeries = result.InvSeries; newresult.InvNo = result.InvNo; newresult.JournalMemo = result.JournalMemo; newresult.TotalAmount = result.TotalAmount; newresult.TotalAmountOC = result.TotalAmountOC; newresult.TotalTaxAmount = result.TotalTaxAmount; newresult.TotalOutwardAmount = result.TotalOutwardAmount; newresult.Reconciled = result.Reconciled; newresult.Posted = result.Posted; newresult.PostVersion = result.PostVersion; newresult.EditVersion = result.EditVersion; newresult.RefOrder = result.RefOrder; newresult.InvoiceForm = result.InvoiceForm; newresult.InvoiceFormNumberId = result.InvoiceFormNumber == null ? null : result.InvoiceFormNumber.InvoiceFormNumberID.ToString(); newresult.InvSeriesPrefix = result.InvSeriesPrefix; newresult.InvSeriesSuffix = result.InvSeriesSuffix; newresult.PayForm = result.PayForm; newresult.ComPanyTaxcode = result.ComPanyTaxcode; newresult.AccountingObjectContactName = result.AccountingObjectContactName; newresult.ListNo = result.ListNo; newresult.ListDate = result.ListDate; newresult.IsAttachList = result.IsAttachList; newresult.ListCommonNameInventory = result.ListCommonNameInventory; newresult.BUCommitmentRequestId = result.BUCommitmentRequestID.ToString(); newresult.TotalReceiptAmount = result.TotalReceiptAmount; newresult.BADepositDetails = result.BADepositDetails.Count <= 0 ? null : BADepositDetails(result.BADepositDetails.ToList(), result.RefID.ToString()); newresult.BADepositDetailParallels = result.BADepositDetailParallels.Count <= 0 ? null : BADepositDetailParallels(result.BADepositDetailParallels.ToList(), result.RefID.ToString()); newresult.BADepositDetailFixedAssetEntities = result.BADepositDetailFixedAssets.Count <= 0 ? null : BADepositDetailFixedAssets(result.BADepositDetailFixedAssets.ToList(), result.RefID.ToString()); newresult.BADepositDetailSaleEntities = result.BADepositDetailSales.Count <= 0 ? null : BADepositDetailSales(result.BADepositDetailSales.ToList(), result.RefID.ToString()); newresult.BADepositDetailTaxEntities = result.BADepositDetailTaxes.Count <= 0 ? null : BADepositDetailTaxes(result.BADepositDetailTaxes.ToList(), result.RefID.ToString()); buentity.Add(newresult); } } return(buentity); }
/// <summary> /// Updates the bADeposit. /// </summary> /// <param name="bADeposit">The bADeposit.</param> /// <returns> /// System.String. /// </returns> /// <exception cref="NotImplementedException"></exception> public string UpdateBADeposit(BADepositEntity bADeposit) { const string sql = @"uspUpdate_BADeposit"; return(Db.Update(sql, true, Take(bADeposit))); }
/// <summary> /// Inserts the bADeposit. /// </summary> /// <param name="bADeposit">The bADeposit.</param> /// <returns> /// System.Int32. /// </returns> /// <exception cref="NotImplementedException"></exception> public string InsertBADeposit(BADepositEntity bADeposit) { const string sql = @"uspInsert_BADeposit"; return(Db.Insert(sql, true, Take(bADeposit))); }