public DataTable SelectAll(string query)
        {
            da = new SqlDataAdapter(query, DevicesdetailDAL.Connect());
            DataTable dt = new DataTable();

            da.Fill(dt);
            return(dt);
        }
        public bool DMLOpperation(string query)
        {
            cmd = new SqlCommand(query, DevicesdetailDAL.Connect());
            int x = cmd.ExecuteNonQuery();

            if (x == 1)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }