Beispiel #1
0
        public int getTotalRecords(PracticeCriteria conditions)
        {
            SqlConnectionFactory sqlConnection = new SqlConnectionFactory();

            using (SqlConnection connection = sqlConnection.GetConnection())
            {
                return(PracticeDataLayer.GetInstance().GetTotalRecords(connection, conditions));
            }
        }
Beispiel #2
0
        public void UpdateUser(PracticeInfo _user)
        {
            SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
            PracticeLogInfo      record        = new PracticeLogInfo();

            using (SqlConnection connection = sqlConnection.GetConnection())
            {
                PracticeDataLayer.GetInstance().UpdateUser(connection, _user);
            }
        }
Beispiel #3
0
        public List <PracticeInfo> GetList(PracticeCriteria conditions)
        {
            SqlConnectionFactory sqlConnection = new SqlConnectionFactory();

            using (SqlConnection connection = sqlConnection.GetConnection())
            {
                List <PracticeInfo> ListUserInfo = PracticeDataLayer.GetInstance().Getlist(connection, conditions);
                return(ListUserInfo);
            }
        }
Beispiel #4
0
        public void DeleteAllUser(string ids)
        {
            //connection
            SqlConnectionFactory sqlConnection = new SqlConnectionFactory();

            using (SqlConnection connection = sqlConnection.GetConnection())
            {
                //gọi tương tác tới datalayer
                PracticeDataLayer.GetInstance().DeleteAllUser(connection, ids);
            }
        }
Beispiel #5
0
        public PracticeInfo GetDetail(string id)
        {
            SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
            PracticeInfo         record        = new PracticeInfo();

            using (SqlConnection connection = sqlConnection.GetConnection())
            {
                record = PracticeDataLayer.GetInstance().GetUser(connection, id);

                return(record);
            }
        }
Beispiel #6
0
        public void CreateConfirm(ConfirmInfo value)
        {
            SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
            PracticeInfo         record        = new PracticeInfo();

            using (SqlConnection connection = sqlConnection.GetConnection())
            {
                //string applicationId = EncryptionUtils.GetApplicationId();
                //string applicationName = EncryptionUtils.GetApplicationName();

                PracticeDataLayer.GetInstance().CreateConfirm(connection, value);
            }
        }