public void LoginWithCustomer() { //try //{ string username = Username_tb.Text; string password = Password_tb.Text; User customer = new User(); Database data = new Database(); Book_Room book = new Book_Room(); SqlCommand command = new SqlCommand("select Id, fullname, picture, birthday, password, username, CMND FROM Customer WHERE username = @user AND password = @pass", data.GetConnection); command.Parameters.Add("@user", SqlDbType.NVarChar).Value = username; command.Parameters.Add("@pass", SqlDbType.NVarChar).Value = password; DataTable table1 = customer.GetUser(command); data.OpenConnection(); if (table1.Rows.Count > 0) { SqlDataAdapter SDA = new SqlDataAdapter(); SDA.SelectCommand = command; DataSet set = new DataSet(); SDA.Fill(set, "Customer"); data.CloseConnection(); if (customer.Login(username, password)) { book.Label_DisName.Text = table1.Rows[0]["fullname"].ToString().Trim(); book.Label_displayID.Text = table1.Rows[0]["Id"].ToString().Trim(); byte[] pic = (byte[])table1.Rows[0]["picture"]; MemoryStream picture = new MemoryStream(pic); book.PictureUser.Image = Image.FromStream(picture); book.ShowDialog(); } } else { XtraMessageBox.Show("Invalid Username of wrong Password, Try again or Create new account", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); } //} //catch //{ // XtraMessageBox.Show("Invalid Username of wrong Password, Try again or Create new account", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning); //} }
private void bookroom_item_ItemClick(object sender, ItemClickEventArgs e) { Book_Room ro = new Book_Room(); ro.Show(); }
private void Room_item_ItemClick(object sender, ItemClickEventArgs e) { Book_Room BR = new Book_Room(); BR.Show(); }