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(); }