private void addSalesItem() { int salesId = (from s in dc.salesOrders select s.salesId).Max(); if (ViewState["CurrentTable"] != null) { DataTable dt = (DataTable)ViewState["CurrentTable"]; int count = dt.Rows.Count; for (int i = 0; i < count; i++) { salesItem si = new salesItem(); int proId = int.Parse(convertStrToId(dt.Rows[i][0].ToString())); si.salesId = salesId; si.productId = proId; si.quantity = int.Parse(dt.Rows[i][2].ToString()); si.unitPrice = (decimal)(double.Parse(dt.Rows[i][3].ToString())); si.totalPrice = (decimal)(double.Parse(dt.Rows[i][4].ToString())); dc.salesItems.InsertOnSubmit(si); try { dc.SubmitChanges(); } catch (DuplicateKeyException ex) { dc = new DataClasses1DataContext(); salesItem dup = (from sa in dc.salesItems where sa.salesId == salesId where sa.productId == proId select sa).Single(); dup.quantity += int.Parse(dt.Rows[i][2].ToString()); dup.totalPrice += (decimal)(double.Parse(dt.Rows[i][4].ToString())); } catch (Exception ex) { Console.WriteLine(ex); } } } }
private void addSalesItem() { int salesId = (from s in dc.salesOrders select s.salesId).Max(); int numItem = int.Parse(results["num_cart_items"]); for (int i = 0; i < numItem; i++) { salesItem si = new salesItem(); int key = i + 1; int proId = int.Parse(results["item_number" + key]); product pro = (from p in dc.products where p.productId == proId select p).Single(); si.salesId = salesId; si.productId = proId; si.quantity = int.Parse(results["quantity" + key]); si.unitPrice = pro.sellingPrice; si.totalPrice = pro.sellingPrice * si.quantity; dc.salesItems.InsertOnSubmit(si); try { dc.SubmitChanges(); } catch (DuplicateKeyException ex) { dc = new DataClasses1DataContext(); salesItem dup = (from sa in dc.salesItems where sa.salesId == salesId where sa.productId == proId select sa).Single(); dup.quantity += si.quantity; dup.totalPrice += si.totalPrice; } catch (Exception ex) { Console.WriteLine(ex); } } }