示例#1
0
        public override UserInfo UserInfoGetByUser(string userName)
        {
            DBCommands.PopulateParams("@UserName", userName);

            DataTable userData = DBCommands.AdapterFill("p_UserInfo_GetByUser");
            UserInfo  user     = new UserInfo();

            foreach (DataRow row in userData.Rows)
            {
                user.UserName     = row["UserName"].ToString();
                user.Email        = row["Email"].ToString();
                user.ProfileImage = (row["ProfileImage"] != DBNull.Value) ? row["ProfileImage"].ToString() : null;
            }

            return(user);
        }
示例#2
0
        public override UserInfo UserInfoGetByCode(string code)
        {
            DBCommands.PopulateParams("@code", code);
            DataTable userTable = DBCommands.AdapterFill("p_UserInfo_GetByCode");
            UserInfo  user      = null;

            foreach (DataRow row in userTable.Rows)
            {
                user              = new UserInfo();
                user.UserInfoID   = Convert.ToInt32(row["UserInfoID"]);
                user.UserName     = row["UserName"].ToString();
                user.Email        = (row["Email"] != DBNull.Value) ? row["Email"].ToString() : null;
                user.ProfileImage = (row["ProfileImage"] != DBNull.Value) ? row["ProfileImage"].ToString() : null;
                user.RecoverCode  = code;
            }


            return(user);
        }
示例#3
0
 public override DataTable UserGroupsGetActive()
 {
     return(DBCommands.AdapterFill("p_UserGroup_GetActive"));
 }
示例#4
0
        public override DataTable GroupUsersGetByUserName(string userName)
        {
            DBCommands.PopulateParams("@UserName", userName);

            return(DBCommands.AdapterFill("p_GroupUsers_GetByUserName"));
        }
示例#5
0
 public override DataTable UserInfoGetAll()
 {
     return(DBCommands.AdapterFill("p_UserInfo_GetAll"));
 }