private void btnFilters_Click(object sender, EventArgs e) { Reports.Accountbooks.PurchaseRegister frmpurchaseregister = new PurchaseRegister(); frmpurchaseregister.StartPosition = FormStartPosition.CenterScreen; frmpurchaseregister.ShowDialog(this); //Reports.Accountbooks.Daybook frmdayBook = new Daybook(); //frmdayBook.ShowDialog(); //frmdayBook(this); }
private void tlistAccountbook_MouseDown(object sender, MouseEventArgs e) { DevExpress.XtraTreeList.TreeListHitInfo hi = tlistAccountbook.CalcHitInfo(e.Location); if (hi.HitInfoType == DevExpress.XtraTreeList.HitInfoType.Cell) { string selectedNode = hi.Node[Accountbooks].ToString(); switch (selectedNode) { case "Account Group Ledger": Reports.Accountbooks.AccountGroupLedger frmAccGrp = new Reports.Accountbooks.AccountGroupLedger(); frmAccGrp.StartPosition = FormStartPosition.CenterParent; frmAccGrp.ShowDialog(); break; case "Account Ledger": Reports.Accountbooks.AccountLedger frmAccLed = new Reports.Accountbooks.AccountLedger(); frmAccLed.ShowDialog(); break; case "Bank Book": Bankbook frmBook = new Bankbook(); frmBook.ShowDialog(); break; case "Cash Book Single": CashbookSingle frmCashbook = new CashbookSingle(); frmCashbook.ShowDialog(); break; case "Day Book": Daybook frmday = new Daybook(); frmday.ShowDialog(); break; case "Payment Register": PaymentRegister frmpay = new PaymentRegister(); frmpay.ShowDialog(); break; case "Purchase Register": PurchaseRegister frmpurc = new PurchaseRegister(); frmpurc.ShowDialog(); break; case "Purchase Return Register": PurchaseReturnRegister frmPurcre = new PurchaseReturnRegister(); frmPurcre.ShowDialog(); break; case "Receipt Register": RecepitRegister frmRece = new RecepitRegister(); frmRece.ShowDialog(); break; case "Sales Register": Saleregister frmsale = new Saleregister(); frmsale.ShowDialog(); break; case "Sales Return Register": SalesReturnRegister frmsaleret = new SalesReturnRegister(); frmsaleret.ShowDialog(); break; case "Sub Ledger": SubLedger frmsub = new SubLedger(); frmsub.ShowDialog(); break; default: break; } } //string selectedNode = (sender as TreeList).FocusedNode.GetValue(0).ToString(); }
private void UpdatePurchaseRegister(Invoice invoice, string company, string dbShip, DateTime fromDate, DateTime toDate) { try { using (var db = new eXmlContext()) { foreach (var invItem in invoice.Items) { var purRecExists = db.Set <PurchaseRegister>() .Where(x => x.Company == company && x.DbShip == dbShip) .Where(x => x.InvoiceNo == invoice.InvoiceNo) .Where(x => x.InvoiceType == invoice.InvoiceType) .Where(x => x.ItemCode == invItem.ItemCode) .Where(x => x.PaymentInstrument == invItem.PaymentInstrument) .Where(x => x.OrdYearWk == invoice.OrdYearWk && x.InvYearWk == invoice.InvYearWk) .FirstOrDefault(); if (purRecExists == null) { PurchaseRegister reg = new PurchaseRegister { Company = company, DbShip = dbShip, FromDate = fromDate, ToDate = toDate, ItemCode = invItem.ItemCode, PaymentInstrument = invItem.PaymentInstrument, ItemName = invItem.ItemName, OrdYearWk = invoice.OrdYearWk, InvoiceNo = invoice.InvoiceNo, InvoiceType = invoice.InvoiceType, InvoiceDate = invoice.InvoiceDate, InvYearWk = invoice.InvYearWk, Quantity = invItem.Quantity, PriceWOTax = invItem.PriceWOTax, VAT = invItem.VAT, PriceInclVAT = invItem.PriceInclVAT }; db.PurchaseRegister.Add(reg); } else { purRecExists.Company = company; purRecExists.DbShip = dbShip; purRecExists.FromDate = fromDate; purRecExists.ToDate = toDate; purRecExists.ItemCode = invItem.ItemCode; purRecExists.PaymentInstrument = invItem.PaymentInstrument; purRecExists.ItemName = invItem.ItemName; purRecExists.OrdYearWk = invoice.OrdYearWk; purRecExists.InvoiceNo = invoice.InvoiceNo; purRecExists.InvoiceType = invoice.InvoiceType; purRecExists.InvoiceDate = invoice.InvoiceDate; purRecExists.InvYearWk = invoice.InvYearWk; purRecExists.Quantity = invItem.Quantity; purRecExists.PriceWOTax = invItem.PriceWOTax; purRecExists.VAT = invItem.VAT; purRecExists.PriceInclVAT = invItem.PriceInclVAT; db.Entry(purRecExists).State = EntityState.Modified; } } db.SaveChanges(); } } catch (Exception ex) { throw new Exception(ex.Message); } }