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