Example #1
0
 private void lvDetailsComic_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (lvDetailsComic.SelectedItems.Count > 0)
     {
         ListViewItem lv = lvDetailsComic.SelectedItems[0];
         s = lv.SubItems[2].Text;
         string s1 = labelDetailComic.Text;
         //s = Convert.ToString((sender as ListViewItem.ListViewSubItem).Text);
         //Form1 form = new Form1(s, s1);
         //form.Show();
         ReadComic form1 = new ReadComic(s, s1, lv.SubItems[0].Text);
         form1.Show();
         this.Close();
     }
 }
Example #2
0
        private void btnSignIn_Click(object sender, EventArgs e)
        {
            string sql = "EXEC dbo.DangNhap @userName , @passWord";

            DataTable dt = DataProvider.Instance.ExecuteQuery(sql, new object[] { txtEmail.Text, txtPassword.Text });;

            if (dt != null && dt.Rows.Count > 0)        //Nếu datatable hợp lệ và có giá trị
            {
                for (int i = 0; i < dt.Rows.Count; i++) //Duyệt datatable và đưa vào list đối tượng NHANVIEN_DTO
                {
                    role = dt.Rows[i]["role"].ToString();
                    int temp_customer;
                    temp_customer = role.CompareTo("customer");
                    int temp_admin;
                    temp_admin = role.CompareTo("admin");
                    string    sql1 = "EXEC dbo.UpdateDateTimeNow @userName";
                    DataTable dt1;
                    if (temp_customer == 0)
                    {
                        // string sql1 = string.Format("update user set lastLogin=getdate() where username={0}", dt.Rows[i]["username"].ToString());

                        dt1 = DataProvider.Instance.ExecuteQuery(sql1, new object[] { dt.Rows[i]["username"].ToString() });
                        page_Home    fHome    = new page_Home(dt.Rows[i]["username"].ToString());
                        ReadComic    fRead    = new ReadComic(dt.Rows[i]["username"].ToString());
                        mainComic    form1    = new mainComic(dt.Rows[i]["username"].ToString());
                        page_History fHistory = new page_History(dt.Rows[i]["username"].ToString());
                        page_Details fProfile = new page_Details(dt.Rows[i]["username"].ToString());
                        form1.Show();
                        this.Hide();
                    }
                    if (temp_admin == 0)
                    {
                        dt1 = DataProvider.Instance.ExecuteQuery(sql1, new object[] { dt.Rows[i]["username"].ToString() });
                        formAdmin form2 = new formAdmin();
                        form2.Show();
                        this.Hide();
                    }
                }
            }
            else
            {
                // lblWarning.Show();
                lblWarning.Text = "Username or Password is WRONG";
            }
        }