Example #1
0
File: UserDB.cs Project: quy79/MMK
        /// <summary>
        /// 
        /// </summary>
        /// <param name="firstname"></param>
        /// <param name="lastname"></param>
        /// <param name="username"></param>
        /// <param name="title"></param>
        /// <param name="email"></param>
        /// <param name="phone"></param>
        /// <param name="city"></param>
        /// <param name="province"></param>
        /// <param name="country"></param>
        /// <returns>
        /// 0 : add user fail
        /// 1 : add user successful
        /// 2 : this email is registered
        /// 3 : this user is registered
        /// </returns>
        public static int AddUser(string firstname, string lastname, string username, string password, string title, 
                                  string email, string phone, string city, string province, string country)
        {
            Users user = new Users();
            user.FIRSTNAME = firstname;
            user.LASTNAME = lastname;
            user.USERNAME = username;
            user.PASSWORD = password;
            user.TITLE = title;
            user.EMAIL = email;
            user.PHONE = phone;
            user.CITY = city;
            user.PROVINCE = province;
            user.COUNTRY = country;

            //check username is existed
            if (user.IsExistEmail()) return 2;
            //check email is existed
            if (user.IsExistUsername()) return 3;
            //inseert new user
            if(user.Insert()) return 1;
            return 0;
        }
Example #2
0
        public bool Insert()
        {
            try
            {
            objclsUSERS = new Users();

            objclsUSERS.FIRSTNAME = FIRSTNAME;
            objclsUSERS.LASTNAME = LASTNAME;
            objclsUSERS.USERNAME = USERNAME;
            objclsUSERS.PASSWORD = PASSWORD;
            objclsUSERS.TITLE = TITLE;
            objclsUSERS.EMAIL = EMAIL;
            objclsUSERS.PHONE = PHONE;
            objclsUSERS.CITY = CITY;
            objclsUSERS.PROVINCE = PROVINCE;
            objclsUSERS.POSTCODE = POSTCODE;
            objclsUSERS.COUNTRY = COUNTRY;
            objclsUSERS.MODIFIEDDATE = MODIFIEDDATE;

            if(objclsUSERS.Insert())
            {
                return true;
            }
            return false;
            }
            catch(Exception ex)
            {
            throw new Exception(ex.Message);
            }
        }