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