public void AddUserAccount(UserSignUpView user) { using (DemoDBEntities db = new DemoDBEntities()) { SYSUser SU = new SYSUser(); SU.LoginName = user.LoginName; SU.PasswordEncryptedText = user.Password; SU.RowCreatedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1; SU.RowModifiedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1;; SU.RowCreatedDateTime = DateTime.Now; SU.RowMOdifiedDateTime = DateTime.Now; db.SYSUsers.Add(SU); db.SaveChanges(); SYSUserProfile SUP = new SYSUserProfile(); SUP.SYSUserID = SU.SYSUserID; SUP.FirstName = user.FirstName; SUP.LastName = user.LastName; SUP.Gender = user.Gender; SUP.RowCreatedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1; SUP.RowModifiedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1; SUP.RowCreatedDateTime = DateTime.Now; SUP.RowModifiedDateTime = DateTime.Now; db.SYSUserProfiles.Add(SUP); db.SaveChanges(); if (user.LOOKUPRoleID > 0) { SYSUserRole SUR = new SYSUserRole(); SUR.LOOKUPRoleID = user.LOOKUPRoleID; SUR.SYSUserID = user.SYSUserID; SUR.IsActive = true; SUR.RowCreatedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1; SUR.RowModifiedSYSUserID = user.SYSUserID > 0 ? user.SYSUserID : 1; SUR.RowCreatedDateTime = DateTime.Now; SUR.RowModifiedDateTime = DateTime.Now; db.SYSUserRoles.Add(SUR); db.SaveChanges(); } } }
public void DeleteUser(int userID) { using (DemoDBEntities db = new DemoDBEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { var SUR = db.SYSUserRoles.Where(o => o.SYSUserID == userID); if (SUR.Any()) { db.SYSUserRoles.Remove(SUR.FirstOrDefault()); db.SaveChanges(); } var SUP = db.SYSUserProfiles.Where(o => o.SYSUserID == userID); if (SUP.Any()) { db.SYSUserProfiles.Remove(SUP.FirstOrDefault()); db.SaveChanges(); } var SU = db.SYSUsers.Where(o => o.SYSUserID == userID); if (SU.Any()) { db.SYSUsers.Remove(SU.FirstOrDefault()); db.SaveChanges(); } dbContextTransaction.Commit(); } catch { dbContextTransaction.Rollback(); } } } }
public void UpdateUserAccount(UserProfileView user) { using (DemoDBEntities db = new DemoDBEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { SYSUser SU = db.SYSUsers.Find(user.SYSUserID); SU.LoginName = user.LoginName; SU.PasswordEncryptedText = user.Password; SU.RowCreatedSYSUserID = user.SYSUserID; SU.RowModifiedSYSUserID = user.SYSUserID; SU.RowCreatedDateTime = DateTime.Now; SU.RowMOdifiedDateTime = DateTime.Now; db.SaveChanges(); var userProfile = db.SYSUserProfiles.Where(o => o.SYSUserID == user.SYSUserID); if (userProfile.Any()) { SYSUserProfile SUP = userProfile.FirstOrDefault(); SUP.SYSUserID = SU.SYSUserID; SUP.FirstName = user.FirstName; SUP.LastName = user.LastName; SUP.Gender = user.Gender; SUP.RowCreatedSYSUserID = user.SYSUserID; SUP.RowModifiedSYSUserID = user.SYSUserID; SUP.RowCreatedDateTime = DateTime.Now; SUP.RowModifiedDateTime = DateTime.Now; db.SaveChanges(); } if (user.LOOKUPRoleID > 0) { var userRole = db.SYSUserRoles.Where(o => o.SYSUserID == user.SYSUserID); SYSUserRole SUR = null; if (userRole.Any()) { SUR = userRole.FirstOrDefault(); SUR.LOOKUPRoleID = user.LOOKUPRoleID; SUR.SYSUserID = user.SYSUserID; SUR.IsActive = true; SUR.RowCreatedSYSUserID = user.SYSUserID; SUR.RowModifiedSYSUserID = user.SYSUserID; SUR.RowCreatedDateTime = DateTime.Now; SUR.RowModifiedDateTime = DateTime.Now; } else { SUR = new SYSUserRole(); SUR.LOOKUPRoleID = user.LOOKUPRoleID; SUR.SYSUserID = user.SYSUserID; SUR.IsActive = true; SUR.RowCreatedSYSUserID = user.SYSUserID; SUR.RowModifiedSYSUserID = user.SYSUserID; SUR.RowCreatedDateTime = DateTime.Now; SUR.RowModifiedDateTime = DateTime.Now; db.SYSUserRoles.Add(SUR); } db.SaveChanges(); } dbContextTransaction.Commit(); } catch { dbContextTransaction.Rollback(); } } } }
public void UpdateBuku(BukuView kv) { using (DemoDBEntities db = new DemoDBEntities()) { buku km = db.bukus.Find(kv.id_buku); km.id_buku = kv.id_buku; km.ISBN = kv.ISBN; km.judul = kv.judul; km.penulis = kv.penulis; km.penerbit = kv.penerbit; km.tahun = kv.tahun; km.stok = kv.stok; //db.kamars.Add(km); db.SaveChanges(); } }
public void TambahLaporan(TambahLaporanModel LaporanModel) { using (DemoDBEntities db = new DemoDBEntities()) { laporan l = new laporan(); l.id_laporan = LaporanModel.id_laporan; l.id_buku = LaporanModel.id_buku; l.id_pelanggan = LaporanModel.id_pelanggan; l.keterangan = LaporanModel.keterangan; l.kredit = LaporanModel.kredit; l.saldo = LaporanModel.saldo; l.debet = LaporanModel.debet; l.tanggal = LaporanModel.tanggal; db.laporans.Add(l); db.SaveChanges(); } }
public void InsertLaporan(LaporanView lv) { using (DemoDBEntities db = new DemoDBEntities()) { laporan lap = new laporan(); lap.id_laporan = lv.idLaporan; lap.id_buku = lv.idBuku; lap.id_pelanggan = lv.idPelanggan; lap.keterangan = lv.keterangan; lap.tgl_pinjam = lv.tglPinjam; lap.tgl_kembali = lv.tglKembali; TimeSpan d = (lv.tglKembali - lv.tglPinjam) ?? default(TimeSpan); int idBuku = lv.idBuku ?? default(int); lap.saldo = int.Parse(d.Days.ToString()) * GetHargaBuku(idBuku); db.laporans.Add(lap); db.SaveChanges(); } }
public void TambahBuku(TambahBukuModel bukuModel) { using (DemoDBEntities db = new DemoDBEntities()) { buku b = new buku(); b.harga_beli = bukuModel.harga_beli; b.harga_jual = bukuModel.harga_jual; b.id_buku = bukuModel.id_buku; b.ISBN = bukuModel.ISBN; b.judul = bukuModel.judul; b.penerbit = bukuModel.penerbit; b.penulis = bukuModel.penulis; b.stok = bukuModel.stok; b.tahun = bukuModel.tahun; db.bukus.Add(b); db.SaveChanges(); } }
public void DeleteBuku(int bukuID) { using (DemoDBEntities db = new DemoDBEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { var Km = db.bukus.Where(o => o.id_buku == bukuID); if (Km.Any()) { db.bukus.Remove(Km.FirstOrDefault()); db.SaveChanges(); } dbContextTransaction.Commit(); } catch { dbContextTransaction.Rollback(); } } } }