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(); } }
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"; } }