public static ResponResultViewModel Is_Delete(MonitoringViewModel entity)
{
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new MinProContext())
{
t_monitoring mn = db.t_monitoring.Where(o => o.id == entity.id).FirstOrDefault();
if (mn != null)
{
mn.is_delete = true;
mn.deleted_by = 1;
mn.deleted_on = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public static ResponResultViewModel CreatePlacement(MonitoringViewModel entity)
{
//Untuk placement
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new MinProContext())
{
t_monitoring mn = db.t_monitoring.Where(o => o.id == entity.id).FirstOrDefault();
if (mn != null)
{
mn.placement_date = entity.placement_date;
mn.placement_at = entity.placement_at;
mn.notes = entity.notes;
mn.modified_by = 2;
mn.modified_on = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public static ResponResultViewModel Update(MonitoringViewModel entity)
{
//Untuk create dan edit
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new MinProContext())
{
//Create
if (entity.id == 0)
{
t_monitoring mn = new t_monitoring();
mn.biodata_id = entity.biodata_id;
mn.idle_date = entity.idle_date;
mn.last_project = entity.last_project;
mn.idle_reason = entity.idle_reason;
mn.placement_date = DateTime.Now;
mn.is_delete = entity.is_delete;
mn.created_by = 1;
mn.created_on = DateTime.Now;
db.t_monitoring.Add(mn);
db.SaveChanges();
result.Entity = mn;
}
//Edit
else
{
t_monitoring mn = db.t_monitoring.Where(o => o.id == entity.id).FirstOrDefault();
if (mn != null)
{
mn.biodata_id = entity.biodata_id;
mn.idle_date = entity.idle_date;
mn.last_project = entity.last_project;
mn.idle_reason = entity.idle_reason;
mn.is_delete = entity.is_delete;
mn.modified_by = 2;
mn.modified_on = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.Message = "Idle not Found!";
}
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public static ResponseResult Update(MonitoringViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new XBC_Context())
{
//CREATE
if (entity.id == 0)
{
t_monitoring mon = new t_monitoring();
mon.biodata_id = entity.biodata_id;
mon.idle_date = entity.idle_date;
mon.last_project = entity.last_project;
mon.idle_reason = entity.idle_reason;
mon.is_delete = entity.is_delete;
mon.created_by = entity.UserId;
mon.created_on = DateTime.Now;
db.t_monitoring.Add(mon);
db.SaveChanges();
object data = new
{
mon.id,
mon.biodata_id,
mon.idle_date,
mon.last_project,
mon.idle_reason
};
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 = mon.id;
result.Entity = entity;
}
else //EDIT
{
t_monitoring mon = db.t_monitoring
.Where(o => o.id == entity.id)
.FirstOrDefault();
if (mon != null)
{
object data = new
{
mon.id,
mon.biodata_id,
mon.idle_date,
mon.last_project,
mon.idle_reason
};
var json = new JavaScriptSerializer().Serialize(data);
t_audit_log log = new t_audit_log();
log.type = "Modify";
log.json_before = json;
log.created_by = entity.UserId;
log.created_on = DateTime.Now;
mon.biodata_id = entity.biodata_id;
mon.idle_date = entity.idle_date;
mon.last_project = entity.last_project;
mon.idle_reason = entity.idle_reason;
mon.modified_by = entity.UserId;
mon.modified_on = DateTime.Now;
object data2 = new
{
mon.id,
mon.biodata_id,
mon.idle_date,
mon.last_project,
mon.idle_reason,
mon.placement_at,
mon.placement_date,
mon.notes
};
var json2 = new JavaScriptSerializer().Serialize(data2);
log.json_after = json2;
db.t_audit_log.Add(log);
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.ErrorMessage = "Monitoring not found!";
}
}
}
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
//PLACEMENT
public static ResponseResult Placement(MonitoringViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new XBC_Context())
{
t_monitoring mon = db.t_monitoring
.Where(o => o.id == entity.id)
.FirstOrDefault();
if (mon != null)
{
object data = new
{
mon.id,
mon.biodata_id,
mon.idle_date,
mon.last_project,
mon.idle_reason
};
var json = new JavaScriptSerializer().Serialize(data);
t_audit_log log = new t_audit_log();
log.type = "Modify";
log.json_before = json;
log.created_by = entity.UserId;
log.created_on = DateTime.Now;
mon.placement_date = entity.placement_date;
mon.placement_at = entity.placement_at;
mon.notes = entity.notes;
mon.modified_by = entity.UserId;
mon.modified_on = DateTime.Now;
object data2 = new
{
mon.id,
mon.biodata_id,
mon.idle_date,
mon.last_project,
mon.idle_reason,
mon.placement_at,
mon.placement_date,
mon.notes
};
var json2 = new JavaScriptSerializer().Serialize(data2);
log.json_after = json2;
db.t_audit_log.Add(log);
db.SaveChanges();
entity.name = mon.t_biodata.name; //untuk menampilkan name (t_biodata) di pesan success Placement (monitoring),
//karena monitoring tidak punya name
result.Entity = entity;
}
else
{
result.Success = false;
result.ErrorMessage = "Monitoring not found!";
}
}
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
