예제 #1
0
        private void Button2_Click(object sender, EventArgs e)
        {
            SqlConnection  conn = new SqlConnection(@"Data Source=DESKTOP-AQUQBDR\SQLEXPRESS;Initial Catalog=AttendanceProtDb;Integrated Security=True");
            SqlDataAdapter sda  = new SqlDataAdapter("Sp_Login", conn);

            sda.SelectCommand.Parameters.AddWithValue("@username", txt_username.Text);
            sda.SelectCommand.Parameters.AddWithValue("@userpass", txt_password.Text);
            sda.SelectCommand.CommandType = CommandType.StoredProcedure;
            DataTable    dt     = new System.Data.DataTable();
            gettersetter set_ID = new gettersetter();

            sda.Fill(dt);



            if (dt.Rows.Count == 1)

            {
                set_ID.setEmp_ID(Convert.ToInt32(dt.Rows[0][1].ToString()));
                switch (dt.Rows[0][0].ToString())
                {
                case "1":
                {
                    this.Hide();
                    Form4 f4 = new Form4();
                    f4.Show();
                    break;
                }

                case "2":
                {
                    conn.Open();
                    SqlCommand Comm2 = new SqlCommand("sp_timecon", conn);
                    Comm2.Parameters.AddWithValue("@username", txt_username.Text);
                    Comm2.CommandType = CommandType.StoredProcedure;
                    SqlDataReader DR1 = Comm2.ExecuteReader();
                    if (DR1.Read())
                    {
                        EmpID   = Convert.ToInt32(DR1[0]);
                        Emprate = Convert.ToInt32(DR1[1]);
                    }
                    this.Hide();
                    Form3 f3 = new Form3();
                    f3.Show();
                    conn.Close();
                    break;
                }

                default:
                {
                    // ... handle unexpected roles here...
                    break;
                }
                }
            }
            else
            {
                MessageBox.Show("Wrong Username or Password");
            }
        }
예제 #2
0
        private void Profile_Load(object sender, EventArgs e)
        {
            gettersetter setter_profile = new gettersetter();

            Conn.Open();
            SqlCommand Comm1 = new SqlCommand("Sp_Select_EmpInfo", Conn);

            Comm1.Parameters.AddWithValue("@p_EmpID", setter_profile.getEmp_ID());
            Comm1.CommandType = CommandType.StoredProcedure;
            SqlDataReader DR1 = Comm1.ExecuteReader();

            while (DR1.Read())
            {
                text_ID.Text      = DR1["Emp_ID"].ToString();
                text_Fname.Text   = DR1["FirstName"].ToString();
                text_Lname.Text   = DR1["LastName"].ToString();
                text_Age.Text     = DR1["Age"].ToString();
                text_Bdate.Text   = DR1["Birthdate"].ToString();
                text_Address.Text = DR1["Emp_Address"].ToString();
                sampleAge.Text    = DR1["Age"].ToString();
            }
        }
예제 #3
0
        public void EmpRefresh()
        {
            gettersetter setter_profile = new gettersetter();

            Conn.Open();
            SqlDataAdapter Comm1 = new SqlDataAdapter("sp_Emp_Read", Conn);

            Comm1.SelectCommand.Parameters.AddWithValue("@Emp_ID", setter_profile.getEmp_ID());
            Comm1.SelectCommand.CommandType = CommandType.StoredProcedure;


            DataTable dt = new DataTable();

            Comm1.Fill(dt);
            label1ID.DataBindings.Clear();
            labelFname.DataBindings.Clear();
            labelLName.DataBindings.Clear();
            label1Age.DataBindings.Clear();
            label1Bdate.DataBindings.Clear();
            label1Address.DataBindings.Clear();
            label1username.DataBindings.Clear();
            label1userpass.DataBindings.Clear();
            label_ERate.DataBindings.Clear();

            label1ID.DataBindings.Add("Text", dt, "Emp_ID");
            labelFname.DataBindings.Add("Text", dt, "FirstName");
            labelLName.DataBindings.Add("Text", dt, "LastName");
            label1Age.DataBindings.Add("Text", dt, "Age");
            label1Bdate.DataBindings.Add("Text", dt, "Birthdate");
            label1Address.DataBindings.Add("Text", dt, "Emp_Address");
            label1username.DataBindings.Add("Text", dt, "username");
            label1userpass.DataBindings.Add("Text", dt, "userpass");
            label_ERate.DataBindings.Add("Text", dt, "Emp_Rate");
            dataRepeater1.DataSource = dt;
            Conn.Close();
        }