コード例 #1
0
ファイル: login.cs プロジェクト: haisum/c-sharp-point-of-sale
        private void btnLogin_Click(object sender, EventArgs e)
        {
            try
            {
            UsersTableAdapter myUsersAd = new UsersTableAdapter();
            POSDataSet.UsersDataTable myUsersTbl = new POSDataSet.UsersDataTable();
            myUsersTbl = myUsersAd.GetUsersDataBy();

            bool UserRecordFound = false;

            foreach (DataRow myRow in myUsersTbl.Rows)
                {

                    if (myRow["User_Name"].ToString().ToLower().Trim() == txtUserName.Text.ToLower().Trim() && myRow["Password"].ToString().Trim() == txtPassword.Text.Trim())
                    {
                        global.user_id = Convert.ToInt32(myRow["User_ID"]);
                        global.user_type = Convert.ToByte(myRow["Type"].ToString());
                        global.user_name = System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(myRow["User_Name"].ToString());
                        global.password = myRow["Password"].ToString().Trim();

                        UserRecordFound = true;

                        new homescreen().Show();
                        this.Hide();
                        //this.Close();

                        break;
                    }

                }

                if (!UserRecordFound)
                {
                    MessageBox.Show("Invalid User Name/Password\nPlease Try Again");
                }
            }
            catch (Exception exc)
            {
                MessageBox.Show("Unable to Load Database\n" + exc.Message);
            }
        }
コード例 #2
0
        private void btnLogin_Click(object sender, EventArgs e)
        {
            try
            {
                UsersTableAdapter         myUsersAd  = new UsersTableAdapter();
                POSDataSet.UsersDataTable myUsersTbl = new POSDataSet.UsersDataTable();
                myUsersTbl = myUsersAd.GetUsersDataBy();

                bool UserRecordFound = false;

                foreach (DataRow myRow in myUsersTbl.Rows)
                {
                    if (myRow["User_Name"].ToString().ToLower().Trim() == txtUserName.Text.ToLower().Trim() && myRow["Password"].ToString().Trim() == txtPassword.Text.Trim())
                    {
                        global.user_id   = Convert.ToInt32(myRow["User_ID"]);
                        global.user_type = Convert.ToByte(myRow["Type"].ToString());
                        global.user_name = System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(myRow["User_Name"].ToString());
                        global.password  = myRow["Password"].ToString().Trim();

                        UserRecordFound = true;

                        new homescreen().Show();
                        this.Hide();
                        //this.Close();

                        break;
                    }
                }

                if (!UserRecordFound)
                {
                    MessageBox.Show("Invalid User Name/Password\nPlease Try Again");
                }
            }
            catch (Exception exc)
            {
                MessageBox.Show("Unable to Load Database\n" + exc.Message);
            }
        }