Exemple #1
0
        // delete selling bill
        public int deletesllingBill(int id, string s)
        {
            if (s == "no")
            {
                try
                {
                    Selling_Bill c = db.Selling_Bill.Find(id);
                    db.Selling_Bill.Remove(c);
                    db.SaveChanges();
                    return(1);
                }
                catch (Exception e)
                {
                    Console.Write(e.StackTrace);
                    return(0);
                }
            }
            else if (s == "yes")
            {
                try
                {
                    Selling_Bill c  = db.Selling_Bill.Find(id);
                    Customer     cu = db.Customers.Find(c.cust_id);

                    List <Dead_Products> dp = db.Dead_Products.Where(a => a.bill_id == c.bill_id).ToList();
                    if (dp.Count == 0)
                    {
                        cu.cust_balance -= c.total - c.bill_paid;
                        cust.updateCutomer(cu);
                        var li = db.Selling_Bill_Details.Where(a => a.bill_id == c.bill_id).ToList();
                        foreach (var i in li)
                        {
                            Product p = db.Products.Find(i.product_id);
                            p.product_quantity += i.product_quantity;
                        }
                        db.Selling_Bill.Remove(c);
                        db.SaveChanges();
                        return(1);
                    }
                    else
                    {
                        MessageBox.Show("هذه الفاتوره عليها مرتجعات ولا يمكن حذفها");
                        return(0);
                    }
                }
                catch (Exception e)
                {
                    Console.Write(e.StackTrace);
                    return(0);
                }
            }
            else
            {
                return(0);
            }
        }
Exemple #2
0
 public int updateSellingBil(Selling_Bill sb)
 {
     try
     {
         Selling_Bill b = db.Selling_Bill.Find(sb.bill_id);
         b.total = sb.total;
         db.SaveChanges();
         return(1);
     }
     catch
     {
         return(0);
     }
 }
        //create dead product
        public int createDeadProduct(DeadProductDto dead)
        {
            Dead_Products d = new Dead_Products();

            d.bill_id      = dead.sillingBillId;
            d.note         = dead.note;
            d.quantity     = dead.quntity;
            d.user_id      = user.getUserIdByName(dead.user_name.Trim());
            d.product_id   = pdal.getProductIdByName(dead.name.Trim());
            d.process_date = dead.processDate;
            Selling_Bill_Details billDetails = sdal.getBillDetailsByBillId(dead.sillingBillId, d.product_id);
            Selling_Bill         bil         = sdal.getSellingBillByid(dead.sillingBillId);
            Customer             cu          = cdal.getCustomerById(bil.cust_id);

            //to do edit bill and client balance
            try
            {
                // MessageBox.Show(bil.cust_id + " " + cu.cust_id);
                if (d.quantity <= billDetails.product_quantity)
                {
                    Product p = pdal.getProductById(dead.name.Trim());
                    p.product_quantity += dead.quntity;

                    billDetails.product_quantity -= dead.quntity;
                    // billDetails.product_price -= dead.quntity * p.product_price;
                    bil.total -= dead.quntity * (billDetails.product_price - billDetails.profuct_discount);

                    cu.cust_balance -= dead.quntity * (billDetails.product_price - billDetails.profuct_discount);
                    cdal.updateCutomer(cu);
                    sdal.updateSellingBil(bil);
                    sdal.updateSellingBillDetails(billDetails);
                    pdal.updateProduct(p);
                    db.Dead_Products.Add(d);
                    db.SaveChanges();
                    return(1);
                }
                else
                {
                    return(0);
                }
            }
            catch
            {
                return(0);
            }
        }
Exemple #4
0
        public int createSillingBill(List <Util.SillBillDetails> l, Selling_Bill s)
        {
            List <Selling_Bill_Details> li = new List <Selling_Bill_Details>();

            foreach (var i in l)
            {
                Selling_Bill_Details sbd = new Selling_Bill_Details();
                sbd.bill_id          = s.bill_id;
                sbd.product_id       = pdal.getProductIdByName(i.Product_name);
                sbd.product_quantity = i.Product_quent;
                sbd.profuct_discount = i.Product_dicound;
                sbd.product_price    = i.Product_price;

                li.Add(sbd);
            }

            return(sdal.createSillingBill(s, li));;
        }
Exemple #5
0
 //create new bill
 public int createSillingBill(Selling_Bill s, List <Selling_Bill_Details> li)
 {
     try {
         db.Selling_Bill.Add(s);
         var cu = db.Customers.Find(s.cust_id);
         cu.cust_balance += s.total - s.bill_paid;
         foreach (var i in li)
         {
             db.Selling_Bill_Details.Add(i);
             var pro = db.Products.First(a => a.product_id == i.product_id);
             pro.product_quantity -= i.product_quantity;
         }
         db.SaveChanges();
         return(1);
     } catch (Exception e)
     {
         Console.Write(e.StackTrace);
         return(0);
     }
 }