public void UpdateOrderDetails(OrderDetail orderDetail) { try { orderDetail.ModifiedTime = DateTime.Now; context.Entry(orderDetail).State = EntityState.Modified; SaveChanges(); } catch (OptimisticConcurrencyException ex) { throw ex; } }
public void InsertOrderDetails(OrderDetail orderDetail) { try { orderDetail.CreatedTime = DateTime.Now; orderDetail.ModifiedTime = DateTime.Now; //context.Entry(orderDetail).State = EntityState.Added; //context.SaveChanges(); context.Entry(orderDetail).State = orderDetail.OrderLineID == 0 ? EntityState.Added : EntityState.Modified; context.SaveChanges(); } catch (OptimisticConcurrencyException ex) { throw ex; } }
public void InsertOrderDetails(OrderDetail orderDetail) { orderRepository.InsertOrderDetails(orderDetail); }
public void UpdateOrderDetails(OrderDetail orderDetail) { orderRepository.UpdateOrderDetails(orderDetail); }
private void SaveOrderDetails() { int[] no = new int[OrderDetailsGridView.Rows.Count]; int i = 0; //long orderID = Convert.ToInt64(Session["OrderID"]); foreach (GridViewRow row in OrderDetailsGridView.Rows) { OrderDetail orderDetail = new OrderDetail(); long orderID = Convert.ToInt64(Session["OrderID"]); Label Name = row.FindControl("NameLabel") as Label; TextBox Quantity = row.FindControl("QuantityTextBox") as TextBox; TextBox CostPrice = row.FindControl("CostPriceTextBox") as TextBox; Label MftPartNum = row.FindControl("MftPartNumLabel") as Label; TextBox ListPrice = row.FindControl("ListPriceTextBox") as TextBox; TextBox Discount = row.FindControl("DiscountTextBox") as TextBox; TextBox Note = row.FindControl("NoteTextBox") as TextBox; Label ProductNo = row.FindControl("ProductIDLabel") as Label; Label OrderLineID = row.FindControl("OrderLineIDLabel") as Label; //hforderlineID.Value ="5"; if (OrderLineID.Text != "") { orderDetail.OrderLineID = Convert.ToInt64(OrderLineID.Text); } orderDetail.OrderID = orderID; orderDetail.Discount = Convert.ToInt64(Discount.Text); orderDetail.ProductID = Convert.ToInt64(ProductNo.Text); orderDetail.Cost = Convert.ToDecimal(CostPrice.Text); orderDetail.ListPrice = Convert.ToDecimal(ListPrice.Text); orderDetail.Quantity = Convert.ToInt32(Quantity.Text); if (Note.Text != "") { orderDetail.Note = Note.Text; } orderBL.InsertOrderDetails(orderDetail); } if (Session["DeleteProducts"] != null) { string deleted1 = Session["DeleteProducts"].ToString(); string del = deleted1.TrimEnd(','); string[] productdelete = del.Split(','); foreach (string orderLineId in productdelete) { //OrderDetail orderDetail = new OrderDetail(); //orderDetail.OrderLineID = Convert.ToInt64(deleteproduct); //orderDetail.IsDeleted = true; long orderLineID = Convert.ToInt64(orderLineId); orderBL.ProductRowDelete(orderLineID); } } }