Example #1
0
        public DataTable Login(ViewImages vi)
        {
            DataAccessLayer da = new DataAccessLayer();
            DataTable       dt = new DataTable();

            SqlParameter[] parameter = { new SqlParameter("@ImageID", vi.ImageID) };
            dt = da.ExecuteQuery("SPViewImages", CommandType.StoredProcedure, parameter);

            return(dt);
        }
Example #2
0
        public DataTable Login(PlayVideo pv)
        {
            DataAccessLayer da = new DataAccessLayer();
            DataTable       dt = new DataTable();

            SqlParameter[] parameter = { new SqlParameter("@VideoID", pv.VideoID) };
            dt = da.ExecuteQuery("SPViewVideo", CommandType.StoredProcedure, parameter);

            return(dt);
        }
Example #3
0
//****************************************************************************************
// Person Login
        public DataTable Login(Person per)
        {
            DataAccessLayer da = new DataAccessLayer();
            DataTable       dt = new DataTable();

            SqlParameter[] parameter = { new SqlParameter("@User_Name", per.UName), new SqlParameter("@Per_Password", per.PPassword) };
            dt = da.ExecuteQuery("SPPatientLogin", CommandType.StoredProcedure, parameter);

            return(dt);
        }