//delete buying bill
public int deleteBuyingBill(int id, string s)
{
if (s == "no")
{
try
{
Buying_Bill c = db.Buying_Bill.Find(id);
db.Buying_Bill.Remove(c);
db.SaveChanges();
return(1);
}
catch (Exception e)
{
Console.Write(e.StackTrace);
return(0);
}
}
else if (s == "yes")
{
try
{
Buying_Bill c = db.Buying_Bill.Find(id);
Vendor ven = db.Vendors.Find(c.vend_id);
ven.vend_balance -= (c.total - c.bill_paid);
// string sql = "select product_quantity , product_id from Buying_Bill_Details where bill_id = ' " + c.bill_id +" '";
var li = db.Buying_Bill_Details.Where(a => a.bill_id == c.bill_id).ToList();
foreach (var i in li)
{
Product p = db.Products.Find(i.product_id);
if (p.product_quantity >= i.product_quantity)
{
p.product_quantity -= i.product_quantity;
}
else
{
return(0);
}
}
db.Buying_Bill.Remove(c);
db.SaveChanges();
return(1);
}
catch (Exception e)
{
Console.Write(e.StackTrace);
return(0);
}
}
else
{
return(0);
}
}
public int createBuyingBill(List <Util.BuyingBillDetails> l, Buying_Bill b)
{
List <Buying_Bill_Details> li = new List <Buying_Bill_Details>();
foreach (var i in l)
{
Buying_Bill_Details sbd = new Buying_Bill_Details();
sbd.bill_id = b.bill_id;
sbd.product_id = pdal.getProductIdByName(i.Product_name);
sbd.product_quantity = i.Product_quent;
sbd.product_price = i.Product_price;
li.Add(sbd);
}
return(bdal.createBuyingBill(b, li));;
}
// DeadProdcutDal pdal = new DeadProdcutDal();
//create buying bill
public int createBuyingBill(Buying_Bill b, List <Buying_Bill_Details> li)
{
try
{
db.Buying_Bill.Add(b);
foreach (var i in li)
{
db.Buying_Bill_Details.Add(i);
var pro = db.Products.First(a => a.product_id == i.product_id);
pro.product_quantity += i.product_quantity;
}
var ve = db.Vendors.First(a => a.vend_id == b.vend_id);
ve.vend_balance += b.total - b.bill_paid;
db.SaveChanges();
return(1);
}
catch (Exception e)
{
Console.Write(e.StackTrace);
return(0);
}
}
