Esempio n. 1
0
        private static void insertSellingProductsInDatabase(List <productsaleorpurchaseviewmodel> saleList, int saleid)
        {
            var salepurchaseproducrepo = new productsalepurchaserepo();

            foreach (productsaleorpurchaseviewmodel item in saleList)
            {
                data.dapper.productsalepurchase saleItem = new data.dapper.productsalepurchase();
                saleItem.price    = item.price;
                saleItem.quantity = item.quantity;
                saleItem.total    = item.total;
                saleItem.fk_product_in_productsalepurchase            = item.id;
                saleItem.fk_financetransaction_in_productsalepurchase = saleid;
                salepurchaseproducrepo.save(saleItem);
            }
        }
Esempio n. 2
0
        public static void printDuplicateRecipt(int saleid)
        {
            var financetransactionrepo = new financetransactionrepo();
            var userrepo                = new userrepo();
            var productrepo             = new productrepo();
            var productsalepurchaserepo = new productsalepurchaserepo();
            var ft = financetransactionrepo.get(saleid);

            data.dapper.user customer = null;
            if (ft.fk_user_targetto_in_financetransaction != null)
            {
                customer = userrepo.get((int)ft.fk_user_targetto_in_financetransaction);
            }
            // var soldproducts = db.productsalepurchase.Where(a => a.fk_financetransaction_in_productsalepurchase == saleid).ToList();
            var soldproducts = productsalepurchaserepo.getmultiplebytransactionid(saleid);

            float totalbill = 0;
            var   salelist  = new List <productsaleorpurchaseviewmodel>();

            foreach (var item in soldproducts)
            {
                totalbill = totalbill + (float)(item.price * item.quantity);
                //var dbproduct = db.product.Find(item.fk_product_in_productsalepurchase);
                var dbproduct = productrepo.get((int)item.fk_product_in_productsalepurchase);

                var p = new productsaleorpurchaseviewmodel();
                p.id       = dbproduct.id;
                p.name     = dbproduct.name;
                p.price    = (double)item.price;
                p.quantity = (double)item.quantity;
                p.total    = (double)item.total;
            }
            ;

            //int salesId, List< ItemOrDealSaleModel > list, int totalBill,int remaining, int saleType,string customerAddress
            string customerAddress = "";

            if (customer != null)
            {
                customerAddress = customer.address + " " + customer.phone;
            }
            printing.printSaleReceipt(saleid, salelist, (int)totalbill, (int)totalbill, 0, false, customerAddress);
        }