Esempio n. 1
0
        /// <summary>
        /// 현재 입력된 내용을 바탕으로 UserInfo객체 생성
        /// </summary>
        /// <returns></returns>
        private UserInfoProxyVO GetUserInfo()
        {
            UserAuth ua = new UserAuth();

            ua.견적관리     = (사용자권한)Enum.Parse(typeof(사용자권한), ddl견적관리.Text);
            ua.계정관리     = (사용자권한)Enum.Parse(typeof(사용자권한), ddl계정관리.Text);
            ua.고객정보     = (사용자권한)Enum.Parse(typeof(사용자권한), ddl고객정보.Text);
            ua.나의정보관리   = (사용자권한)Enum.Parse(typeof(사용자권한), ddl나의정보관리.Text);
            ua.데이터관리    = (사용자권한)Enum.Parse(typeof(사용자권한), ddl데이터관리.Text);
            ua.매입관리     = (사용자권한)Enum.Parse(typeof(사용자권한), ddl매입관리.Text);
            ua.상품정보     = (사용자권한)Enum.Parse(typeof(사용자권한), ddl상품정보.Text);
            ua.세금계산서관리  = (사용자권한)Enum.Parse(typeof(사용자권한), ddl세금계산서관리.Text);
            ua.양식정보     = (사용자권한)Enum.Parse(typeof(사용자권한), ddl양식정보.Text);
            ua.에프터서비스관리 = (사용자권한)Enum.Parse(typeof(사용자권한), ddl에프터서비스관리.Text);
            ua.인사관리     = (사용자권한)Enum.Parse(typeof(사용자권한), ddl인사관리.Text);
            ua.일정관리     = (사용자권한)Enum.Parse(typeof(사용자권한), ddl일정정보.Text);
            ua.재고관리     = (사용자권한)Enum.Parse(typeof(사용자권한), ddl재고관리.Text);
            ua.판매관리     = (사용자권한)Enum.Parse(typeof(사용자권한), ddl판매관리.Text);
            ua.표준관리     = (사용자권한)Enum.Parse(typeof(사용자권한), ddl표준관리.Text);
            ua.회계관리     = (사용자권한)Enum.Parse(typeof(사용자권한), ddl회계관리.Text);

            UsersVO ui = new UsersVO();

            ui.UserID       = txtID.Text;
            ui.UserPassword = txtPassword.Text;
            ui.UserAuth     = ua;
            ui.UserType     = (사용자등급)Enum.Parse(typeof(사용자등급), ddlUserType.Text);

            UserInfoProxyVO upv = new UserInfoProxyVO();

            upv.UsersVO = ui;
            return(upv);
        }
Esempio n. 2
0
        /// <summary>
        /// 사용자정보 인서트
        /// </summary>
        /// <param name="AuthKey"></param>
        /// <param name="serviceURL"></param>
        /// <param name="userInfo"></param>
        /// <returns></returns>
        public int InsertUserInfo(string AuthKey, string serviceURL, UsersVO userInfo)
        {
            string query       = new UserQuery().insertUser(userInfo);
            int    EffectedRow = DBController.getInstance().SetData(serviceURL, query);

            return(EffectedRow);
        }
Esempio n. 3
0
        /// <summary>
        /// 모든 유저의 정보 알아내기
        /// </summary>
        /// <param name="AuthKey"></param>
        /// <param name="serviceURL"></param>
        /// <returns></returns>
        public UsersVO[] GetUsersInfo(string AuthKey, string serviceURL)
        {
            if (!securityManager.CheckSecurityToken(AuthKey))
            {
                throw new Exception("인증된 사용자가 아닙니다");
            }
            string    query  = new UserQuery().GetAllUsers();
            DataTable dtUser = DBController.getInstance().GetData(serviceURL, query);

            IList <UsersVO> userList = new List <UsersVO>();

            for (int i = 0; i < dtUser.Rows.Count; i++)
            {
                UsersVO uvo = new UsersVO();
                uvo.UserID       = dtUser.Rows[i]["userid"].ToString();
                uvo.UserPassword = dtUser.Rows[i]["userpassword"].ToString();
                uvo.UserAuth     = JsonConvert.DeserializeObject <UserAuth>(dtUser.Rows[0]["userauth"].ToString());
                uvo.UserType     = (사용자등급)Enum.Parse(typeof(사용자등급), dtUser.Rows[0]["usertype"].ToString());
                userList.Add(uvo);
            }

            UsersVO[] arrUV = new UsersVO[userList.Count];
            for (int i = 0; i < userList.Count; i++)
            {
                arrUV[i] = userList[i];
            }
            return(arrUV);
        }
