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