private void ucPurchaseProduct_Loaded(object sender, RoutedEventArgs e) { if (CONTROLLER == null) { CONTROLLER = new HCSController(); } purchaseProduct = new purchaseproduct() { date= DateTime.Now , isenglishvisible=CONTROLLER.ISENGLISHVISIBLE,isurduvisible=CONTROLLER.ISURDUVISIBLE }; this.grdPurchaseProduct.DataContext = purchaseProduct; this.grdModel.DataContext = purchaseProduct; bindProducts(); bindSellerType(); bindPurchasers(); bindPurchaserType(); bindBank(); }
public void saveProductPurchased(purchaseproduct purchasedPorduct) { db.purchaseproducts.Add(purchasedPorduct); db.SaveChanges(); }
private void resetAfterSave() { purchaseProduct = new purchaseproduct() { date = DateTime.Now, isenglishvisible = CONTROLLER.ISENGLISHVISIBLE, isurduvisible = CONTROLLER.ISURDUVISIBLE }; this.grdPurchaseProduct.DataContext = purchaseProduct; }
public void saveSellerPayment(purchaseproduct payment) { payment.date = DateTime.Now; SellerTotalPayable sellerPayment = dbContext.SellerTotalPayables.Where(p => p.seller_cde== payment.seller_cde && p.sellerid==payment.sellerid).FirstOrDefault(); sellerPayment.totalpayable = payment.totalpayable; sellerPayment.totalreceivable += payment.totalreceivable; payment.totalreceivable = (int) sellerPayment.totalreceivable; var entry = dbContext.Entry<SellerTotalPayable>(sellerPayment); if (entry.State.Equals(EntityState.Detached)) { dbContext.SellerTotalPayables.Attach(sellerPayment); } entry.State = EntityState.Modified; dbContext.purchaseproducts.Add(payment); dbContext.SaveChanges(); }
public void saveProductPurchased(purchaseproduct purchasedPorduct) { #region commented handling sellertotal receivable table /* SellerTotalPayable totalPayables = dbContext.SellerTotalPayables.Where(p => p.sellerid == purchasedPorduct.sellerid).FirstOrDefault(); if (totalPayables != null) { if(totalPayables.totalreceivable>0) { if(totalPayables.totalreceivable>purchasedPorduct.payableprice) { totalPayables.totalreceivable -= (int)purchasedPorduct.payableprice; totalPayables.totalpayable = 0; purchasedPorduct.totalpayable = 0; purchasedPorduct.totalreceivable = (int) totalPayables.totalreceivable; } else { purchasedPorduct.totalpayable =purchasedPorduct.payableprice- totalPayables.totalreceivable; purchasedPorduct.totalreceivable = 0; totalPayables.totalreceivable = 0; totalPayables.totalpayable = purchasedPorduct.totalpayable; } } else { purchasedPorduct.totalpayable = totalPayables.totalpayable + purchasedPorduct.payableprice; totalPayables.totalpayable = purchasedPorduct.totalpayable; } var entry = dbContext.Entry<SellerTotalPayable>(totalPayables); if (entry.State.Equals(EntityState.Detached)) { dbContext.SellerTotalPayables.Attach(totalPayables); } entry.State = EntityState.Modified; } else { totalPayables = new SellerTotalPayable(); purchasedPorduct.totalpayable = purchasedPorduct.payableprice; totalPayables.seller_cde = purchasedPorduct.seller_cde; totalPayables.sellerid = purchasedPorduct.sellerid; totalPayables.totalpayable = purchasedPorduct.totalpayable; dbContext.SellerTotalPayables.Add(totalPayables); }*/ #endregion //saving in PurchaseProduct table dbContext.purchaseproducts.Add(purchasedPorduct); dbContext.SaveChanges(); #region Khata var result = from n in dbContext.Khatas where n.bpid == purchasedPorduct.purchaserid select n; //now putting entries in KHATA table for purchaser(e.g ans) khata Khata kh = new Khata() { entrycode = "p",//indicates purchaser record purchaseproductid = purchasedPorduct.seqid, saleproductid = 0, activitycode = ActivityType.Purchase.GetStringValue(), date = System.DateTime.Now, productid = purchasedPorduct.productid, bpid = purchasedPorduct.purchaserid, sellertypecode = purchasedPorduct.seller_cde, payable_naam = purchasedPorduct.price, receivable_jama = 0, purchasertypecode = purchasedPorduct.purchaser_cde, totalpayable_naam = (result != null && result.Count() > 0) ? result.Sum(p => p.payable_naam) + purchasedPorduct.price : purchasedPorduct.price, totalreceivable_jama = (result != null && result.Count() > 0) ? result.Sum(p => p.receivable_jama) : 0 }; dbContext.Khatas.Add(kh); //now putting entries in KHATA table for seller(e.g Kissaan) khata result = from n in dbContext.Khatas where n.bpid == purchasedPorduct.sellerid select n; kh = new Khata() { entrycode = "s",//indicates seller record purchaseproductid = purchasedPorduct.seqid, saleproductid = 0, activitycode = ActivityType.Purchase.GetStringValue(), date = System.DateTime.Now, productid = purchasedPorduct.productid, bpid = purchasedPorduct.sellerid, sellertypecode = purchasedPorduct.seller_cde, payable_naam = 0, receivable_jama = purchasedPorduct.payableprice, purchasertypecode = purchasedPorduct.purchaser_cde, totalpayable_naam = (result != null && result.Count() > 0) ? result.Sum(p => p.payable_naam) : 0, totalreceivable_jama = (result != null && result.Count() > 0) ? result.Sum(p => p.receivable_jama) + purchasedPorduct.payableprice : purchasedPorduct.payableprice }; dbContext.Khatas.Add(kh); #endregion #region Other Khata //Now adding in otherKhata table for labor commission etc. //here collecting information about labour khata so as to calculate previous values of naam and jama string khatatypecode = KhataType.Labour.GetStringValue(); var resultOtherKhata = from n in dbContext.OtherKhatas where n.khatatypecde == khatatypecode select n;//activity code indicates it is khata agains purchase if (purchasedPorduct.selectedProduct.producttype != ProductType.Cash.GetStringValue()&& purchasedPorduct.selectedProduct.producttype != ProductType.cheque.GetStringValue())//there will be no other khata in case of cash. { OtherKhata ok = new OtherKhata() { purchaseproductid = purchasedPorduct.seqid, saleproductid = 0, khatatypecde = KhataType.Labour.GetStringValue(), date = System.DateTime.Now, receivable_jama = purchasedPorduct.labour, payable_naam = 0, productname = purchasedPorduct.productname, weight = purchasedPorduct.totalweight, activitycode = ActivityType.Purchase.GetStringValue(), purchaserid = purchasedPorduct.purchaserid, sellerid = purchasedPorduct.sellerid, sellertypecode = purchasedPorduct.seller_cde, purchasertypecode = purchasedPorduct.purchaser_cde, totalpayable_naam = (resultOtherKhata!= null && resultOtherKhata.Count() > 0) ? resultOtherKhata.Sum(p => p.payable_naam) + purchasedPorduct.price : purchasedPorduct.price, totalreceivable_jama = (resultOtherKhata != null && resultOtherKhata.Count() > 0) ? resultOtherKhata.Sum(p => p.receivable_jama) : 0 }; dbContext.OtherKhatas.Add(ok); if (purchasedPorduct.seller_cde != "00002")//if purchasing from commission shop then no commission to be entered { //here collecting information about commission khata so as to calculate previous values of naam and jama khatatypecode = KhataType.Commission.GetStringValue(); resultOtherKhata = from n in dbContext.OtherKhatas where n.khatatypecde == khatatypecode select n;//activity code indicates it is khata agains purchase ok = new OtherKhata() { purchaseproductid = purchasedPorduct.seqid, saleproductid = 0, khatatypecde = KhataType.Commission.GetStringValue(), date = System.DateTime.Now, receivable_jama = purchasedPorduct.commissionamt, payable_naam = 0, productname = purchasedPorduct.productname, weight = purchasedPorduct.totalweight, activitycode = ActivityType.Purchase.GetStringValue(), purchaserid = purchasedPorduct.purchaserid, sellerid = purchasedPorduct.sellerid, sellertypecode = purchasedPorduct.seller_cde, purchasertypecode = purchasedPorduct.purchaser_cde, totalpayable_naam = (resultOtherKhata != null && resultOtherKhata.Count() > 0) ? resultOtherKhata.Sum(p => p.payable_naam) : 0, totalreceivable_jama = (resultOtherKhata != null && resultOtherKhata.Count() > 0) ? resultOtherKhata.Sum(p => p.receivable_jama) + purchasedPorduct.payableprice : purchasedPorduct.payableprice }; dbContext.OtherKhatas.Add(ok); } } #endregion dbContext.SaveChanges(); }
public winPurchaserReportViewer(purchaseproduct product,bool isurduvisible) { InitializeComponent(); m_isurduvisible = isurduvisible; ProductPurchased = product; }