public List <ObjectSensorModel> getObjectSensorList(int objectID) { List <ObjectSensorModel> list = new List <ObjectSensorModel>(); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ObjectID", objectID) }; using (DataTable table = DBHelper.ExecuteParamerizedSelectCommand("uspGET_ObjectSensorListsByObject", CommandType.StoredProcedure, parameters)) { if (table.Rows.Count > 0) { foreach (DataRow row in table.Rows) { ObjectSensorModel model = new ObjectSensorModel(); model.ObjectSensorId = Convert.ToInt32(row["ObjectSensorId"]); model.Name = row["Name"].ToString(); model.SourceID = row["SourceID"].ToString(); model.Min = Convert.ToInt32(row["Min"]); model.Max = Convert.ToInt32(row["Max"]); model.A0 = Convert.ToDouble(row["A0"]); model.A1 = Convert.ToDouble(row["A1"]); model.Contact = row["Contact"].ToString(); model.Category = row["Category"].ToString(); model.SMSAlert = Convert.ToBoolean(row["SMSAlert"]); list.Add(model); } } } return(list); }
public ObjectSensorModel GetObjectSensorByID(int ObjSenID) { var url = "api/ObjectSensors/" + ObjSenID; string result = SC.Getcaller(url); ObjectSensorModel _objectsensor = JsonConvert.DeserializeObject <ObjectSensorModel>(result); return(_objectsensor); }