public ActionResult SendforOrder(int Id) { DateTime reqTime = DateTime.Now; List <FavOrderDetails> fav = new List <FavOrderDetails>(); FavOrder fv = db.FavOrder.Find(Id); fav = db.FavOrderDetails.Where(x => x.FavOrderId == fv.FavOrderId).ToList(); Request request = new Request(); request.DeptId = fv.DeptId; request.RequestFormId = fv.FavFormId; request.StaffId = fv.StaffId; request.Status = "Pending"; request.ReqDate = reqTime; db.Request.Add(request); db.SaveChanges(); foreach (FavOrderDetails f in fav) { RequestDetail rd = new RequestDetail(); rd.ProductId = f.ProductId; rd.ReqQty = f.FavQty; rd.RequestId = request.RequestId; db.RequestDetail.Add(rd); } db.SaveChanges(); Request r = db.Request.Find(request.RequestId); r.RequestFormId = fv.DeptId + "/" + "R0" + r.RequestId + "-" + fv.Department.DeptName; db.SaveChanges(); return(RedirectToAction("OrderStatus", "Request")); }
public static void AddRequest(string products, string qty, int id, string nameId) { string[] productArr = products.Split(',').ToArray(); int[] qtyArr = qty.Split(',').Select(n => Convert.ToInt32(n)).ToArray(); using (LogicEntities db = new LogicEntities()) { string DeptId = db.DepartmentStaff.Where(x => x.StaffId == id).Select(x => x.DeptId).FirstOrDefault(); string DeptName = db.Department.Where(x => x.DeptId == DeptId).Select(x => x.DeptName).FirstOrDefault(); FavOrder request = new FavOrder(); request.StaffId = id; request.DeptId = DeptId; request.FavOrderName = nameId; db.FavOrder.Add(request); db.SaveChanges(); for (int i = 0; i < productArr.Length; i++) { string des = productArr[i]; string productId = db.Product.Where(x => x.Description == des).Select(x => x.ProductId).FirstOrDefault(); FavOrderDetails rd = new FavOrderDetails(); rd.ProductId = productId; rd.FavQty = qtyArr[i]; rd.FavOrderId = request.FavOrderId; db.FavOrderDetails.Add(rd); } db.SaveChanges(); FavOrder r = db.FavOrder.Find(request.FavOrderId); r.FavFormId = DeptId + "/" + "F0" + r.FavOrderId + "-" + DeptName; db.SaveChanges(); } }
public ActionResult DeleteFavOrder(string delete, int id) { FavOrder fv = db.FavOrder.Find(id); db.FavOrder.Remove(fv); db.SaveChanges(); return(RedirectToAction("ViewFaveOrder")); }