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