private void isiDgv(string username) { dgvBooks.Rows.Clear(); koneksiSql koneksi = new koneksiSql(); SqlConnection conn = new SqlConnection(koneksi.getSqlConn()); SqlCommand cmd = new SqlCommand($"SELECT * from Lendings where Username = '******'", conn); SqlDataAdapter sda = new SqlDataAdapter(cmd); ds = new DataSet(); sda.Fill(ds, "Lendings"); try { for (int i = 0; i < ds.Tables["Lendings"].Rows.Count; i++) { string lendId = ds.Tables["Lendings"].Rows[i][0].ToString(); string user = ds.Tables["Lendings"].Rows[i][1].ToString(); string idBuku = ds.Tables["Lendings"].Rows[i][2].ToString(); string lend = ds.Tables["Lendings"].Rows[i][3].ToString(); string due = ds.Tables["Lendings"].Rows[i][4].ToString(); dgvBooks.Rows.Add(lendId, user, "0", idBuku, lend, due); } conn.Close(); } catch (Exception e) { MessageBox.Show(e.ToString()); } }
private void loadHotList() { koneksi = new koneksiSql(); SqlConnection conn = new SqlConnection(koneksi.getSqlConn()); SqlCommand cmd = new SqlCommand("SELECT Booklist.BookId, Booklist.PicturePath, Stock ,count(Lendings.BookID) AS jumlah FROM Booklist left join Lendings ON Booklist.BookId = Lendings.BookID GROUP BY Booklist.BookId, PicturePath, Stock ORDER BY jumlah DESC", conn); SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(dsOverdue, "Hotlist"); panelHotlist.Controls.Add(new hotBook(dsOverdue)); }
private void loadLowStock() { koneksi = new koneksiSql(); SqlConnection conn = new SqlConnection(koneksi.getSqlConn()); SqlCommand cmd = new SqlCommand($"SELECT BookId, PicturePath, Stock FROM Booklist ORDER BY Stock", conn); SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(dsOverdue, "LowStock"); panelSupport.Controls.Add(new NoOverdue(dsOverdue)); }
private void isiDgv(string teks) { dgvAccounts.Rows.Clear(); koneksiSql koneksi = new koneksiSql(); SqlConnection conn = new SqlConnection(koneksi.getSqlConn()); SqlCommand cmd = new SqlCommand($"SELECT * FROM Userlist Where Username LIKE '%{teks}%' or PasswordAkun LIKE '%{teks}%' or TipeAkun LIKE '%{teks}%'", conn); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); sda.Fill(ds, "Userlist"); for (int i = 0; i < ds.Tables["Userlist"].Rows.Count; i++) { string username = ds.Tables["Userlist"].Rows[i][0].ToString(); string password = ds.Tables["Userlist"].Rows[i][1].ToString(); string tipeAkun = ds.Tables["Userlist"].Rows[i][2].ToString(); dgvAccounts.Rows.Add(username, password, tipeAkun); } conn.Close(); }
private bool checkOverdue() { if (Program.userSekarang.tipe == "Guest") { return(false); } bool overdue = false; koneksi = new koneksiSql(); SqlConnection conn = new SqlConnection(koneksi.getSqlConn()); SqlCommand cmd = new SqlCommand($"SELECT * from Lendings INNER JOIN Booklist on Lendings.BookId = Booklist.BookID where Username = '******'", conn); SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(dsOverdue, "Lendings"); try { for (int i = 0; i < dsOverdue.Tables["Lendings"].Rows.Count; i++) { Peminjaman temp = new Peminjaman(); temp.username = dsOverdue.Tables["Lendings"].Rows[i]["Username"].ToString(); temp.bookId = dsOverdue.Tables["Lendings"].Rows[i]["BookId"].ToString(); temp.lendId = dsOverdue.Tables["Lendings"].Rows[i]["LendId"].ToString(); temp.strLendDate = dsOverdue.Tables["Lendings"].Rows[i]["LendDate"].ToString(); temp.strDueDate = dsOverdue.Tables["Lendings"].Rows[i]["DueDate"].ToString(); temp.fineCount(); if (temp.fine > 0) { overdue = true; break; } } conn.Close(); } catch (Exception e) { MessageBox.Show(e.ToString()); } return(overdue); }
private void isiDgv(string teks) { dgvBooks.Rows.Clear(); koneksiSql koneksi = new koneksiSql(); SqlConnection conn = new SqlConnection(koneksi.getSqlConn()); SqlCommand cmd = new SqlCommand($"SELECT * FROM Booklist Where Title LIKE '%{teks}%' or Author LIKE '%{teks}%' or Genre LIKE '%{teks}%' or YearReleased LIKE '%{teks}%'", conn); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); sda.Fill(ds, "Booklist"); for (int i = 0; i < ds.Tables["Booklist"].Rows.Count; i++) { string idBuku = ds.Tables["Booklist"].Rows[i][0].ToString(); string title = ds.Tables["Booklist"].Rows[i][1].ToString(); string author = ds.Tables["Booklist"].Rows[i][2].ToString(); string year = ds.Tables["Booklist"].Rows[i][3].ToString(); string genre = ds.Tables["Booklist"].Rows[i][4].ToString(); dgvBooks.Rows.Add(idBuku, title, author, year, genre); } conn.Close(); }