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