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