public ActionResult SetApparat(int Id, string typeA) { int DC = MvcApplication.CurrentDC(); //var request = // (from s in db.Application // join pers in db.Person on s.BarcodePerson equals pers.BarcodePerson // join equip in db.Equipment on s.BarcodeEquipment equals equip.BarcodeEquipment // where (s.BarcodeEquipment==Id & s.SetUser == null) // select new ApplicationViewModel // { // BarcodePerson = s.BarcodePerson, // NamePerson = pers.NamePerson, // BarcodeEquipment = s.BarcodeEquipment, // NameEquipment = equip.NameEquipment, // SerialNumber = equip.SerialNumberEquipment, // GetTime = s.GetTime, // SetTime = s.SetTime, // GetUser = s.GetUser, // SetUser = s.SetUser, // Commment = s.Comment // }); App_ApplicationModels apparat = db.Application .Where(a => a.BarcodeEquipment == Id && a.SetTime == new DateTime(2017, 1, 1) && a.TypeEquipment == typeA && a.DC == DC).First(); return(View(apparat)); }
public ActionResult SetApparat(int id, int BarcodePersonSet, string Comment, string TypeEquipment) { App_ApplicationModels applicationSet = db.Application .Where(a => a.BarcodeEquipment == id && a.SetTime == new DateTime(2017, 1, 1) && a.TypeEquipment == TypeEquipment).First(); if (!ExistingPerson(BarcodePersonSet)) { ModelState.AddModelError("BarcodePersonSet", "Этого сотрудника нет в списке"); return(View(applicationSet)); } //Конвертация //if (convertTo(applicationSet.BarcodePersonSet) > 1) // applicationSet.BarcodePersonGet = convertTo(applicationSet.BarcodePersonGet); //else //{ // ModelState.AddModelError("BarcodePersonSet", "Ошибка сканирования"); // return View(applicationSet); //} try { if (ModelState.IsValid) { applicationSet.SetTime = DateTime.Now; applicationSet.BarcodePersonSet = BarcodePersonSet; applicationSet.UserSet = User.Identity.Name.ToString().Replace("HCLASS\\", ""); applicationSet.Comment = Comment; db.Entry(applicationSet).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } } catch (RetryLimitExceededException /* dex */) { //Log the error (uncomment dex variable name and add a line here to write a log.) ModelState.AddModelError("ModelError", "Невозможно сохранить. Попробуйте снова, если проблема повторится, напишите на Problems."); } return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "BarcodePersonGet,BarcodeEquipment,TypeEquipment,cbNew")] App_ApplicationModels applicationGet, bool cbNew) //public ActionResult Create(int barcodePerson,int barcodeEquipment) { if (!cbNew) { ModelState.AddModelError("BarcodeEquipment", "Проверьте, что оборудование рабочее"); return(View(applicationGet)); } //Кодирование! if (convertTo(applicationGet.BarcodePersonGet) > 1) { applicationGet.BarcodePersonGet = convertTo(applicationGet.BarcodePersonGet); } else { ModelState.AddModelError("BarcodePersonGet", "Ошибка сканирования"); return(View(applicationGet)); } if (!ExistingEquipment(applicationGet.BarcodeEquipment, applicationGet.TypeEquipment)) { ModelState.AddModelError("BarcodeEquipment", "Этого оборудование нет в списке"); return(View(applicationGet)); } if (!ExistingPerson(applicationGet.BarcodePersonGet)) { ModelState.AddModelError("BarcodePersonGet", "Этого сотрудника нет в списке"); return(View(applicationGet)); } if (ExistingApp(applicationGet.BarcodeEquipment, applicationGet.TypeEquipment)) { ModelState.AddModelError("BarcodeEquipment", "Это оборудование уже выдано"); return(View(applicationGet)); } //applicationGet.BarcodePersonSet = 2; int DC = MvcApplication.CurrentDC(); try { if (ModelState.IsValid) { applicationGet.GetTime = DateTime.Now; applicationGet.SetTime = new DateTime(2017, 1, 1); applicationGet.UserGet = User.Identity.Name.ToString().Replace("HCLASS\\", ""); applicationGet.DC = DC; //applicationGet.Person = new List<PersonModels>(); //applicationGet.Equipment = new List<EquipmentModels>(); //PersonModels person = db.Person.Where(p => p.BarcodePerson == applicationGet.BarcodePersonGet).First(); //applicationGet.Person.Add(person); //EquipmentModels equipment = db.Equipment.Where(e => e.BarcodeEquipment == applicationGet.BarcodeEquipment).First(); //applicationGet.Equipment.Add(equipment); //applicationGet.BarcodePersonSet = 0; db.Application.Add(applicationGet); db.SaveChanges(); return(RedirectToAction("Index")); } } catch (RetryLimitExceededException /* dex */) { //Log the error (uncomment dex variable name and add a line here to write a log.) ModelState.AddModelError("NotValid", "Невозможно сохранить. Попробуйте снова, если проблема повторится, напишите на Problems."); } return(View(applicationGet)); }