예제 #1
0
        public DataSet GetDataRentDevice(string idCustomer)
        {
            SqlCommand sqlcmd;

            if (cls.CheckStatusLogin() == true)
            {
                sqlcmd = new SqlCommand("SELECT * FROM Rent_Device");
            }
            else
            {
                sqlcmd = new SqlCommand("SELECT * FROM Rent_Device WHERE Id_Customer  = " + Login.getIdCustomerLogin() + "");
            }
            return(cls.LayDuLieu(sqlcmd));
        }
예제 #2
0
        public DataSet GetDataAccount(string idCustomer)
        {
            SqlCommand sqlcmd;

            if (cls.CheckStatusLogin() == true)
            {
                sqlcmd = new SqlCommand("SELECT * FROM Account");
            }
            else
            {
                sqlcmd = new SqlCommand("SELECT * FROM Account WHERE Id_Customer = '" + Login.getIdCustomerLogin() + "'");
            }
            return(cls.LayDuLieu(sqlcmd));
        }