public ActionResult Order(int id, FormCollection collection) { try { OrderClass order = new OrderClass(); OrderTB otb = new OrderTB(); otb.UserId = Convert.ToInt32(collection["UserId"]); otb.Date = Convert.ToDateTime(collection["Date"]); otb.TotalAmount = Convert.ToInt64(collection["TotalAmount"]); objorder.InsertData(otb); objorder.save(); int latestid = otb.OrderId; OrderDetailTB odtb = new OrderDetailTB(); odtb.OrderId = latestid; odtb.ProductId = Convert.ToInt32(collection["pid"]); odtb.Qty = Convert.ToInt32(collection["Qty"]); odtb.Address = collection["Address"].ToString(); odtb.CountryId = Convert.ToInt32(collection["CountryId"]); odtb.StateId = Convert.ToInt32(collection["Sid"]); odtb.CityId = Convert.ToInt32(collection["Cid"]); objorderdetail.InsertData(odtb); objorderdetail.save(); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(orderentry NewOrder) { try { //var order = new OrderTB //{ // CustomerId = NewOrder.CustomerId, // Date = Convert.ToDateTime(NewOrder.Date), // TotalAmount=NewOrder.TotalAmount //}; //var orderdetail = new OrderDetailTB(); //using (var context = new ProductsDataContext()) //{ // context.OrderTBs.InsertOnSubmit(order); // orderdetail.OrderId = order.OrderId; // context.OrderDetailTBs.InsertOnSubmit(orderdetail); // //etc add your other classes // context.SubmitChanges(); //} // TODO: Add insert logic here OrderTB order = new OrderTB(); order.CustomerId = NewOrder.CustomerId; order.Date = Convert.ToDateTime(NewOrder.Date); order.TotalAmount = NewOrder.TotalAmount; objorder.OrderTBs.InsertOnSubmit(order); objorder.SubmitChanges(); int latestid = order.OrderId; OrderDetailTB odetail = new OrderDetailTB(); odetail.ProductId = NewOrder.ProductId; odetail.OrderId = latestid; odetail.Rate = NewOrder.Rate; odetail.Qty = NewOrder.Qty; objorder.OrderDetailTBs.InsertOnSubmit(odetail); objorder.SubmitChanges(); return(RedirectToAction("Index")); } catch (Exception ex) { return(View(ex.ToString())); } }
public ActionResult Search(OrderTB odetail) { string d1 = Request["date1"].ToString(); string d2 = Request["date2"].ToString(); if (d1.Equals(d2)) { Response.Write("Same Date"); } var q1 = from x in objorder.OrderTBs where x.Date >= Convert.ToDateTime(d1) && x.Date <= Convert.ToDateTime(d2) select x; return(View(q1.ToList())); }
public ActionResult GoBuy(FormCollection collection) { UserTB user = new UserTB(); user.Address = collection["Address"]; user.ContactNo = collection["ContactNo"]; dc.UserTBs.InsertOnSubmit(user); dc.SubmitChanges(); var uid = int.Parse(Session["userid"].ToString()); var cdata = /* from x in dc.CartTBs where x.UserId == uid select x;*/ dc.CartTBs.Where(o => o.UserId == uid).ToList(); OrderTB otb = new OrderTB(); otb.UserId = uid; otb.OrderDate = DateTime.Now; otb.GrandTotal = Convert.ToDecimal(collection["Total"]); dc.OrderTBs.InsertOnSubmit(otb); dc.SubmitChanges(); int oid = otb.OrderId; foreach (var d in cdata) { OrderDetailTB odetail = new OrderDetailTB(); odetail.OrderId = oid; odetail.ProductId = d.ProductId; odetail.Qty = d.Qty; odetail.Price = d.Price; dc.OrderDetailTBs.InsertOnSubmit(odetail); dc.SubmitChanges(); } foreach (var s in cdata) { dc.CartTBs.DeleteOnSubmit((from m in dc.CartTBs where m.UserId == uid select m).FirstOrDefault()); dc.SubmitChanges(); } return(RedirectToAction("Index")); }