public MonitorListModel GetGridItem(int unitid, string cameraid)
{
using (Entities db = new Entities())
{
string sql = string.Format(@"select * from fi_specialcameras f where f.unitid={0} and f.cameraid='{1}'", unitid, cameraid);
MonitorListModel model = db.Database.SqlQuery <MonitorListModel>(sql).FirstOrDefault();
return(model);
}
}
public HttpResponseMessage EditMonitorItem(MonitorListModel model)
{
HttpRequestBase request = ((HttpContextWrapper)this.Request.Properties["MS_HttpContext"]).Request;
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
int success = bll.EditMonitorItem(model);
if (success > 0)
{
response.Content = new StringContent("{\"success\":true}", Encoding.GetEncoding("UTF-8"), "text/html");
}
return(response);
}
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 HttpResponseMessage AddMonitorItem(dynamic obj)
{
string json = Convert.ToString(obj.json);
JArray jo = new JArray();
MonitorListModel model = new MonitorListModel();
jo = (JArray)JsonConvert.DeserializeObject(json);
foreach (JObject item in jo)
{
model.unitid = Convert.ToInt32(item["unitid"]);
model.cameraid = Convert.ToString(item["cameraid"]);
model.childid = Convert.ToString(item["childid"]);
}
HttpRequestBase request = ((HttpContextWrapper)this.Request.Properties["MS_HttpContext"]).Request;
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
int success = bll.AddMonitorItem(model);
if (success > 0)
{
response.Content = new StringContent("{\"success\":true}", Encoding.GetEncoding("UTF-8"), "text/html");
}
return(response);
}
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());
}
}
public int EditMonitorItem(MonitorListModel model)
{
return(dal.EditMonitorItem(model));
}
public int AddMonitorItem(MonitorListModel model)
{
return(dal.AddMonitorItem(model));
}
