public int DeleteMonitorItem(int unitid, string cameraid) { using (Entities db = new Entities()) { fi_specialcameras model = db.fi_specialcameras.SingleOrDefault(a => a.unitid == unitid && a.cameraid == cameraid); if (model != null) { db.fi_specialcameras.Remove(model); } return(db.SaveChanges()); } }
public int DeleteMonitorPro(int unitid) { using (Entities db = new Entities()) { fi_specialunits unit = db.fi_specialunits.FirstOrDefault(t => t.unitid == unitid); fi_specialcameras cam = db.fi_specialcameras.FirstOrDefault(t => t.unitid == unitid); if (unit != null && cam == null) { db.fi_specialunits.Remove(unit); return(db.SaveChanges()); } else { return(0); } } }
public int EditMonitorItem(MonitorListModel model) { using (Entities db = new Entities()) { fi_specialcameras item = db.fi_specialcameras.FirstOrDefault(t => t.unitid == model.unitid && t.cameraid == model.cameraid); if (item != null) { item.cameraid = model.cameraid; item.seq = model.seq; item.unitid = model.unitid; return(db.SaveChanges()); } else { return(0); } } }
public int AddMonitorItem(MonitorListModel model) { using (Entities db = new Entities()) { if (model.cameraid.Length > 0) { string[] cameras = model.cameraid.Split(','); for (int i = 0; i < cameras.Length - 1; i++) { string strCam = cameras[i]; fi_specialcameras cam = db.fi_specialcameras.FirstOrDefault(t => t.cameraid == strCam && t.unitid == model.unitid); if (cam == null) { fi_specialcameras item = new fi_specialcameras(); item.cameraid = cameras[i]; //item.seq = model.seq; item.unitid = model.unitid; db.fi_specialcameras.Add(item); } } } return(db.SaveChanges()); } }