public int updateSellingBillDetails(Selling_Bill_Details sbd)
{
try
{
Selling_Bill_Details bd = db.Selling_Bill_Details.Find(sbd.bill_id, sbd.product_id);
bd.product_quantity = sbd.product_quantity;
bd.product_price = sbd.product_price;
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);
}
}
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));;
}
