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