public ActionResult DeleteConfirmed(string id)
{
SHELF sHELF = db.SHELF.Find(id);
db.SHELF.Remove(sHELF);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "SHELF_ID,SHELF_AREA")] SHELF sHELF)
{
if (ModelState.IsValid)
{
db.Entry(sHELF).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sHELF));
}
public ActionResult Create([Bind(Include = "SHELF_ID,SHELF_AREA")] SHELF sHELF)
{
if (ModelState.IsValid)
{
db.SHELF.Add(sHELF);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sHELF));
}
public void Delete(string id)
{
SHELF myShelf = db.SHELF.Find(id);
if (myShelf == null)
{
return;
}
db.SHELF.Remove(myShelf);
db.SaveChanges();
}
// GET: SHELves/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SHELF sHELF = db.SHELF.Find(id);
if (sHELF == null)
{
return(HttpNotFound());
}
return(View(sHELF));
}
public JsonResult createShelf(string para01, string para02)
{
string shelf_id = para01;
string shelf_area = para02;
SHELF newShelf = new SHELF();
newShelf.SHELF_ID = shelf_id;
newShelf.SHELF_AREA = shelf_area;
db.SHELF.Add(newShelf);
db.SaveChanges();
var list2 = db.SHELF.Where(n => n.SHELF_ID != "0").Select(n => new { SHELF_ID = n.SHELF_ID, SHELF_AREA = n.SHELF_AREA });
return(Json(new { code = 0, msg = "", count = 1000, data = list2 }, JsonRequestBehavior.AllowGet));
}
public string editTest(string para01, string para02)
{
string bat_id = para01;
string shelf_id = para02;
SHELF myShelf = db.SHELF.Find(shelf_id);
if (myShelf == null)
{
return("1");
}
else
{
return("2");
}
}
public ActionResult saveShelves(List <string> toBeDeleted, List <string> toBeAdded)
{
try
{
CMSEntities m_context = new CMSEntities();
m_context.Configuration.ProxyCreationEnabled = false;
List <string> failedToDelete = new List <string>();
if (toBeAdded != null)
{
foreach (var item in toBeAdded)
{
var query = m_context.SHELves.Where(a => a.NAME_AR == item);
if (!query.Select(q => q.NAME_AR).Contains(item))
{
m_context.SHELves.Add(new SHELF {
NAME_AR = item
});
}
}
m_context.SaveChanges();
}
if (toBeDeleted != null)
{
foreach (var item in toBeDeleted)
{
try
{
SHELF s = (SHELF)m_context.SHELves.Where(a => a.NAME_AR == item).First();
m_context.SHELves.Remove(s);
m_context.SaveChanges();
}
catch (Exception ex)
{
failedToDelete.Add(item);
}
}
}
var current = (from row in m_context.SHELves select row.NAME_AR).ToList();
return(Json(new object[] { failedToDelete, current }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
throw;
}
}
public JsonResult editShelf(string para01, string para02)
{
string shelf_id = para01;
string shelf_area = para02;
SHELF myShelf = db.SHELF.Find(shelf_id);
myShelf.SHELF_AREA = shelf_area;
db.Entry(myShelf).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (Exception ex)
{
throw;
}
var list2 = db.SHELF.Where(n => n.SHELF_ID != "0").Select(n => new { SHELF_ID = n.SHELF_ID, SHELF_AREA = n.SHELF_AREA });
return(Json(new { code = 0, msg = "", count = 1000, data = list2 }, JsonRequestBehavior.AllowGet));
}