Esempio n. 4
0
 public UserInfoProxyVO GetUserInfo(string id, string password)
 {
     try
     {
         UsersVO uv = sqlProxy.UserLogIn
                      (
             new EncryptionService().GetEncryptedKey(this.EncryptionSeed, this.sqlProxy.GetTime()),
             this.ServiceURL,
             id,
             password
                      );
         if (uv == null)
         {
             throw new InvalidLogin();
         }
         else
         {
             UserInfoProxyVO up = new UserInfoProxyVO();
             up.UsersVO = uv;
             return(up);
         }
     }
     catch (Exception)
     {
         throw;
     }
 }
Esempio n. 5
0
        public override MasterVO BiuldVO(DataRow row)
        {
            UsersVO user = new UsersVO();

            user.Id        = Convert.ToInt32(row["id"]);
            user.Name      = row["name"].ToString();
            user.Picture   = (row["picture"] as byte[]);
            user.DateBirth = Convert.ToDateTime(row["dtBirth"]);
            user.Password  = row["password"].ToString();

            return(user);
        }
Esempio n. 6
0
 public UserInfoProxyVO GetUserInfo(string id)
 {
     try
     {
         UsersVO uv = sqlProxy.GetUserInfo
                      (
             new EncryptionService().GetEncryptedKey(this.EncryptionSeed, this.sqlProxy.GetTime()),
             this.ServiceURL,
             id
                      );
         UserInfoProxyVO up = new UserInfoProxyVO();
         up.UsersVO = uv;
         return(up);
     }
     catch (Exception)
     {
         throw;
     }
 }
