public static ResponseResult Delete(RoomViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new XBC_Context())
{
t_room room = db.t_room.Where(o => o.id == entity.id).FirstOrDefault();
if (room != null)
{
room.is_delete = true;
room.deleted_by = entity.UserId;
room.created_on = DateTime.Now;
db.SaveChanges();
object data = new
{
room.id,
room.name,
room.code
};
var json = new JavaScriptSerializer().Serialize(data);
t_audit_log log = new t_audit_log();
log.type = "Modified";
log.json_insert = json;
log.created_by = entity.UserId;
log.created_on = DateTime.Now;
db.t_audit_log.Add(log);
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.ErrorMessage = "Room Not Fount";
}
}
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
// Untuk melakukan deaktivasi item
public static ResponResultViewModel Deactivate(RoomViewModel entity)
{
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new MinProContext())
{
t_room room = db.t_room.Where(item => item.id == entity.id).FirstOrDefault();
if (room != null)
{
room.active = false;
// user yang merubah
room.modified_by = 1;
room.modified_on = DateTime.Now;
result.Entity = entity;
db.SaveChanges();
}
else
{
result.Success = false;
result.Message = "Item not found";
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
// Untuk melakukan pembuatan item baru dan perubahan item yang sudah ada
public static ResponResultViewModel Update(RoomViewModel entity)
{
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new MinProContext())
{
// membuat item baru
if (entity.id == 0)
{
t_room room = new t_room();
room.id = entity.id;
room.code = entity.code;
room.name = entity.name;
room.capacity = entity.capacity;
room.any_projector = entity.any_projector;
room.notes = entity.notes;
room.office_id = entity.office_id;
// user yang membuat data
room.created_by = 1;
room.created_on = DateTime.Now;
// simpan ke result
result.Entity = entity;
// menyimpan ke obyek DbContext dan menyimpan perubahan data
db.t_room.Add(room);
db.SaveChanges();
}
// merubah item lama
else
{
t_room room = db.t_room.Where(item => item.id == entity.id).FirstOrDefault();
if (room != null)
{
room.id = entity.id;
room.code = entity.code;
room.name = entity.name;
room.capacity = entity.capacity;
room.any_projector = entity.any_projector;
room.notes = entity.notes;
room.office_id = entity.office_id;
// user yang merubah data
room.modified_by = 1;
room.modified_on = DateTime.Now;
// simpan ke obyek result
result.Entity = entity;
// simpan perubahan data di database
db.SaveChanges();
}
else
{
result.Success = false;
result.Message = "Item not found";
}
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public static ResponseResult Update(RoomViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new XBC_Context())
{
if (entity.id == 0)
{
t_room room = new t_room();
room.office_id = entity.officeId;
room.code = entity.code;
room.name = entity.name;
room.capacity = entity.capacity;
room.any_projector = entity.any_projector;
room.notes = entity.notes;
room.is_delete = false;
room.created_by = entity.UserId;
room.created_on = DateTime.Now;
db.t_room.Add(room);
db.SaveChanges();
object data = new
{
room.code,
room.name,
room.capacity,
room.any_projector,
room.notes,
};
var json = new JavaScriptSerializer().Serialize(data);
t_audit_log log = new t_audit_log();
log.type = "Insert";
log.json_insert = json;
log.created_by = entity.UserId;
log.created_on = DateTime.Now;
db.t_audit_log.Add(log);
entity.id = room.id;
result.Entity = entity;
}
else
{
t_room room = db.t_room.Where(o => o.id == entity.id).FirstOrDefault();
if (room != null)
{
var Serial = new JavaScriptSerializer();
object dataBefore = new
{
room.code,
room.name,
room.capacity,
room.any_projector,
room.notes
};
room.code = entity.code;
room.name = entity.name;
room.capacity = entity.capacity;
room.any_projector = entity.any_projector;
room.notes = entity.notes;
room.is_delete = false;
room.modified_by = entity.UserId;
room.modified_on = DateTime.Now;
db.SaveChanges();
object dataAfter = new
{
room.code,
room.name,
room.capacity,
room.any_projector,
room.notes
};
t_audit_log log = new t_audit_log();
log.type = "Modified";
log.json_before = Serial.Serialize(dataBefore);
log.json_after = Serial.Serialize(dataAfter);
log.created_by = entity.UserId;
log.created_on = DateTime.Now;
db.t_audit_log.Add(log);
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.ErrorMessage = "Room not Found";
}
}
}
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
public static ResponseResult Update(OfficeViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new XBC_Context())
{
if (entity.id == 0)//create
{
t_office ofc = new t_office();
ofc.name = entity.name;
ofc.phone = entity.phone;
ofc.email = entity.email;
ofc.address = entity.address;
ofc.notes = entity.notes;
ofc.is_delete = entity.isDelete;
ofc.created_by = entity.UserId;
ofc.created_on = DateTime.Now;
ofc.is_delete = false;
db.t_office.Add(ofc);
db.SaveChanges();
entity.id = ofc.id;
if (entity.details != null)
{
foreach (var item in entity.details)
{
t_room room = new t_room();
room.office_id = entity.id;
room.code = item.code;
room.name = item.name;
room.capacity = item.capacity;
room.any_projector = item.any_projector;
room.notes = entity.notes;
room.created_by = item.UserId;
room.created_on = DateTime.Now;
db.t_room.Add(room);
}
}
db.SaveChanges();
object data = new
{
ofc.id,
ofc.name,
ofc.phone,
ofc.email,
ofc.address,
ofc.notes
};
var json = new JavaScriptSerializer().Serialize(data);
t_audit_log log = new t_audit_log();
log.type = "Insert";
log.json_insert = json;
log.created_by = entity.UserId;
log.created_on = DateTime.Now;
db.t_audit_log.Add(log);
db.SaveChanges();
entity.id = ofc.id;
result.Entity = entity;
}
else //edit
{
t_office ofc = db.t_office.Where(o => o.id == entity.id).FirstOrDefault();
if (ofc != null)
{
var Serial = new JavaScriptSerializer();
object dataBefore = new
{
ofc.name,
ofc.phone,
ofc.email,
ofc.address,
ofc.notes
};
ofc.name = entity.name;
ofc.phone = entity.phone;
ofc.email = entity.email;
ofc.address = entity.address;
ofc.notes = entity.notes;
ofc.is_delete = entity.isDelete;
ofc.modified_by = entity.UserId;
ofc.modified_on = DateTime.Now;
db.SaveChanges();
object dataAfter = new
{
ofc.name,
ofc.phone,
ofc.email,
ofc.address,
ofc.notes
};
t_audit_log log = new t_audit_log();
log.type = "Modified";
log.json_before = Serial.Serialize(dataBefore);
log.json_after = Serial.Serialize(dataAfter);
log.created_by = entity.UserId;
log.created_on = DateTime.Now;
db.t_audit_log.Add(log);
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.ErrorMessage = "Office Not Found";
}
}
}
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
