public IQueryable <OrderDetail> UpdateOrderDetail(int OrderId) { //String cartId = usersShoppingCart.GetCartId(); using (OrderActions MyOrderActions = new OrderActions()) { OrderActions.OrederDetailUpdates[] ODUpdates = new OrderActions.OrederDetailUpdates[OrderDetailList.Rows.Count]; for (int i = 0; i < OrderDetailList.Rows.Count; i++) { IOrderedDictionary rowValues = new OrderedDictionary(); rowValues = GetValues(OrderDetailList.Rows[i]); ODUpdates[i].ProductId = Convert.ToInt32(rowValues["ProductId"]); TextBox QtyShippedTextBox = new TextBox(); QtyShippedTextBox = (TextBox)OrderDetailList.Rows[i].FindControl("QtyShippedBx"); ODUpdates[i].QtyShipped = Convert.ToInt16(QtyShippedTextBox.Text.ToString()); TextBox QtyCancelledTextBox = new TextBox(); QtyCancelledTextBox = (TextBox)OrderDetailList.Rows[i].FindControl("QtyCancelledBx"); ODUpdates[i].QtyCancelled = Convert.ToInt16(QtyCancelledTextBox.Text.ToString()); TextBox CommentBox = new TextBox(); CommentBox = (TextBox)OrderDetailList.Rows[i].FindControl("CommentBx"); ODUpdates[i].Comment = CommentBox.Text.ToString(); } MyOrderActions.UpdateOrderDetailDatabase(OrderId, ODUpdates); OrderDetailList.DataBind(); return(MyOrderActions.GetOrderDetailsItems(OrderId)); } }
protected void btnShowReport_Click(object sender, EventArgs e) { try { OrderDetailList orderDetails = new OrderDetailList(); int intOrderId = Convert.ToInt32(txtOrderId.Text); orderDetails = orderDetails.GetByOrderId(intOrderId); dsInvoice ds = new dsInvoice(); foreach (OrderDetail od in orderDetails.List) { DataRow drOrderDetail = ds.dtInvoice.NewRow(); drOrderDetail["OrderId"] = od.OrderID; drOrderDetail["ProductName"] = od.ProductName; drOrderDetail["UnitPrice"] = od.UnitPrice; drOrderDetail["Quantity"] = od.Quantity; drOrderDetail["SubTotal"] = od.SubTotal; drOrderDetail["DiscountSubtotal"] = od.DiscountSubTotal; drOrderDetail["Discount"] = od.Discount; ds.dtInvoice.Rows.Add(drOrderDetail); } RenderReport(rvInvoice, "Invoice", "dsOrderDetails", "Invoice.rdlc", ds.dtInvoice); } catch (Exception ex) { //add a label } }
public ActionResult CheckCar() { /*string UserID = (Session["Member"] as Member).UserID; * var orderDetails = db.OrderDetail.Where(m => m.UserID == UserID && m.Approved_Flag == false).ToList(); * return View("CheckCar", "_LayoutMember", orderDetails);*/ string UserID = Session["Member"].ToString(); OrderDetailList detailList = new OrderDetailList(); detailList.OrderDetails = db.OrderDetail.Where(m => m.UserID == UserID && m.OrderID == null).ToList <OrderDetail>(); return(View("CheckCar", Session["UserTag"].ToString(), detailList)); }
protected void BindList2(int order_id) { DataTable dt = new DataTable(); conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Cafe"].ConnectionString); using (conn) { SqlDataAdapter ad = new SqlDataAdapter(string.Format("SELECT * FROM sum_orders_detail WHERE order_id = {0}", order_id), conn); ad.Fill(dt); } OrderDetailList.DataSource = dt; OrderDetailList.DataBind(); }
protected void OrderMasterList_ItemCommand(object source, DataListCommandEventArgs e) { HiddenField hf = (HiddenField)e.Item.FindControl("hfOrderID"); DataTable dt = new DataTable(); conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Cafe"].ConnectionString); using (conn) { SqlDataAdapter ad = new SqlDataAdapter(string.Format("SELECT * FROM sum_orders_detail WHERE order_id = {0}", hf.Value), conn); ad.Fill(dt); } OrderDetailList.DataSource = dt; OrderDetailList.DataBind(); }
public ActionResult CheckCar(OrderDetailList list) { string UserID = Session["Member"].ToString(); var orderDetails = db.OrderDetail.Where(m => m.UserID == UserID && m.Approved_Flag == false).ToList <OrderDetail>(); var selected = list.OrderDetails.ToList <OrderDetail>(); /*var q = from od in orderDetails * join s in selected on od.OrderDetailID equals s.OrderDetailID into check * select new * { * od.Approved_Flag * }; * foreach(var item in q) * { * item.Approved_Flag = true; * }*/ foreach (var item in selected) { var check = db.OrderDetail.Where(m => m.OrderDetailID == item.OrderDetailID).FirstOrDefault(); if (item.Approved_Flag == true) { check.Approved_Flag = true; } else if (item.Approved_Flag == false) { check.Approved_Flag = false; } } db.SaveChanges(); var orderDetailsNew = db.OrderDetail.Where(m => m.UserID == UserID && m.Approved_Flag == true && m.Delete_Flag != true && m.OrderID == null).ToList(); //return View("ShoppingCar", "_LayoutMember", orderDetailsNew); return(RedirectToAction("ShoppingCar", "Shopping_Car", orderDetailsNew)); }