Esempio n. 7
0
        private void btn_login_Click(object sender, EventArgs e)
        {
            try
            {
                UsersVO currentUser = new UsersVO();
                using (SqlConnection connection = ConnectionDB.GetConnection())
                {
                    SqlParameter[] parameters =
                    {
                        new SqlParameter("@name",     txt_LoginUsername.Text),
                        new SqlParameter("@password", txt_LoginPassword.Text)
                    };
                    DataTable table = Methods.SQLSelectProcedure("usp_ValidadeUser", parameters);

                    if (table.Rows.Count == 0)
                    {
                        MessageBox.Show("Nenhum usuário encontrado com esse nome e senha.", "Erro.", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        return;
                    }

                    foreach (DataRow row in table.Rows)
                    {
                        currentUser.Id        = Convert.ToInt32(row["id"].ToString());
                        currentUser.Name      = row["name"].ToString();
                        currentUser.DateBirth = Convert.ToDateTime(row["dateBirth"]);
                        currentUser.Picture   = (row["picture"] as byte[]);
                    }
                }

                fr_Default _Default = new fr_Default(currentUser);
                _Default.StartPosition = FormStartPosition.CenterParent;
                _Default.Show();
                Hide();
            }
            catch
            {
                MessageBox.Show("Erro ao conectar no Banco de Dados.", "Erro!",
                                MessageBoxButtons.OK, MessageBoxIcon.Error);
                ChangeButtonColor(btn_Database, Color.Red);
            }
        }
Esempio n. 8
0
        private void btn_Save_Click(object sender, EventArgs e)
        {
            errorProvider.Clear();
            bool foundError = false;

            if (String.IsNullOrEmpty(txt_RegisterUsername.Text))
            {
                foundError = true;
                errorProvider.SetError(txt_RegisterUsername, "Digite um nome válido.");
            }
            if (String.IsNullOrEmpty(txt_RegisterPassword.Text))
            {
                foundError = true;
                errorProvider.SetError(txt_RegisterPassword, "Digite ema senha válida.");
            }

            if (!foundError)
            {
                try
                {
                    ImageConverter converter  = new ImageConverter();
                    byte[]         imageArray = (byte[])converter.ConvertTo(pic_userPicture.Image, typeof(byte[]));

                    UsersDAO userDAO = new UsersDAO();
                    UsersVO  user    = new UsersVO();
                    user.Name      = txt_RegisterUsername.Text;
                    user.Password  = txt_RegisterPassword.Text;
                    user.DateBirth = Convert.ToDateTime(dtp_DateBirth.Value.ToShortDateString());

                    user.Picture = imageArray;

                    userDAO.SQLInsert(user);

                    MessageBox.Show("Usuário cadastrado com sucesso.", "Cadastrado.", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                catch
                {
                    MessageBox.Show("Problemas para cadastrar usuário.", "Erro.", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }
Esempio n. 9
0
        /// <summary>
        /// 특정 id 유저정보 알아내기
        /// </summary>
        /// <param name="AuthKey"></param>
        /// <param name="serviceURL"></param>
        /// <param name="id"></param>
        /// <returns></returns>
        public UsersVO GetUserInfo(string AuthKey, string serviceURL, string id)
        {
            if (!securityManager.CheckSecurityToken(AuthKey))
            {
                throw new Exception("인증된 사용자가 아닙니다");
            }
            string    query  = new UserQuery().GetUserInfo(id);
            DataTable dtUser = DBController.getInstance().GetData(serviceURL, query);

            if (dtUser.Rows.Count > 0)
            {
                UsersVO uvo = new UsersVO();
                uvo.UserID   = dtUser.Rows[0]["USERid"].ToString().Replace("{", "");
                uvo.UserAuth = JsonConvert.DeserializeObject <UserAuth>(dtUser.Rows[0]["UserAuth"].ToString());
                uvo.UserType = (사용자등급)Enum.Parse(typeof(사용자등급), dtUser.Rows[0]["usertype"].ToString());
                return(uvo);
            }
            else
            {
                return(null);
            }
        }
Esempio n. 10
0
        /// <summary>
        ///뷰단을 세팅
        /// </summary>
        private void SetView()
        {
            //드롭다운리스트의 데이터 바운딩
            ddlUserType.DataSource = Enum.GetNames(typeof(사용자등급));
            ddl견적관리.DataSource     = Enum.GetNames(typeof(사용자권한));
            ddl계정관리.DataSource     = Enum.GetNames(typeof(사용자권한));
            ddl고객정보.DataSource     = Enum.GetNames(typeof(사용자권한));
            ddl나의정보관리.DataSource   = Enum.GetNames(typeof(사용자권한));
            ddl데이터관리.DataSource    = Enum.GetNames(typeof(사용자권한));
            ddl매입관리.DataSource     = Enum.GetNames(typeof(사용자권한));
            ddl상품정보.DataSource     = Enum.GetNames(typeof(사용자권한));
            ddl세금계산서관리.DataSource  = Enum.GetNames(typeof(사용자권한));
            ddl양식정보.DataSource     = Enum.GetNames(typeof(사용자권한));
            ddl에프터서비스관리.DataSource = Enum.GetNames(typeof(사용자권한));
            ddl인사관리.DataSource     = Enum.GetNames(typeof(사용자권한));
            ddl일정정보.DataSource     = Enum.GetNames(typeof(사용자권한));
            ddl재고관리.DataSource     = Enum.GetNames(typeof(사용자권한));
            ddl판매관리.DataSource     = Enum.GetNames(typeof(사용자권한));
            ddl표준관리.DataSource     = Enum.GetNames(typeof(사용자권한));
            ddl회계관리.DataSource     = Enum.GetNames(typeof(사용자권한));


            //유저정보 목록 보여주기
            lvUserList.Items.Clear();
            this.userList = (IList <UserInfoProxyVO>) new SelectUser(null).GetData();
            if (userList != null)
            {
                foreach (UserInfoProxyVO up in userList)
                {
                    UsersVO  uv          = up.UsersVO;
                    string   id          = uv.UserID;
                    사용자등급    userType    = ((사용자등급)uv.UserType);
                    string   strUserType = Enum.GetName(typeof(사용자등급), userType);
                    string[] strData     = new string[] { id, strUserType };
                    lvUserList.Items.Add(new ListViewItem(strData));
                }
            }
        }
Esempio n. 11
0
        public string UpdateUser(UsersVO userInfo)
        {
            string        UserAuth = JsonConvert.SerializeObject(userInfo.UserAuth);
            string        UserType = Enum.GetName(typeof(사용자등급), userInfo.UserType);
            StringBuilder sbUser   = new StringBuilder();

            sbUser.Append("update Users set ");
            sbUser.Append("userid='");
            sbUser.Append(userInfo.UserID);
            sbUser.Append("',");
            sbUser.Append("userpassword = '******',");
            sbUser.Append("UserAuth = '");
            sbUser.Append(UserAuth);
            sbUser.Append("',");
            sbUser.Append("UserType = '");
            sbUser.Append(UserType);
            sbUser.Append("' where ");
            sbUser.Append(" userid='");
            sbUser.Append(userInfo.UserID);
            sbUser.Append("'");
            return(sbUser.ToString());
        }
Esempio n. 12
0
        public string insertUser(UsersVO userInfo)
        {
            string        UserAuth = JsonConvert.SerializeObject(userInfo.UserAuth);
            string        UserType = Enum.GetName(typeof(사용자등급), userInfo.UserType);
            StringBuilder sbUser   = new StringBuilder();

            sbUser.Append("insert into USERS(");
            sbUser.Append(" userid,");
            sbUser.Append("userpassword,");
            sbUser.Append("UserAuth,");
            sbUser.Append("UserType)");
            sbUser.Append(" values(");
            sbUser.Append("'");
            sbUser.Append(userInfo.UserID);
            sbUser.Append("','");
            sbUser.Append(userInfo.UserPassword);
            sbUser.Append("','");
            sbUser.Append(UserAuth);
            sbUser.Append("','");
            sbUser.Append(UserType);
            sbUser.Append("'");
            sbUser.Append(")");
            return(sbUser.ToString());
        }
Esempio n. 13
0
 public UserInfoProxyVO()
 {
     this.UsersVO          = new UsersVO();
     this.UsersVO.UserAuth = new UserAuth();
 }
Esempio n. 14
0
 public fr_Default(UsersVO parCurrentUser)
 {
     this.currentUser = parCurrentUser;
     InitializeComponent();
 }