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