public int Edit(CarObject mdl)
{
if(mdl.Id == 0)
{
db.CarObjects.Add(mdl);
db.SaveChanges();
db.Dispose();
db = new CarDumpDatabaseEntities();
}
else
{
db.Entry(mdl).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
db.Dispose();
db = new CarDumpDatabaseEntities();
}
return mdl.Id;
}
public ActionResult CheckUnchecked(string sid)
{
IEnumerable<CarDump> CD = null;// (from s in db.CarDumps where s.PostedUserID == userId select s).ToList();
if(sid != null)
{
int id = Convert.ToInt32(sid);
try
{
CarDump cd = db.CarDumps.Where(s => s.Id == id).First();
cd.Checked = true;
db.Entry(cd).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
db.Dispose();
db = new CarDumpDatabaseEntities();
}
catch(Exception)
{
}
}
CD = db.CarDumps.Where(
s =>( s.Checked == false )&&(s.AccessLevelID==1)
).OrderBy(s => s.Id).Skip(0).ToArray();
List<AspNetUser> Users;
using(var udb= new UsersDBEntities())
{
Users = udb.AspNetUsers.ToList();
foreach(var item in CD)
{
item.PostedUser = Users.Find(tf => tf.Id == item.PostedUserID);
}
}
return View(CD);
}
public ActionResult EditSet(int? SetItem, int? cditem, string saction)
{
CreateSetViewModel mdl = new CreateSetViewModel();
if(SetItem != null)
{
try
{
CarDumpSet set = (from s in db.CarDumpSets where s.Id == SetItem select s).First();
switch(saction)
{
case "add":
{
var slist = set.SetItems.OrderBy(ts => ts.Id).ToList();
if(slist.Find(tf => tf.CarDumpID == cditem) == null)
{
SetItem si = new Models.SetItem();
si.CarDumpID = (int)cditem;
si.CarDumpSetID = set.Id;
db.SetItems.Add(si);
db.SaveChanges();
db.Dispose();
db = new CarDumpDatabaseEntities();
return EditSet(SetItem, 0, "");
}
break;
}
case "rem":
{
// List<SetItem> SI = set.SetItems.Where(s => s.Id == cditem).ToList();
//MemoryType memoryType = db.MemoryTypes.Find(id);
//db.MemoryTypes.Remove(memoryType);
//db.SaveChanges();
//return RedirectToAction("Index");
SetItem SI = db.SetItems.Find(cditem);
db.SetItems.Remove(SI);
db.SaveChanges();
db.Dispose();
db = new CarDumpDatabaseEntities();
return EditSet(SetItem, 0, "");
}
default: break;
}
mdl.CDSet = set;
return PartialView("EditSetPartial", mdl);
}
catch(Exception)
{
return HttpNotFound();
}
}
else return HttpNotFound();
}
