예제 #1
0
        private void button4_Click(object sender, EventArgs e)
        {
            AdminHomePage ahp = new AdminHomePage(this.user_id);

            this.Hide();
            ahp.Show();
        }
예제 #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            string adminName = "NULL";
            int    flag      = -1;

            try
            {
                SqlCommand cmd = new SqlCommand("sp_Admin_Login", con);
                cmd.CommandType = CommandType.StoredProcedure;

                //adding input parameters
                cmd.Parameters.Add("@U_ID", SqlDbType.Int, 50).Value        = textBox1.Text.Trim();
                cmd.Parameters.Add("@A_Pass", SqlDbType.NVarChar, 50).Value = textBox2.Text.Trim();

                //adding output parameter
                cmd.Parameters.Add(new SqlParameter("@A_IDD", SqlDbType.Int));
                cmd.Parameters["@A_IDD"].Direction = ParameterDirection.Output;

                //adding output parameter
                cmd.Parameters.Add(new SqlParameter("@A_Name", SqlDbType.NVarChar, 50));
                cmd.Parameters["@A_Name"].Direction = ParameterDirection.Output;

                //calling sp
                con.Open();
                SqlDataReader rdr = cmd.ExecuteReader();
                rdr.Close();

                //converting output to int
                try
                {
                    flag      = (int)cmd.Parameters["@A_IDD"].Value;
                    adminName = cmd.Parameters["@A_Name"].Value.ToString();
                }
                catch (Exception E)
                {
                    MessageBox.Show(E.Message);
                }

                //saving value in flag
                flag      = (int)cmd.Parameters["@A_IDD"].Value;
                adminName = cmd.Parameters["@A_Name"].Value.ToString();

                cmd.ExecuteNonQuery();
                con.Close();

                if (flag != 0)
                {
                    Forms.AdminHomePage AHS = new Forms.AdminHomePage(flag);
                    this.Hide();
                    AHS.Show();
                }
                else
                {
                    MessageBox.Show("Invalid Info, Please Check Again!");
                }
                textBox1.Clear();
                textBox2.Clear();
            }
            catch (Exception Exp)
            {
                MessageBox.Show("Admin cannot login due following error: " + Exp.Message);
                con.Close();
                textBox1.Clear();
                textBox2.Clear();
            }
        }