public IActionResult AddQuery() { firstappContext b = new firstappContext(); Queries d = new Queries(); var ProductName = HttpContext.Request.Form["pname"].ToString(); var CustomerName = HttpContext.Request.Form["cname"].ToString(); var ProductId = Convert.ToInt32((from s in b.Product where s.ProductName == ProductName select s.ProductId).FirstOrDefault()); var CustomerId = Convert.ToInt32((from s in b.Customer where s.CustomerName == CustomerName select s.CustomerId).FirstOrDefault()); var OrderId = Convert.ToInt32((from s in b.ProductOrder where s.ProductId == ProductId && s.CustomerId == CustomerId select s.OrderId).FirstOrDefault()); var query = HttpContext.Request.Form["query"].ToString(); if (OrderId != 0 && CustomerId != 0 && ProductId != 0) { d.Cquery = query; d.EmployeeId = 1; d.OrderId = OrderId; d.Qstatus = "Registered"; b.Add(d); b.SaveChanges(); ViewData["Message"] = "Query registered successfully"; } else { ViewData["Message"] = "Invalid details"; } return(View()); }
public IActionResult AddProduct() { Product p = new Product(); firstappContext c = new firstappContext(); p.ProductName = HttpContext.Request.Form["pname"].ToString(); p.Price = Convert.ToDouble(HttpContext.Request.Form["price"]); p.ProductDescription = HttpContext.Request.Form["Description"].ToString(); p.Category = HttpContext.Request.Form["Category"].ToString(); c.Add(p); c.SaveChanges(); return(View()); }
public IActionResult AddProduct() { Product p = new Product(); firstappContext c = new firstappContext(); string pname = HttpContext.Request.Form["pname"].ToString(); p.ProductName = HttpContext.Request.Form["pname"].ToString(); p.Price = Convert.ToDouble(HttpContext.Request.Form["price"]); p.ProductDescription = HttpContext.Request.Form["Description"].ToString(); p.Category = HttpContext.Request.Form["Category"].ToString(); c.Add(p); c.SaveChanges(); Inventory d = new Inventory(); var Pid = Convert.ToInt32((from s in c.Product where s.ProductName == pname select s.ProductId).FirstOrDefault()); d.Quantity = 10; d.Stock = 1; d.ProductId = Pid; c.Add(d); c.SaveChanges(); return(View()); }
public IActionResult AddOrder() { Customer a = new Customer(); Product b = new Product(); ProductOrder c = new ProductOrder(); Bill e = new Bill(); Cart f = new Cart(); Delivery g = new Delivery(); string CustomerName = HttpContext.Request.Form["cname"].ToString(); string ProductName = HttpContext.Request.Form["pname"].ToString(); firstappContext d = new firstappContext(); var Customer_Id = Convert.ToInt32((from s in d.Customer where s.CustomerName == CustomerName select s.CustomerId).FirstOrDefault()); var Product_Id = Convert.ToInt32((from s in d.Product where s.ProductName == ProductName select s.ProductId).FirstOrDefault()); if (Customer_Id != 0 || Product_Id != 0) { c.CustomerId = Customer_Id; c.ProductId = Product_Id; c.OrderStatus = "Ordered"; string payment = HttpContext.Request.Form["payment"].ToString(); if (payment == "Online") { c.OrderPaymentStatus = "Paid Online"; d.Add(c); d.SaveChanges(); var OrderId = Convert.ToInt32((from s in d.ProductOrder orderby s.OrderId descending select s.OrderId).FirstOrDefault()); g.OrderId = OrderId; var Addres = Convert.ToInt32((from s in d.Address where s.CustomerId == Customer_Id select s.AddressId).FirstOrDefault()); g.AddressId = Addres; g.DeliveryStatus = "Dispatched"; g.PaymentStatus = "Paid"; g.EmployeeId = 1; d.Add(g); d.SaveChanges(); } else { c.OrderPaymentStatus = "To be paid during delivery"; d.Add(c); d.SaveChanges(); var OrderId = Convert.ToInt32((from s in d.ProductOrder orderby s.OrderId descending select s.OrderId).FirstOrDefault()); g.OrderId = OrderId; var Addres = Convert.ToInt32((from s in d.Address where s.CustomerId == Customer_Id select s.AddressId).FirstOrDefault()); g.AddressId = Addres; g.DeliveryStatus = "Dispatched"; g.PaymentStatus = "To be collected at site"; g.EmployeeId = 1; d.Add(g); d.SaveChanges(); } var Order_Id = Convert.ToInt32((from s in d.ProductOrder orderby s.OrderId descending select s.OrderId).FirstOrDefault()); f.OrderId = Order_Id; f.ProductId = Product_Id; d.Add(f); d.SaveChanges(); ViewData["Message"] = "Order successfully placed"; } else { ViewData["Message"] = "Invalid customer name or product name"; } return(View()); }