//Delete
public static ResponseResult Delete(BookViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new XContext())
{
x_book book = db.x_book
.Where(o => o.id == entity.Id)
.FirstOrDefault();
if (book != null)
{
book.deleted_by = 1;
book.deleted_on = DateTime.Now;
book.is_delete = true;
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.Message = "Data Not Found ! ";
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public static ResponseResult Update(BookViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new XContext())
{
#region Create New / Insert
if (entity.Id == 0)
{
x_book book = new x_book();
book.category_id = entity.CategoryId;
book.judul = entity.Judul;
book.penerbit = entity.Penerbit;
book.pengarang = entity.Pengarang;
book.tahun = entity.Tahun;
book.lokasi_rak = entity.LokasiRak;
book.deskripsi = entity.Deskripsi;
book.created_by = 1;
book.created_on = DateTime.Now;
db.x_book.Add(book);
db.SaveChanges();
result.Entity = entity;
}
#endregion
#region Edit
else
{
x_book book = db.x_book
.Where(o => o.id == entity.Id)
.FirstOrDefault();
if (book != null)
{
book.category_id = entity.CategoryId;
book.judul = entity.Judul;
book.penerbit = entity.Penerbit;
book.pengarang = entity.Pengarang;
book.tahun = entity.Tahun;
book.lokasi_rak = entity.LokasiRak;
book.deskripsi = entity.Deskripsi;
book.modified_by = 1;
book.modified_on = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.Message = "Data Not Found !";
}
}
#endregion
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
