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