public IActionResult Addition(string sortOrder, OrderCreateViewModel check, int Bolla, int Bolla2, string Bolla3, List <string> minidef, List <string> maxidef) { if (User.IsInRole("User")) { ExamplContext bd = new ExamplContext(); PhotouContext bd1 = new PhotouContext(); ViewBag.Defect = from s in db.Defects select s; ViewBag.Years = (from s in bd.Stagio orderby s.Expr1 descending select s); string TaskNum = Bolla.ToString() + "/" + Bolla2.ToString(); var ord = (from s in db.Checks where s.TaskNum == TaskNum && s.Stagione == Bolla3 select s).FirstOrDefault(); ViewBag.hist = (from s in db.Histories where s.TaskNum == TaskNum && s.Year == Bolla3 select s).FirstOrDefault(); ViewBag.ord = ord; if (ord != null) { HttpContext.Session.SetString("Status", ord.Status); HttpContext.Session.SetString("Id", ord.Id.ToString()); } if (check.Articolo != null) { string uniqueFileName = null; SqlConnection conn1 = new SqlConnection("Data Source=192.168.204.41\\Bucket;Initial Catalog=UA_Stage;Persist Security Info=True;User ID=swstage;Password=@UAStage2019."); SqlCommand cmd1 = new SqlCommand(); cmd1.Connection = conn1; conn1.Open(); cmd1.CommandType = CommandType.Text; cmd1.CommandText = $"SELECT MAX(Id) FROM [dbo].[checks]"; object reader = cmd1.ExecuteScalar(); FileInfo file; MagickImage image; string sthj = check.Date.ToString(); ImageOptimizer optimizer = new ImageOptimizer(); conn1.Close(); Check newCheck = new Check { Date = check.Date, Articolo = check.Articolo, Color = check.Color, TaskNum = check.TaskNum, Client = check.Client, Total = check.Total, Selection = check.Selection, Machine = check.Machine, UserId = User.Identity.Name.ToString(), Status = "d", Date_user = DateTime.Now, Stagione = check.Stagione, Linea = check.Linea, Fustella = check.Fustella }; History history = new History(); var status = HttpContext.Session.GetString("Status"); var idslav = HttpContext.Session.GetString("Id"); if (check.CanGo) { newCheck.Status = "b"; newCheck.Defect = '-'; } else { newCheck.Defect = '+'; } if (status != null && status == "c") { history.Date = DateTime.Now; history.Status = "update"; history.Action = User.Identity.Name + " " + "updated " + check.TaskNum + " check"; history.TaskNum = check.TaskNum; history.Wuser = User.Identity.Name; db.Histories.Add(history); newCheck.Status = "d"; (from i in db.Checks where i.Id.ToString() == idslav select i).ToList() .ForEach(x => x.Status = newCheck.Status); (from i in db.Checks where i.Id.ToString() == idslav select i).ToList() .ForEach(x => x.MinDef = newCheck.MinDef); (from i in db.Checks where i.Id.ToString() == idslav select i).ToList() .ForEach(x => x.MaxDef = newCheck.MaxDef); db.SaveChanges(); } else { history.Date = DateTime.Now; history.Status = "add"; history.Action = User.Identity.Name + " " + "added " + check.TaskNum + " check"; history.TaskNum = check.TaskNum; history.Wuser = User.Identity.Name; db.Histories.Add(history); db.Checks.Add(newCheck); } var id = 0; db.SaveChanges(); int idLast = (from s in db.Checks orderby s.Id descending select s.Id).FirstOrDefault(); /*Defect block*/ if (minidef != null) { for (int i = 0; i < minidef.Count; i++) { DefId defio = new DefId(); String[] ArrSplit = minidef[i].Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries); defio.DefectId = Convert.ToInt32(ArrSplit[0].Replace(".", "")); for (int j = 1; j < ArrSplit.Length; j++) { defio.Comment += ArrSplit[j] + " "; } defio.Def = "min"; defio.IdCheck = idLast; db.Add(defio); } db.SaveChanges(); } if (maxidef != null) { for (int i = 0; i < maxidef.Count; i++) { DefId defio = new DefId(); String[] ArrSplit = maxidef[i].Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries); defio.DefectId = Convert.ToInt32(ArrSplit[0].Replace(".", "")); for (int j = 1; j < ArrSplit.Length; j++) { defio.Comment += ArrSplit[j] + " "; } defio.Def = "max"; defio.IdCheck = idLast; db.Add(defio); } db.SaveChanges(); } /*Photo block*/ if (check.Photo != null && check.Photo.Count > 0) { foreach (IFormFile photos in check.Photo) { User photo = new User(); string uploadsFolder = Path.Combine(hostingEnvironment.WebRootPath, "images"); uniqueFileName = Guid.NewGuid().ToString() + "_" + photos.FileName; string filePath = Path.Combine(uploadsFolder, uniqueFileName); using (var copy = new FileStream(filePath, FileMode.Create)) { photos.CopyTo(copy); } using (image = new MagickImage(filePath)) { image.Quality = 75; image.Resize(1920, 1080); image.Format = MagickFormat.Jpeg; image.Write(filePath); } photo.Id = idLast; photo.Name = uniqueFileName; db.Users.Add(photo); db.SaveChanges(); } } return(RedirectToAction("Addition", "Home")); } var colors = from u in bd.Colori select u; var slavik = (from k in bd.News where k.Numord == Bolla && k.Rigord == Bolla2 && k.Codsta.ToString().Contains(Bolla3) && k.Fase == "CONF" select k).FirstOrDefault(); var slavik2 = (from i in bd.Colori join k in bd.News on i.Valore equals k.Colore where k.Numord == Bolla && k.Rigord == Bolla2 && k.Fase == "CONF" select i).FirstOrDefault(); var slavik3 = (from i in bd.Clients join k in bd.News on i.Codclf equals k.Codsot where k.Numord == Bolla && k.Rigord == Bolla2 && k.Fase == "CONF" select i).FirstOrDefault(); ViewBag.History = (from i in db.Histories orderby i.Date descending select i).Take(20); ViewBag.Machine = from i in bd.Repartis where i.Jrres == slavik.Reparto select i; ViewBag.HistoryNum = from i in db.Histories where i.TaskNum == TaskNum && (i.Status == "decline" || i.Status == "accept" || i.Status == "update") select i; ViewBag.Slavik = slavik; if (slavik != null) { ViewBag.Ispe = Math.Round((decimal)ViewBag.Slavik.QtaOrd / 10); } ViewBag.Client = slavik3; //var colors = from u in bd.Colori where u.Valore==check.Color select u; var color = from u in bd.Colori select u; ViewBag.Color = slavik2; ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : ""; ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date"; ViewBag.Bolla = Bolla; return(View()); } else { return(RedirectToAction("Login", "Account")); } }
public IActionResult Watch(string sortOrder, bool accepted, bool declined, bool accepted_u, bool not, string year) { ExamplContext bd = new ExamplContext(); ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : ""; ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date"; var orders = from s in db.Checks where s.Stagione.Contains(year) select s; var stagio = from s in bd.Stagio orderby s.Expr1 descending select s.Expr1; SelectList years = new SelectList(stagio); ViewBag.Years = years; if (accepted && !declined && !not && !accepted_u) { orders = orders.Where(s => s.Status.Contains("a")); } if (!accepted && declined && !not && !accepted_u) { orders = orders.Where(s => s.Status.Contains("c")); } if (!accepted && !declined && !not && accepted_u) { orders = orders.Where(s => s.Status.Contains("b")); } if ((!accepted && !declined && not && !accepted_u)) { orders = orders.Where(s => s.Status.Contains("d")); } if (accepted && accepted_u && !declined && !not) { orders = orders.Where(s => s.Status.Contains("a") || s.Status.Contains("b")); } if (accepted && !accepted_u && declined && !not) { orders = orders.Where(s => s.Status.Contains("a") || s.Status.Contains("c")); } if (accepted && !accepted_u && !declined && not) { orders = orders.Where(s => s.Status.Contains("a") || s.Status.Contains("d")); } if (!accepted && accepted_u && declined && !not) { orders = orders.Where(s => s.Status.Contains("b") || s.Status.Contains("c")); } if (!accepted && accepted_u && !declined && not) { orders = orders.Where(s => s.Status.Contains("b") || s.Status.Contains("d")); } if (!accepted && !accepted_u && declined && not) { orders = orders.Where(s => s.Status.Contains("c") || s.Status.Contains("d")); } if (accepted && accepted_u && declined && !not) { orders = orders.Where(s => s.Status.Contains("b") || s.Status.Contains("c") || s.Status.Contains("a")); } if (!accepted && accepted_u && declined && not) { orders = orders.Where(s => s.Status.Contains("b") || s.Status.Contains("c") || s.Status.Contains("d")); } if (accepted && !accepted_u && declined && not) { orders = orders.Where(s => s.Status.Contains("a") || s.Status.Contains("c") || s.Status.Contains("d")); } if (accepted && accepted_u && !declined && not) { orders = orders.Where(s => s.Status.Contains("b") || s.Status.Contains("d") || s.Status.Contains("a")); } if (accepted && accepted_u && declined && not) { orders = orders.Where(s => s.Status.Contains("b") || s.Status.Contains("c") || s.Status.Contains("a") || s.Status.Contains("d")); } switch (sortOrder) { case "name_desc": orders = orders.OrderByDescending(s => s.Client); break; case "Date": orders = orders.OrderBy(s => s.Date); break; case "date_desc": orders = orders.OrderByDescending(s => s.Date); break; default: orders = orders.OrderBy(s => s.Client); break; } orders = orders.OrderBy(s => s.Status); return(View(orders.ToList())); }