public void set5S(loggedInUser user, int id, string comment, string status) { var s5 = (from s in context.GetShift5S where s._5SDoneID == id select s).First(); s5.Performed = true; s5.PerformedBy = user.currShift.shift; s5.PerformedTime = DateTime.Now; s5.Comment = comment; s5.Status = status; context.SaveChanges(); }
/* Update the tasks done and todo from the user */ public void update5S(loggedInUser user) { if (user.maskin != "RVL") { int shift = rmvLast(user.selShift.shift); _5sDone = (from s in context.GetShift5S where s.Machine == user.maskin && s.PerformedBy == user.selShift.shift select s).AsEnumerable().Where(s => rmvLast(s.shift) <= shift && rmvLast(s.Duration) >= shift); _5sTodo = (from s in context.GetShift5S where s.Machine == user.maskin && s.Performed == false select s).AsEnumerable().Where(s => rmvLast(s.shift) <= shift && rmvLast(s.Duration) >= shift); numDone = _5sDone.Count(); numTodo = _5sTodo.Count(); if (user.currShift.shift != user.selShift.shift || user.userlevel == "gast") { submitClass = "btn btn-default disabled"; canSubmit = "disabled"; } else { submitClass = "btn btn-default"; canSubmit = ""; } } }
/* Get Data_uri, convert to image and save to disk */ public void saveImage(string id, string uri, loggedInUser user) { string hyperlink; uri = uri.Split(',')[1]; byte[] imageBytes = Convert.FromBase64String(uri); using (var ms = new MemoryStream(imageBytes, 0, imageBytes.Length)) { Image image = Image.FromStream(ms, true); string partLink = ""; switch (user.Machno) { case 1: partLink = links[0]; break; case 2: partLink = links[1]; break; case 3: partLink = links[2]; break; case 4: partLink = links[3]; break; case 5: partLink = links[4]; break; case 7: partLink = links[5]; break; case 9: partLink = links[8]; break; case 11: partLink = links[6]; break; case 12: partLink = links[7]; break; default: break; } hyperlink = "\\\\s0000291\\archive\\Function\\1-Produktion\\Produktionsteam\\" + partLink + "5S_Säkerhetsrond\\Bilder\\Felaktigheter\\IMG" + id + "_" + DateTime.Now.ToString("yyMMdd") + ".jpg"; try { image.Save(hyperlink, ImageFormat.Jpeg); } catch (Exception e) { user.errorText = "Error: Could not save Image"; } } int nId = int.Parse(id); var _5sTask = (from s in context.GetShift5S where s._5SDoneID == nId select s).First(); _5sTask.HyperLink = hyperlink; context.SaveChanges(); }
public MachineTargetFunctions(dbContext context, loggedInUser user) { this.context = context; this.user = user; prodShift = (from p in context.ProdShift where p.Machine == user.maskin && p.ShiftNo == user.selShift.shiftno select p).FirstOrDefault(); }
public void addValues(FormCollection form, loggedInUser user) { double minVal = double.Parse(form["minVal"]); double tarVal = double.Parse(form["targetVal"]); double maxVal = double.Parse(form["maxVal"]); string unit = form["unitVal"]; int artNo = int.Parse(form["artNo"]); int facingVal = int.Parse(form["facingVal"]); int matNo = int.Parse(form["matNo"]); int prodInStapleVal = int.Parse(form["prodInStapleVal"]); int staplesInBagVal = int.Parse(form["staplesInBagVal"]); int articleSizeVal = int.Parse(form["articleSizeVal"]); int numofDepVal = 0; string deviantValueText = form["actionsIfDeviantVal"]; int[] tempArray = new int[] { artNo, facingVal, matNo, prodInStapleVal, staplesInBagVal, articleSizeVal }; foreach (int num in tempArray) { if (num > 0) { numofDepVal++; } } string indexoredit = form["setValuesIndex"]; if (indexoredit != "editValue") { int index = int.Parse(indexoredit); int machSymbolicId = choosenSettingMachSettId.Skip(index).FirstOrDefault(); int DetailSettingId = (from s in context.SettingDetailProcess where s.MachSymbolicId == machSymbolicId select s.DetailSettingId).FirstOrDefault(); SettingValue settVal = new SettingValue() { DetailSettingID = DetailSettingId, MinValue = minVal, TargetValue = tarVal, MaxValue = maxVal, Unit = unit, ValidFrom = user.currShift.shiftno, ValidTo = 999999993, LastUpdatedBy = user.winuser, Deleted = 0, ArtNo = artNo, Facing = facingVal, MaterialNo = matNo, ProdsInStaple = prodInStapleVal, StaplesInBag = staplesInBagVal, ArticleSize = articleSizeVal, NumOfDependent = numofDepVal, ActionsIfDeviantValue = deviantValueText }; context.SettingValue.Add(settVal); } else { int settingID = int.Parse(form["settingID"]); SettingValue theSetting = (from s in context.SettingValue where s.SettingValuesID == settingID select s).FirstOrDefault(); theSetting.MinValue = minVal; theSetting.TargetValue = tarVal; theSetting.MaxValue = maxVal; theSetting.Unit = unit; theSetting.ValidFrom = user.currShift.shiftno; theSetting.ValidTo = 999999993; theSetting.LastUpdatedBy = user.winuser; theSetting.Deleted = 0; theSetting.ArtNo = artNo; theSetting.Facing = facingVal; theSetting.MaterialNo = matNo; theSetting.ProdsInStaple = prodInStapleVal; theSetting.StaplesInBag = staplesInBagVal; theSetting.ArticleSize = articleSizeVal; theSetting.NumOfDependent = numofDepVal; theSetting.ActionsIfDeviantValue = deviantValueText; } context.SaveChanges(); }