public IInvoice MergeWithInvoiceNumber(ref InvoiceView invoiceView) { string invoiceNumber = invoiceView.InvoiceNumber; Task <Invoice> viewTask = Task.Run(() => unitOfWork.invoiceRepository.GetInvoiceByInvoiceNumber(invoiceNumber)); Task.WaitAll(viewTask); //TODO applicationFactory needs to have a merge feature created invoiceView.InvoiceId = viewTask.Result.InvoiceId; invoiceView.InvoiceNumber = viewTask.Result.InvoiceNumber; invoiceView.InvoiceDate = viewTask.Result.InvoiceDate; invoiceView.Amount = viewTask.Result.Amount; invoiceView.CustomerId = viewTask.Result.Customer.CustomerId; invoiceView.CustomerName = viewTask.Result.Customer.AddressBook.Name; invoiceView.Description = viewTask.Result.Description; invoiceView.TaxAmount = viewTask.Result.TaxAmount; invoiceView.PaymentDueDate = viewTask.Result.PaymentDueDate; invoiceView.DiscountAmount = viewTask.Result.DiscountAmount; invoiceView.PaymentTerms = viewTask.Result.PaymentTerms; invoiceView.CompanyId = viewTask.Result.Company.CompanyId; invoiceView.CompanyName = viewTask.Result.Company.CompanyName; invoiceView.CompanyStreet = viewTask.Result.Company.CompanyStreet; invoiceView.CompanyCity = viewTask.Result.Company.CompanyCity; invoiceView.CompanyZipcode = viewTask.Result.Company.CompanyZipcode; invoiceView.DiscountDueDate = viewTask.Result.DiscountDueDate; invoiceView.FreightCost = viewTask.Result.FreightCost; return(this as IInvoice); }
public ActionResult NuevaFactura(InvoiceView invoiceView) { var invoiceNumber = Request["Invoice.InvoiceNumber"]; var serie = Request["Invoice.Serie"]; invoiceView = Session["InvoiceView"] as InvoiceView; invoiceView.Invoice.InvoiceDate = util.SetDate(); invoiceView.Invoice.CreatedTime = util.SetTime(); invoiceView.Invoice.InvoiceNumber = invoiceNumber; invoiceView.Invoice.Serie = serie; _invoiceService.Create(invoiceView.Invoice); var idInvoice = _invoiceService.GetLastId(); foreach (ProductView item in invoiceView.ProductList) { InvoiceDetail invoiceDetail = new InvoiceDetail { InvoiceId = idInvoice, ProductId = item.Id, Price = item.Price, Qty = item.Quantity }; _invoiceDetailService.Create(invoiceDetail); var product = _productService.FindbyId(item.Id); product.Stock = product.Stock - item.Quantity; _productService.Update(product); } ViewData["success"] = "Factura agregada con exito"; Session.Clear(); return(RedirectToAction("Index", "Factura")); }
public override void LoadView() { View = new InvoiceView(this) { Invoice = Invoice.FromLocalId(Settings.Shared.CurrentInvoice), }; }
public async Task <IFluentCustomerLedger> CreateCustomerLedgerByInvoiceView(InvoiceView invoiceView) { Task <AccountReceivable> acctRecLookupTask = unitOfWork.accountReceivableRepository.GetEntityByPurchaseOrderId(invoiceView.PurchaseOrderId); Task <Customer> customerTask = unitOfWork.customerRepository.GetEntityById(invoiceView.CustomerId); Task.WaitAll(acctRecLookupTask, customerTask); Task <GeneralLedger> generalLedgerTask = unitOfWork.generalLedgerRepository.GetEntityByDocNumber(acctRecLookupTask.Result?.DocNumber, "OV"); Task.WaitAll(generalLedgerTask); CustomerLedger customerLedger = new CustomerLedger { CustomerId = invoiceView.CustomerId ?? 0, GeneralLedgerId = generalLedgerTask.Result?.GeneralLedgerId ?? 0, InvoiceId = invoiceView.InvoiceId ?? 0, AccountReceivableId = acctRecLookupTask.Result?.AccountReceivableId ?? 0, DocNumber = generalLedgerTask.Result?.DocNumber ?? 0, DocType = generalLedgerTask.Result?.DocType, Amount = invoiceView.Amount, Gldate = generalLedgerTask.Result?.Gldate, AccountId = generalLedgerTask.Result?.AccountId ?? 0, CreatedDate = DateTime.Now, AddressId = customerTask.Result.AddressId, Comment = generalLedgerTask.Result?.Comment, DebitAmount = generalLedgerTask.Result?.DebitAmount, CreditAmount = generalLedgerTask.Result?.CreditAmount, FiscalPeriod = generalLedgerTask.Result?.FiscalPeriod ?? 0, FiscalYear = generalLedgerTask.Result?.FiscalYear ?? 0, CheckNumber = generalLedgerTask.Result?.CheckNumber, CustomerLedgerNumber = (await unitOfWork.nextNumberRepository.GetNextNumber(TypeOfCustomerLedger.CustomerLedgerNumber.ToString())).NextNumberValue }; AddCustomerLedger(customerLedger); return(this as IFluentCustomerLedger); }
public async Task <IActionResult> PutInvoiceView(int id, InvoiceView invoiceView) { if (id != invoiceView.InvoiceId) { return(BadRequest()); } _context.Entry(invoiceView).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!InvoiceViewExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <InvoiceView> > PostInvoiceView(InvoiceView invoiceView) { _context.InvoiceView.Add(invoiceView); await _context.SaveChangesAsync(); return(CreatedAtAction("GetInvoiceView", new { id = invoiceView.InvoiceId }, invoiceView)); }
private void DgButton_Delete(object sender, RoutedEventArgs e) { try { InvoiceView row = (InvoiceView)dgInvoice.SelectedItem; if (row == null) { return; } if (MessageBox.Show(String.Format("Delete '{0}' ?", row.ProductName), "Confirm delete", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.Yes) == MessageBoxResult.No) { return; } viewInvoiceList.Remove(row); invoiceList.Remove(invoiceList.Where(x => x.StockItemId == row.StockItemId).Single()); if (invoiceList.Count == 0) { btnAdd.Visibility = Visibility.Hidden; } AddToDataGrid(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static Result GetInvoice(string invoiceGUID) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); InvoiceView invoice = db.InvoiceViews.SingleOrDefault <InvoiceView>(i => i.InvoiceGUID.ToString() == invoiceGUID && i.Status == (byte)Status.Actived); result.QueryResult = invoice; } catch (System.Data.SqlClient.SqlException se) { result.Error.Code = (se.Message.IndexOf("Timeout expired") >= 0) ? ErrorCode.SQL_QUERY_TIMEOUT : ErrorCode.INVALID_SQL_STATEMENT; result.Error.Description = se.ToString(); } catch (Exception e) { result.Error.Code = ErrorCode.UNKNOWN_ERROR; result.Error.Description = e.ToString(); } finally { if (db != null) { db.Dispose(); db = null; } } return(result); }
public ActionResult GetInvoiceListData(string startDate, string endDate) { List <InvoiceView> objInvoiceList = new List <InvoiceView>(); try { DataTable dt = objDbTrx.GetInvoiceViewDtl(startDate, endDate); if (dt.Rows.Count > 0) { for (int iCnt = 0; iCnt < dt.Rows.Count; iCnt++) { InvoiceView icc = new InvoiceView(); icc.InvoiceId = Convert.ToInt64(dt.Rows[iCnt]["InvoiceId"].ToString()); icc.InvoiceNo = Convert.ToString(dt.Rows[iCnt]["InvoiceNo"].ToString()); icc.InvoiceDate = Convert.ToDateTime(dt.Rows[iCnt]["InvoiceDate"].ToString()).ToString("dd-MMM-yyyy"); icc.Save_Status = (dt.Rows[iCnt]["Save_Status"].ToString() == "1" ? "Confirm" : "Draft"); icc.CategoryName = Convert.ToString(dt.Rows[iCnt]["CHALLAN_BOOK_CATEGORY"].ToString()); icc.UpdatedBy = Convert.ToString(dt.Rows[iCnt]["UPDATED_BY"].ToString()); icc.UpdatedTimeStamp = Convert.ToDateTime(dt.Rows[iCnt]["UPDATED_TS"].ToString()).ToString("dd-MMM-yyyy"); objInvoiceList.Add(icc); } } } catch (Exception ex) { objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress); } return(Json(objInvoiceList, JsonRequestBehavior.AllowGet)); // return View(); }
/// <summary> </summary> /// <param name="invoiceAdd">this is a test</param> /// <returns></returns> /// <remarks> /// /// /// </remarks> public async Task <IInvoiceView> InvoiceUpdate(IInvoiceUpdate invoiceUpdate) { try { var result = new InvoiceView(); using (var db = new InvoiceContext()) { if (db.Invoices.Any(w => w.InvoiceId == invoiceUpdate.InvoiceId)) { var invoice = db.Invoices.First(w => w.InvoiceId == invoiceUpdate.InvoiceId); invoice.CreatedDate = invoiceUpdate.CreatedDate; invoice.DueDate = invoiceUpdate.DueDate; invoice.EmailTo = invoiceUpdate.EmailTo; invoice.GrandTotal = invoiceUpdate.GrandTotal; invoice.InvoiceEmailed = invoiceUpdate.InvoiceEmailed; invoice.InvoiceNo = invoiceUpdate.InvoiceNo; invoice.OrderedBy = invoiceUpdate.OrderedBy; invoice.PaidAmount = invoiceUpdate.PaidAmount; invoice.PaidDate = invoiceUpdate.PaidDate; invoice.PaidTax = invoiceUpdate.PaidTax; invoice.PaymentDetails = invoiceUpdate.PaymentDetails; invoice.PurchaseOrderRef = invoiceUpdate.PurchaseOrderRef; invoice.SubTotal = invoiceUpdate.SubTotal; invoice.TaxTotal = invoiceUpdate.TaxTotal; invoice.TermsAndConditions = invoiceUpdate.TermsAndConditions; await db.SaveChangesAsync(); result.CreatedDate = invoice.CreatedDate; result.DueDate = invoice.DueDate; result.EmailTo = invoice.EmailTo; result.GrandTotal = invoice.GrandTotal; result.InvoiceEmailed = invoice.InvoiceEmailed; result.InvoiceId = invoice.InvoiceId; result.InvoiceNo = invoice.InvoiceNo; result.Notes = invoice.Notes; result.OrderedBy = invoice.OrderedBy; result.PaidAmount = invoice.PaidAmount; result.PaidDate = invoice.PaidDate; result.PaidTax = invoice.PaidTax; result.PaymentDetails = invoice.PaymentDetails; result.PurchaseOrderRef = invoice.PurchaseOrderRef; result.Status = (int)invoice.Status; result.SubTotal = invoice.SubTotal; result.Tax = invoice.TaxTotal; result.TermsAndConditions = invoice.TermsAndConditions; return(result); } } } catch (Exception e) { LogFactory.GetLogger().Log(LogLevel.Error, e); return(new InvoiceView() { __CQRSSuccessful = false, __CQRSErrorMessage = "Unable to create InvoiceView", __CQRSStatusCode = 500 }); } return(null); }
public IInvoiceDetail CreateInvoiceDetails(InvoiceView invoiceView) { Task <CreateProcessStatus> resultTask = Task.Run(() => unitOfWork.invoiceDetailRepository.CreateInvoiceDetailsByView(invoiceView)); Task.WaitAll(resultTask); processStatus = resultTask.Result; return(this as IInvoiceDetail); }
public IAccountsReceivable CreateAcctRecFromInvoice(InvoiceView invoiceView) { Task <CreateProcessStatus> resultTask = Task.Run(() => unitOfWork.accountReceiveableRepository.CreateAcctRecFromInvoice(invoiceView)); Task.WaitAll(resultTask); processStatus = resultTask.Result; return(this as IAccountsReceivable); }
public ActionResult Invoices() { InvoiceView source = new InvoiceView(); source.invoices = mng.Invoice.GetInvoices(); source.invoiceStatuses = mng.Invoice.GetStatuses(); source.contractor = mng.Contractor.GetContractors(); return(View(source)); }
public void InitDisplay() { // this.progressView.CloseDialog(); PosContext.Instance.KeysByControl.Clear(); //_container. OneLineView oneLine = _container.Resolve <OneLineView>(); _regionManager.Regions[Regions.OperatorPromptRegion].Add(oneLine); PosContext.Instance.PosPrompt = oneLine; // PosContext.Instance.Operprompt = oneLine; // LeftMenuView leftMenu = _container.Resolve<LeftMenuView>(PosContext.Instance.Parameters.getParam("HomeLeftPanelNo")); // _regionManager.Regions[Regions.LeftMenuRegion].Add(leftMenu, "ActiveView"); // leftMenu.LoadControls(); BottomMenuView bottomMenu = _container.Resolve <BottomMenuView>(); _regionManager.Regions[Regions.NavigatorRegion].Add(bottomMenu); bottomMenu.LoadControls(); InvoiceView invView = _container.Resolve <InvoiceView>(); _container.RegisterInstance <InvoiceView>(invView); PosContext.Instance.ReceiptDetails = invView; _regionManager.Regions[Regions.InvoiceRegion].Add(invView, "ActiveView"); InvoiceTotalView invTotalView = _container.Resolve <InvoiceTotalView>(); PosContext.Instance.ReceiptTotal = invTotalView; _container.RegisterInstance <InvoiceTotalView>("InvoiceTotalView", invTotalView); _regionManager.Regions[Regions.InvoiceTotalRegion].Add(invTotalView, "ActiveView"); //invTotalView.LoadControls(); KeyPadView keyPadView = _container.Resolve <KeyPadView>("KeyPadView"); _regionManager.Regions[Regions.KeyPadRegion].Add(keyPadView, "ActiveView"); keyPadView.LoadControls(); InvoiceHeaderView invHeaderView = _container.Resolve <InvoiceHeaderView>(); PosContext.Instance.ReceiptHeader = invHeaderView; _regionManager.Regions[Regions.InvoiceHeaderRegion].Add(invHeaderView); ItemGroupView itemGroupView = _container.Resolve <ItemGroupView>(); _regionManager.Regions[Regions.LeftMenuRegion].Add(itemGroupView, "ActiveView"); itemGroupView.AddPosKeys(1, "Item Groups"); PosContext.Instance.PosInit("Logon"); }
private void _buttonInspekteraUtgift_Click(object sender, RoutedEventArgs e) { _mainViewModel.InvoiceViewModel.Update(); var view = new InvoiceView { DataContext = _mainViewModel.InvoiceViewModel }; Navigate(view); }
private void btnAddToInvoiceList_Click(object sender, RoutedEventArgs e) { try { if (Convert.ToInt32(txtQuantity.Text) > Convert.ToInt32(txtAvailableQuantity.Text)) { MessageBox.Show("Quantity must be less than or equal to available quantity.", "", MessageBoxButton.OK, MessageBoxImage.Information); return; } if (txtProductName.Text.Length < 1) { MessageBox.Show("Please select a product.", "Incomplete Entry", MessageBoxButton.OK, MessageBoxImage.Information); return; } if (txtQuantity.Text.Length < 1) { MessageBox.Show("Please Enter the required field 'Quantity'", "Incomplete Entry", MessageBoxButton.OK, MessageBoxImage.Information); return; } //InvoiceItem objinvoiceItem = new InvoiceItem(); ////objinvoiceItem.StockItemId = product.Id; //objinvoiceItem.Qty = Convert.ToInt32(txtQuantity.Text); //objinvoiceItem.SellingPrice = Convert.ToInt32(txtPricePerUnit.Text); //objinvoiceItem.Tax = Convert.ToInt32(txtTax.Text); //objinvoiceItem.Discount = Convert.ToInt32(txtDiscount.Text); InvoiceView objviewInvoice = new InvoiceView(); objviewInvoice.StockItemId = tempstockItem.StockItemId; objviewInvoice.Qty = Convert.ToInt32(txtQuantity.Text); objviewInvoice.ProductName = txtProductName.Text; objviewInvoice.Origin = txtOrigin.Text; objviewInvoice.GenericName = txtGenericName.Text; objviewInvoice.SellingPrice = Convert.ToInt32(txtPricePerUnit.Text); objviewInvoice.Tax = Convert.ToInt32(txtTax.Text); objviewInvoice.Discount = Convert.ToInt32(txtDiscount.Text); InvoiceItem objinvoiceItem = new InvoiceItem(); objinvoiceItem.StockItemId = objviewInvoice.StockItemId; objinvoiceItem.Qty = objviewInvoice.Qty; objinvoiceItem.SellingPrice = objviewInvoice.SellingPrice; objinvoiceItem.Tax = objviewInvoice.Tax; objinvoiceItem.Discount = objviewInvoice.Discount; viewInvoiceList.Add(objviewInvoice); invoiceList.Add(objinvoiceItem); AddToDataGrid(); ClearFields(); btnAdd.Visibility = Visibility.Visible; btnDone.Visibility = Visibility.Hidden; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public async Task <InvoiceView> CreateInvoice(UpdateInvoice updateInvoice) { try { var result = new InvoiceView(); using (var db = new InvoiceContext()) { if (db.Invoices.Any(w => w.InvoiceId == updateInvoice.InvoiceId)) { var invoice = db.Invoices.First(w => w.InvoiceId == updateInvoice.InvoiceId); invoice.BillngAddress = updateInvoice.BillngAddress; invoice.CreatedDate = updateInvoice.CreatedDate; invoice.DueDate = updateInvoice.DueDate; invoice.EmailTo = updateInvoice.EmailTo; invoice.GrandTotal = updateInvoice.GrandTotal; invoice.InvoiceEmailed = updateInvoice.InvoiceEmailed; invoice.InvoiceNo = updateInvoice.InvoiceNo; invoice.OrderedBy = updateInvoice.OrderedBy; invoice.PaidAmount = updateInvoice.PaidAmount; invoice.PaidDate = updateInvoice.PaidDate; invoice.PaidTax = updateInvoice.PaidTax; invoice.PaymentDetails = updateInvoice.PaymentDetails; invoice.PurchaseOrderRef = updateInvoice.PurchaseOrderRef; invoice.ShippingAddress = updateInvoice.ShippingAddress; invoice.SubTotal = updateInvoice.SubTotal; invoice.Tax = updateInvoice.Tax; invoice.TermsAndConditions = updateInvoice.TermsAndConditions; await db.SaveChangesAsync(); result.CreatedDate = invoice.CreatedDate; result.DueDate = invoice.DueDate; result.EmailTo = invoice.EmailTo; result.GrandTotal = invoice.GrandTotal; result.InvoiceEmailed = invoice.InvoiceEmailed; result.InvoiceId = invoice.InvoiceId; result.InvoiceNo = invoice.InvoiceNo; result.OrderedBy = invoice.OrderedBy; result.PaidAmount = invoice.PaidAmount; result.PaidDate = invoice.PaidDate; result.PaidTax = invoice.PaidTax; result.PaymentDetails = invoice.PaymentDetails; result.PurchaseOrderRef = invoice.PurchaseOrderRef; result.SubTotal = invoice.SubTotal; result.Tax = invoice.Tax; result.TermsAndConditions = invoice.TermsAndConditions; return(result); } } } catch (Exception e) { LogFactory.GetLogger().Log(LogLevel.Error, e); } return(null); }
public void TestPostInvoiceAndDetailToAcctRec() { try { //NextNumber nextNumber = await unitOfWork.invoiceRepository.GetNextNumber("InvoiceNumber"); InvoiceView invoiceView = new InvoiceView(); invoiceView.InvoiceNumber = "Inv-03"; invoiceView.InvoiceDate = DateTime.Parse("8/10/2018"); invoiceView.Amount = 1500.0M; invoiceView.CustomerId = 9; invoiceView.Description = "VNW Fixed Asset project"; invoiceView.PaymentTerms = "Net 30"; invoiceView.TaxAmount = 0; invoiceView.CompanyId = 1; InvoiceDetailView invoiceDetailView = new InvoiceDetailView(); invoiceDetailView.Amount = 1500M; //invoiceDetailView.InvoiceId = invoice.InvoiceId; invoiceDetailView.UnitOfMeasure = "Project"; invoiceDetailView.Quantity = 1; invoiceDetailView.UnitPrice = 1500M; invoiceDetailView.Amount = 1500M; invoiceDetailView.DiscountPercent = 0; invoiceDetailView.DiscountAmount = 0; invoiceDetailView.ItemId = 4; invoiceView.InvoiceDetailViews.Add(invoiceDetailView); InvoiceModule invoiceModule = new InvoiceModule(); invoiceModule .Invoice.CreateInvoice(invoiceView).Apply() .MergeWithInvoiceNumber(ref invoiceView); invoiceModule .InvoiceDetail.CreateInvoiceDetails(invoiceView).Apply(); invoiceModule .AccountsReceivable.CreateAcctRecFromInvoice(invoiceView).Apply(); invoiceModule .GeneralLedger.CreateGeneralLedger(invoiceView).Apply().UpdateLedgerBalances(); //bool result=await invoiceModule.PostInvoiceAndDetailToAcctRec(invoiceView); Assert.True(true); } catch (Exception ex) { throw new Exception("TestPostInvoiceAndDetailToAcctRec", ex); } }
private void RemoveProductLineFromProductLinesList(InvoiceView invoiceView) { foreach (var productLine in ProductLinesList) { if (productLine.ProductLineId == invoiceView.InvoiceId) { ProductLinesList.Remove(productLine); break; } } }
private void RemoveDiscountFromDiscountsList(InvoiceView invoiceView) { foreach (var discount in TotalDiscountsList) { if (discount.DiscountId == invoiceView.InvoiceId) { TotalDiscountsList.Remove(discount); break; } } }
private static void RemoveInvoiceProductLine(InvoiceView invoiceView, Invoice ticket) { foreach (var invoiceProductLine in ticket.ProductLines) { if (invoiceProductLine.ProductLineId == invoiceView.InvoiceId) { ticket.ProductLines.Remove(invoiceProductLine); break; } } }
public ActionResult BuscarCliente(InvoiceView invoiceView) { invoiceView = Session["InvoiceView"] as InvoiceView; var customerId = int.Parse(Request["CustomerId"]); invoiceView.Customer = _customerService.FindbyId(customerId); var list = _customerService.GetAll().ToList(); ViewBag.CustomerId = new SelectList(list, "Id", "FullName"); return(View("NuevaFactura", invoiceView)); }
public async Task Cancel() { if (InvoiceView.InvoiceId > 0) { await Load(InvoiceView.InvoiceId); } else { InvoiceView = new InvoiceView(); } }
public InvoiceView SetAProductLine(IEnumerable <InvoiceView> join, ObservableCollection <InvoiceView> invoiceViewsList) { InvoiceView invoiceView = null; foreach (var invoiceViewToSearch in join) { invoiceView = invoiceViewToSearch; invoiceViewsList.Add(invoiceView); } return(invoiceView); }
public ActionResult NuevaFactura() { InvoiceView invoiceView = new InvoiceView(); invoiceView.Invoice = new Invoice(); invoiceView.Customer = new Customer(); invoiceView.ProductList = new List <ProductView>(); invoiceView.Invoice.InvoiceDate = util.SetDate(); Session["InvoiceView"] = invoiceView; return(View(invoiceView)); }
private static void CreateInvoice() { var invoiceViewModel = new InvoiceViewModel { Description = "Счет на оплату" }; var invoiceView = new InvoiceView(); invoiceViewModel.View = invoiceView; Workspace.This.Panels.Add(invoiceViewModel); Workspace.This.ActiveDocument = invoiceViewModel; }
/// <summary> /// Implements the execution of <see cref="BillPrintCommand" /> /// </summary> private void BillPrintCommand_Execute(object obj) { if (SelectedSaleVm.BevarageVms.Count > 0) { InvoiceView view = new InvoiceView(SelectedSaleVm); view.ShowDialog(); } else { MessageBox.Show("Nothing to write in bill"); } }
public async Task <CreateProcessStatus> CreateAcctRecFromInvoice(InvoiceView invoiceView) { try { Invoice invoice = await(from e in _dbContext.Invoices where e.InvoiceNumber == invoiceView.InvoiceNumber select e).FirstOrDefaultAsync <Invoice>(); if (invoice != null) { long?invoiceId = invoice.InvoiceId; var query = await(from a in _dbContext.AcctRecs where a.InvoiceId == invoice.InvoiceId select a).FirstOrDefaultAsync <AcctRec>(); if (query == null) { UDC udc = await base.GetUdc("ACCTRECDOCTYPE", "INV"); NextNumber nextNumber = await base.GetNextNumber("DocNumber"); ChartOfAcct chartOfAcct = await base.GetChartofAccount("1000", "1200", "120", ""); AcctRec acctRec = new AcctRec(); acctRec.InvoiceId = invoice.InvoiceId; acctRec.DiscountDueDate = invoice.DiscountDueDate; acctRec.GLDate = DateTime.Now.Date; acctRec.CreateDate = DateTime.Now.Date; acctRec.DocNumber = nextNumber.NextNumberValue; acctRec.Remarks = invoice.Description; acctRec.PaymentTerms = invoice.PaymentTerms; acctRec.CustomerId = invoice.CustomerId; //PurchaseOrderId acctRec.Description = invoice.Description; acctRec.AcctRecDocTypeXRefId = udc.XRefId; acctRec.AccountId = chartOfAcct.AccountId; acctRec.Amount = invoice.Amount; acctRec.OpenAmount = invoice.Amount; acctRec.DebitAmount = 0; acctRec.CreditAmount = invoice.Amount; AddObject(acctRec); return(CreateProcessStatus.Insert); } } return(CreateProcessStatus.AlreadyExists); } catch (Exception ex) { throw new Exception(GetMyMethodName(), ex); } }
//============================================================================== public InvoiceViewModel( AppRepository <KfsContext> aAppDbRepository, TDStransactionControl aTDStransactionControl) : base(aAppDbRepository, aTDStransactionControl) { _myView = new InvoiceView(); _myView.DataContext = this; Command_NavigatBack = new RelayCommand(NavigateBack); Command_ToMainMenu = new RelayCommand(NavigateToMainMenu); Command_Print = new RelayCommand(Print); //BrowserUri. = @"C:\Users\Tompie_HD2\source\repos\KFSolutions\KFSolutionsWPF\bin\Debug\accountancy\invoices\CV_dilenTom.pdf"; }
public async Task <IFluentGeneralLedger> CreateGeneralLedgerByInvoiceView(InvoiceView invoiceView) { try { AccountReceivable acctRec = await unitOfWork.accountReceivableRepository.GetEntityByPurchaseOrderId(invoiceView.PurchaseOrderId); if (acctRec != null) { GeneralLedger generalLedgerLookup = await unitOfWork.generalLedgerRepository.FindEntityByDocNumber(acctRec.DocNumber); if (generalLedgerLookup == null) { long addressId = await unitOfWork.addressBookRepository.GetAddressIdByCustomerId(acctRec.CustomerId); //Revenue Account ChartOfAccount chartOfAcct = await unitOfWork.chartOfAccountRepository.GetChartofAccount("1000", "1200", "250", ""); GeneralLedger ledger = new GeneralLedger(); ledger.DocNumber = acctRec.DocNumber ?? 0; ledger.DocType = "OV"; ledger.Amount = acctRec.Amount ?? 0; ledger.LedgerType = "AA"; ledger.Gldate = DateTime.Now.Date; ledger.FiscalPeriod = DateTime.Now.Date.Month; ledger.FiscalYear = DateTime.Now.Date.Year; ledger.AccountId = chartOfAcct.AccountId; ledger.CreatedDate = DateTime.Now.Date; ledger.AddressId = addressId; ledger.Comment = acctRec.Remark; ledger.DebitAmount = 0.0M; ledger.CreditAmount = acctRec.Amount ?? 0; ledger.GeneralLedgerNumber = (await unitOfWork.nextNumberRepository.GetNextNumber(TypeOfGeneralLedger.GeneralLedgerNumber.ToString())).NextNumberValue; AddGeneralLedger(ledger); return(this as IFluentGeneralLedger); } processStatus = CreateProcessStatus.AlreadyExists; return(this as IFluentGeneralLedger); } processStatus = CreateProcessStatus.Failed; return(this as IFluentGeneralLedger); } catch (Exception ex) { throw new Exception(GetMyMethodName(), ex); } }
public override void LoadView () { View = new InvoiceView (this) { Invoice = Invoice.FromLocalId (Settings.Shared.CurrentInvoice), }; }
public static List<InvoiceView> GetInvoiceForReport(int invoiceID) { InvoiceView invoice = null; List<InvoiceView> invoices = new List<InvoiceView>(); Invoice claimInvoice = null; Client client = null; LeadPolicy policy = null; Leads lead = null; ZipCodeMaster zipCodeMaster = null; //ClaimService mActivity = null; claimInvoice = (from x in DbContextHelper.DbContext .Invoice .Include("InvoiceDetail") .Include("InvoiceDetail.InvoiceServiceType") .Include("InvoiceDetail.InvoiceServiceType.InvoiceServiceUnit") .Include("Claim") .Include("Claim.LeadPolicy.Leads.Client") .Include("Claim.LeadPolicy.Leads.Client.StateMaster") .Include("Claim.LeadPolicy.Leads.Client.CityMaster") .Include("Claim.LeadPolicy") .Include("Claim.LeadPolicy.LeadPolicyType") .Include("Claim.ClaimService") where x.InvoiceID == invoiceID select x ).FirstOrDefault<Invoice>(); if (claimInvoice != null) { invoice = new InvoiceView(); invoice.invoiceID = claimInvoice.InvoiceID; invoice.invoiceDate = (DateTime)claimInvoice.InvoiceDate; invoice.dueDate = claimInvoice.DueDate == null ? DateTime.Now : (DateTime)claimInvoice.DueDate; invoice.invoiceNumber = (int)(claimInvoice.InvoiceNumber ?? 0); invoice.billTo = claimInvoice.BillToName; invoice.billToAddress1 = claimInvoice.BillToAddress1; invoice.billToAddress2 = claimInvoice.BillToAddress2; invoice.billToAddress3 = claimInvoice.BillToAddress3; invoice.totalAmount = claimInvoice.TotalAmount ?? 0; //invoice.activity = claimInvoice.Claim.ClaimService NEW OC 9/30/14 //invoice.adjusterInvoiceNumber = claimInvoice.AdjusterInvoiceNumber; // get policy type associated with invoice //claimInvoice.Lead.LeadPolicies.FirstOrDefault(x => x.PolicyType == claimInvoice.PolicyTypeID); //mActivity = claimInvoice.Claim.ClaimService.FirstOrDefault(); //invoice.activity = mActivity.Activity; policy = claimInvoice.Claim.LeadPolicy; if (policy != null) { invoice.policyType = policy.LeadPolicyType == null ? "" : policy.LeadPolicyType.Description; invoice.policyNumber = policy.PolicyNumber; lead = policy.Leads; } invoice.claimNumber = claimInvoice.Claim.AdjusterClaimNumber; invoice.insurerFileNo = claimInvoice.Claim.InsurerClaimNumber; invoice.adjusterInvoiceNumber = claimInvoice.InvoiceNumber.ToString(); if (lead != null) { invoice.claimantName = lead.InsuredName;//policyHolderName; OC 9/30/14 invoice.claimantAddress1 = lead.LossAddress; invoice.claimantAddress2 = lead.LossAddress2; invoice.claimantAddress3 = string.Format("{0}, {1} {2}", lead.CityName ?? "", lead.StateName ?? "", lead.Zip ?? ""); client = lead.Client; } invoice.taxRate = claimInvoice.TaxRate; if (claimInvoice.Claim.LossDate != null) invoice.claimDate = (DateTime)claimInvoice.Claim.LossDate; invoice.invoiceLines = claimInvoice.InvoiceDetail.ToList(); // add sales tax if (invoice.taxRate > 0) { InvoiceDetail invoiceTaxLine = new InvoiceDetail(); invoiceTaxLine.InvoiceID = invoice.invoiceID; invoiceTaxLine.LineDescription = "Sales Tax"; //invoiceTaxLine.isBillable = true; invoiceTaxLine.LineAmount = invoice.totalAmount * (invoice.taxRate / 100); invoiceTaxLine.Activity = invoice.activity; invoice.invoiceLines.Add(invoiceTaxLine); } if (client != null) { client = lead.Client; invoice.clientName = client.BusinessName; invoice.clientAddress1 = client.StreetAddress1; invoice.clientAddress2 = client.StreetAddress2; string stateName = client.StateMaster != null ? client.StateMaster.StateCode : ""; string cityName = client.CityMaster != null ? client.CityMaster.CityName : ""; string zipCode = client.ZipCode ?? ""; // this is badly designed. if (!string.IsNullOrEmpty(zipCode)) { zipCodeMaster = ZipCode.Get(zipCode); if (zipCodeMaster != null) zipCode = zipCodeMaster.ZipCode; } invoice.clientAddress3 = cityName + ", " + stateName + " " + zipCode; invoice.clientPhone = client.PrimaryPhoneNo; invoice.clientFax = client.SecondaryPhoneNo; invoice.clientEmail = client.PrimaryEmailId; invoice.federalIDNo = client.FederalIDNo; invoice.logoPath = string.Format("{0}/ClientLogo/{1}.jpg", ConfigurationManager.AppSettings["appURL"].ToString(), client.ClientId); } else { invoice.logoPath = ConfigurationManager.AppSettings["appURL"].ToString() + "/images/claim_ruler_logo.jpg"; invoice.clientName = "Claim Ruler Demo"; invoice.clientAddress1 = "400 East Las Olas Blvd"; invoice.clientAddress2 = "Suite 404"; invoice.clientAddress3 = "Ft. Lauderdale, FL 33301"; invoice.clientPhone = "999-999-9999"; invoice.clientFax = "999-999-9999"; invoice.clientEmail = "*****@*****.**"; invoice.federalIDNo = "99999999"; } invoices.Add(invoice); } return invoices; }