public ActionResult DeleteConfirmed(int id)
{
assigment assigment = db.assigment.Find(id);
db.assigment.Remove(assigment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET api/lastcosts/5
public string Get(int id)
{
//данные с апи
LastCostsController lastCostsController = new LastCostsController();
requestLastCost requestLastCost = JsonConvert.DeserializeObject <requestLastCost>(lastCostsController.Get(id));
string lastcost = requestLastCost.lastCost;
string wearrate = requestLastCost.wearrate.ToString();
//OS
OS oS = db.OS.Find(id);
string os_name = oS.os_name;
string class1 = oS.id_class.ToString() + ", " + db.group.Find(oS.id_class).classname;
string invertory_number = oS.invertory_number.ToString();
string service_start = oS.service_start.ToString();
service_start = service_start.Substring(0, 10);
string service_time = oS.service_time.ToString();
List <pin> pinList = db.pin.Where(p => p.id_os == id).OrderBy(p => p.date).ToList();
string mol = "";
string pin_date = "";
string unit = "";
if (pinList.Count == 0)
{
mol = "не прикреплено";
pin_date = "не прикреплено";
unit = "не прикреплено";
}
else
{
pin pin1 = pinList[pinList.Count - 1];
mol = pin1.id_mol.ToString() + ", " + db.MOL.Find(pin1.id_mol).molname;
pin_date = pin1.date.ToString();
pin_date = pin_date.Substring(0, 10);
List <assigment> assigmentList = db.assigment.Where(a => a.id_mol == pin1.id_mol).ToList();
if (assigmentList.Count == 0)
{
unit = "МОЛ не назначен в отдел";
}
else
{
assigment assigment1 = assigmentList[assigmentList.Count - 1];
unit = assigment1.id_unit.ToString() + ", " + db.unit.Find(assigment1.id_unit).unitname;
}
}
string json = JsonConvert.SerializeObject(new requestCardOS {
wearrate = wearrate, lastcost = lastcost, os_name = os_name,
class1 = class1, invertory_number = invertory_number, service_start = service_start, service_time = service_time,
unit = unit, pin_date = pin_date, mol = mol
});
return(json);
}
public ActionResult Edit([Bind(Include = "id_assignment,id_mol,id_unit,arrivaldateunit")] assigment assigment)
{
if (ModelState.IsValid)
{
db.Entry(assigment).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.id_mol = new SelectList(db.MOL, "id_mol", "molname", assigment.id_mol);
ViewBag.id_unit = new SelectList(db.unit, "id_unit", "unitname", assigment.id_unit);
return(View(assigment));
}
// GET: assigments/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
assigment assigment = db.assigment.Find(id);
if (assigment == null)
{
return(HttpNotFound());
}
return(View(assigment));
}
public ActionResult Create([Bind(Include = "id_assignment,id_mol,id_unit,arrivaldateunit")] assigment assigment)
{
if (ModelState.IsValid)
{
db.assigment.Add(assigment);
db.SaveChanges();
if (TempData["HomePage"].Equals("/Functions"))
{
return(RedirectToAction("Functions", "Home"));
}
return(RedirectToAction("Index"));
}
if (TempData["HomePage"].Equals("/Functions"))
{
ViewBag.HomePage = TempData["HomePage"];
}
SelectList s = new SelectList(db.MOL, "id_mol", "molname");
List <SelectListItem> sl = s.ToList();
List <MOL> sd = db.MOL.ToList();//класс
for (int i = 0; i < sl.Count; i++)
{
sl[i].Text = sd[i].id_mol.ToString() + ", " + sd[i].molname.ToString();//поля
}
ViewBag.id_mol = sl;
SelectList ss = new SelectList(db.unit, "id_unit", "unitname");
List <SelectListItem> ssl = ss.ToList();
List <unit> ssd = db.unit.ToList();//класс
for (int i = 0; i < ssl.Count; i++)
{
ssl[i].Text = ssd[i].id_unit.ToString() + ", " + ssd[i].unitname.ToString();//поля
}
ViewBag.id_unit = ssl;
return(View(assigment));
}
// GET: assigments/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
assigment assigment = db.assigment.Find(id);
if (assigment == null)
{
return(HttpNotFound());
}
SelectList s = new SelectList(db.MOL, "id_mol", "molname");
List <SelectListItem> sl = s.ToList();
List <MOL> sd = db.MOL.ToList();//класс
for (int i = 0; i < sl.Count; i++)
{
sl[i].Text = sd[i].id_mol.ToString() + ", " + sd[i].molname.ToString();//поля
}
ViewBag.id_mol = sl;
SelectList ss = new SelectList(db.unit, "id_unit", "unitname");
List <SelectListItem> ssl = ss.ToList();
List <unit> ssd = db.unit.ToList();//класс
for (int i = 0; i < ssl.Count; i++)
{
ssl[i].Text = ssd[i].id_unit.ToString() + ", " + ssd[i].unitname.ToString();//поля
}
ViewBag.id_unit = ssl;
return(View(assigment));
}
