public static ResponResultViewModel CreateHold(AssignmentViewModel entity)
{
//Untuk placement
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new MinProContext())
{
t_assignment asg = db.t_assignment.Where(o => o.id == entity.id).FirstOrDefault();
if (asg != null)
{
asg.biodata_id = entity.biodata_id;
asg.is_hold = true;
asg.modified_by = 2;
asg.modified_on = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public static ResponResultViewModel is_delete(AssignmentViewModel entity)
{
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new MinProContext())
{
t_assignment asn = db.t_assignment.Where(o => o.id == entity.id).FirstOrDefault();
if (asn != null)
{
asn.is_delete = true;
asn.deleted_by = 1;
asn.deleted_on = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public static ResponResultViewModel Update(AssignmentViewModel entity)
{
//Untuk create dan edit
ResponResultViewModel result = new ResponResultViewModel();
try
{
using (var db = new MinProContext())
{
//Create
if (entity.id == 0)
{
t_assignment asn = new t_assignment();
asn.biodata_id = entity.biodata_id;
asn.title = entity.title;
asn.start_date = entity.start_date;
asn.end_date = entity.end_date;
asn.description = entity.description;
asn.is_delete = entity.is_delete;
asn.is_done = entity.is_done;
asn.is_hold = entity.is_hold;
asn.created_by = 1;
asn.created_on = DateTime.Now;
db.t_assignment.Add(asn);
db.SaveChanges();
result.Entity = asn;
}
//Edit
else
{
t_assignment asn = db.t_assignment.Where(o => o.id == entity.id).FirstOrDefault();
if (asn != null)
{
asn.biodata_id = entity.biodata_id;
asn.title = entity.title;
asn.start_date = entity.start_date;
asn.end_date = entity.end_date;
asn.description = entity.description;
asn.is_delete = entity.is_delete;
asn.is_done = entity.is_done;
asn.is_hold = entity.is_hold;
asn.modified_by = 2;
asn.modified_on = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.Message = "Assignment not Found!";
}
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public static ResponseResult Hold(AssignmentViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new XBC_Context())
{
t_assignment assignment = db.t_assignment.Where(o => o.id == entity.id).FirstOrDefault();
if (assignment != null)
{
var Serial = new JavaScriptSerializer();
object data = new
{
assignment.biodata_id,
assignment.title,
assignment.start_date,
assignment.end_date,
assignment.description,
assignment.realization_date,
assignment.notes
};
var json = Serial.Serialize(data);
assignment.is_hold = true;
assignment.deleted_by = entity.UserId;
assignment.modified_on = DateTime.Now;
db.SaveChanges();
result.Entity = entity;
db.SaveChanges();
t_audit_log log = new t_audit_log();
log.type = "MODIFY";
log.json_delete = 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 = "Category not found";
}
}
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
