Esempio n. 1
0
        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);
        }
Esempio n. 2
0
        public ObjectSensorModel GetObjectSensorByID(int ObjSenID)
        {
            var               url           = "api/ObjectSensors/" + ObjSenID;
            string            result        = SC.Getcaller(url);
            ObjectSensorModel _objectsensor = JsonConvert.DeserializeObject <ObjectSensorModel>(result);

            return(_objectsensor);
        }