private void SoftDelete(tblT_SOWTrack sowTrack) { if (sowTrack != null) { sowTrack.Status_FK = (int)RecordStatus.Deleted; } }
private void HardDelete(tblT_SOWTrack sowTrack) { if (sowTrack != null) { Db.tblT_SOWTrack.Remove(sowTrack); } }
private void UpdateSowTrack(SOWDTO sowDTO, DateTime dateStamp) { if (sowDTO == null) { throw new ArgumentNullException("SOW model is null."); } var tracks = Db.tblT_SOWTrack.Where(x => x.SOW_FK == sowDTO.SOW_PK); foreach (var track in tracks) { Db.tblT_SOWTrack.Remove(track); } foreach (var sowTrackDTO in sowDTO.SOWTracks) { if (sowTrackDTO.TipePekerjaan_FK == 0) { continue; } sowTrackDTO.SOW_FK = sowDTO.SOW_PK; var bts = new BTSQuery(Db).GetByPrimaryKey(sowDTO.BTS_FK); tblT_SOWTrack sowTrack = sowTrackFactory.CreateFromDTO(sowTrackDTO, dateStamp); Db.tblT_SOWTrack.Add(sowTrack); } }
public void Update(SOWTrackDTO sowTrackDTO, DateTime dateStamp) { if (sowTrackDTO == null) { throw new ArgumentNullException("SOWTrack model is null."); } tblT_SOWTrack sowTrack = sowTrackFactory.CreateFromDbAndUpdateFromDTO(sowTrackDTO, dateStamp); }
public tblT_SOWTrack Insert(SOWTrackDTO sowTrackDTO, DateTime dateStamp) { if (sowTrackDTO == null) { throw new ArgumentNullException("SOWTrack model is null."); } tblT_SOWTrack sowTrack = sowTrackFactory.CreateFromDTO(sowTrackDTO, dateStamp); return(Db.tblT_SOWTrack.Add(sowTrack)); }
public tblT_SOWTrack CreateFromDTO(SOWTrackDTO sowTrackDTO, DateTime dateStamp) { if (sowTrackDTO == null) { throw new ArgumentNullException("SOWTrack model is null."); } sowTrackDTO.Status_FK = (int)RecordStatus.Active; sowTrackDTO.CreatedBy = User.Username; sowTrackDTO.CreatedDate = dateStamp; sowTrackDTO.UpdatedBy = User.Username; sowTrackDTO.UpdatedDate = dateStamp; tblT_SOWTrack sowTrack = sowTrackDTO.ToObject <tblT_SOWTrack>(); return(sowTrack); }
public SaveResult <SOWTrackEntryModel> Save(SOWTrackDTO sowTrackDTO, DateTime dateStamp) { ModelValidationResult validationResult = sowTrackValidator.Validate(sowTrackDTO); bool success = false; SOWTrackEntryModel model = null; if (validationResult.IsValid) { tblT_SOWTrack sowTrack = Insert(sowTrackDTO, dateStamp); Db.SaveChanges(); success = true; model = sowTrackEntryDataProvider.Get(sowTrack.SOWTrack_PK); } return(new SaveResult <SOWTrackEntryModel> { Success = success, Message = validationResult.IsValid ? "Data successfully created." : "Validation error occured.", Model = model, ValidationResult = validationResult }); }
public DeleteResult <tblT_SOWTrack> Execute(int sowTrackPK, DeleteMethod deleteMethod) { tblT_SOWTrack sowTrack = Db.tblT_SOWTrack.Find(sowTrackPK); if (sowTrack == null) { return(new DeleteResult <tblT_SOWTrack>() { Success = false, Message = $"Id '{sowTrackPK}' is not found.", Record = null }); } switch (deleteMethod) { case DeleteMethod.Soft: SoftDelete(sowTrack); break; case DeleteMethod.Hard: HardDelete(sowTrack); break; default: break; } Db.SaveChanges(); return(new DeleteResult <tblT_SOWTrack>() { Success = true, Message = $"SOWTrack with Id '{sowTrackPK}' successfully deleted.", Record = sowTrack }); }