public void DeleteBrand(int id)
{
try
{
Table <Brand> brands = data.GetTable <Brand>();
var br = (from b in brands
where b.ID == id
select b).FirstOrDefault();
brands.DeleteOnSubmit(br);
data.SubmitChanges();
}
catch
{
throw new Exception();
}
}
public void InsertBill(Bill bill, Hashtable billdetail)
{
data.Bills.InsertOnSubmit(bill);
data.SubmitChanges();
IEnumerator ie = billdetail.Keys.GetEnumerator();
while (ie.MoveNext())
{
BillDetail bd = new BillDetail();
Object obj = ie.Current;
bd.IDBill = bill.ID;
bd.IDProduct = (int)obj;
bd.Number = (int)billdetail[obj];
bd.Price = 0;
data.BillDetails.InsertOnSubmit(bd);
}
data.SubmitChanges();
}
