public void loadDaftarBuku()
{
using (perpustakaanEntities db = new perpustakaanEntities())
{
var listBuku = db.bukus.ToList();
var listBukuPinjam = db.pinjams.Where(i => i.user_id == idUser && i.transaksi_id == idTransaksi).ToList();
dataGridViewBuku.Rows.Clear();
for (int i = 0; i < listBuku.Count; i++)
{
var chk = false;
for (int j = 0; j < listBukuPinjam.Count; j++)
{
if (listBuku[i].id == listBukuPinjam[j].buku_id)
{
chk = true;
}
}
if (chk)
{
dataGridViewBuku.Rows.Add(true, listBuku[i].id, listBuku[i].judul, listBuku[i].penerbit, listBuku[i].pengarang);
}
else
{
dataGridViewBuku.Rows.Add(false, listBuku[i].id, listBuku[i].judul, listBuku[i].penerbit, listBuku[i].pengarang);
}
}
}
}
public static void pinjam(string idbuku)
{
using (perpustakaanEntities db = new perpustakaanEntities())
{
var buku = db.bukus.First(i => i.id == idbuku);
buku.dipinjam++;
db.SaveChanges();
}
}
public static void kembali(string idbuku)
{
using (perpustakaanEntities db = new perpustakaanEntities())
{
var buku = db.bukus.First(i => i.id == idbuku);
if (buku.dipinjam != 0)
{
buku.dipinjam--;
db.SaveChanges();
}
}
}
public void cekPass()
{
using (perpustakaanEntities db = new perpustakaanEntities())
{
var result = db.logins.FirstOrDefault(i => i.username == "admin");
if (result.password == "")
{
SHA256 sha = new SHA256Managed();
var def_hash = Convert.ToBase64String(sha.ComputeHash(System.Text.Encoding.UTF8.GetBytes("admin" + "qwertyuio@#$&^&%&pQWERTYUIOP")));
result.password = def_hash;
db.SaveChanges();
}
}
}
private void login_Click(object sender, EventArgs e)
{
using (perpustakaanEntities db = new perpustakaanEntities())
{
var passx = hashPass(pass.Text);
var result = db.logins.Where(i => i.username == "admin" & i.password == passx).ToList();
if (result.Count > 0)
{
home _home = new home();
_home.Show();
this.Hide();
}
else
{
MessageBox.Show("Password Salah!");
}
}
}
private void dataGridViewBuku_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
var grid = (DataGridView)sender;
if (e.RowIndex > -1 && grid.Columns[e.ColumnIndex] is DataGridViewCheckBoxColumn)
{
var cb = grid.Rows[e.RowIndex].Cells[e.ColumnIndex] as DataGridViewCheckBoxCell;
var idbuku = grid.Rows[e.RowIndex].Cells[1].Value.ToString();
if ((bool)cb.Value)
{
//Unchecked
//MessageBox.Show("UnChecked :" + grid.Rows[e.RowIndex].Cells[1].Value.ToString());
cb.Value = false;
using (perpustakaanEntities db = new perpustakaanEntities())
{
var result = db.pinjams.FirstOrDefault(i => i.buku_id == idbuku && i.transaksi_id == idTransaksi && i.user_id == idUser);
if (result != null)
{
db.pinjams.Remove(result);
db.SaveChanges();
}
}
}
else
{
//Checked
//MessageBox.Show("Checked :" + grid.Rows[e.RowIndex].Cells[1].Value.ToString());
cb.Value = true;
using (perpustakaanEntities db = new perpustakaanEntities())
{
pinjam _pinjam = new pinjam()
{
transaksi_id = idTransaksi,
user_id = idUser,
buku_id = idbuku
};
db.pinjams.Add(_pinjam);
db.SaveChanges();
}
}
}
}
