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