コード例 #1
0
        private void matBtnLogin_Click(object sender, EventArgs e)
        {
            //NEW CODE WITH VERIFICATION
            IDBHandler handler = new DBHandler();

            string username = matTextUsername.Text;
            string password = "";

            if (username != "")
            {
                try
                {
                    uspLogin log = new uspLogin();
                    log      = handler.BLL_Login(matTextUsername.Text);
                    password = log.PersonnelPassword;
                    if (password == matTextPass.Text)
                    {
                        frmLoading loading = new frmLoading();
                        frmLogin   login   = this;
                        lblIncorrect.Visible = false;
                        login.Hide();
                        loading.Show();
                    }
                    else
                    {
                        lblIncorrect.Visible = true;
                        matTextPass.Text     = "";
                    }
                }
                catch (Exception)
                {
                    lblIncorrect.Visible = true;
                }
            }
            else
            {
                lblIncorrect.Visible = true;
            }
        }
コード例 #2
0
ファイル: DBAccess.cs プロジェクト: Mauricegdg/DragonCode
        public uspLogin Login(string userID)
        {
            uspLogin l = null;

            SqlParameter[] pars = new SqlParameter[]
            {
                new SqlParameter("@Username", userID),
            };

            using (DataTable table = DBHelper.ParamSelect("uspLogin",
                                                          CommandType.StoredProcedure, pars))
            {
                if (table.Rows.Count == 1)
                {
                    DataRow row = table.Rows[0];
                    l = new uspLogin
                    {
                        PersonnelPassword = Convert.ToString(row["PersonnelPassword"])
                    };
                }
            }
            return(l);
        }//EndLogin