private void SoftDelete(tblT_SOWIssue sowIssue)
{
if (sowIssue != null)
{
sowIssue.Status_FK = (int)RecordStatus.Deleted;
}
}
private void HardDelete(tblT_SOWIssue sowIssue)
{
if (sowIssue != null)
{
Db.tblT_SOWIssue.Remove(sowIssue);
}
}
public void Update(SOWIssueDTO sowIssueDTO, DateTime dateStamp)
{
if (sowIssueDTO == null)
{
throw new ArgumentNullException("SOWIssue model is null.");
}
tblT_SOWIssue sowIssue = sowIssueFactory.CreateFromDbAndUpdateFromDTO(sowIssueDTO, dateStamp);
}
public tblT_SOWIssue Insert(SOWIssueDTO sowIssueDTO, DateTime dateStamp)
{
if (sowIssueDTO == null)
{
throw new ArgumentNullException("SOWIssue model is null.");
}
tblT_SOWIssue sowIssue = sowIssueFactory.CreateFromDTO(sowIssueDTO, dateStamp);
return(Db.tblT_SOWIssue.Add(sowIssue));
}
public tblT_SOWIssue CreateFromDTO(SOWIssueDTO sowIssueDTO, DateTime dateStamp)
{
if (sowIssueDTO == null)
{
throw new ArgumentNullException("SOWIssue model is null.");
}
sowIssueDTO.Status_FK = (int)RecordStatus.Active;
sowIssueDTO.CreatedBy = User.Username;
sowIssueDTO.CreatedDate = dateStamp;
sowIssueDTO.UpdatedBy = User.Username;
sowIssueDTO.UpdatedDate = dateStamp;
tblT_SOWIssue sowIssue = sowIssueDTO.ToObject <tblT_SOWIssue>();
if (!string.IsNullOrEmpty(sowIssueDTO.FilePhotoInBase64))
{
sowIssue.Foto = new WebImageConverter().GetBytesFromBase64(sowIssueDTO.FilePhotoInBase64, false);
}
sowIssue.IssueType_FK = sowIssueDTO.IssueType_FK;
sowIssue.SOWAssign_FK = sowIssueDTO.SOWAssign_FK;
return(sowIssue);
}
public SaveResult <SOWIssueEntryModel> Save(SOWIssueDTO sowIssueDTO, DateTime dateStamp)
{
ModelValidationResult validationResult = sowIssueValidator.Validate(sowIssueDTO);
bool success = false;
SOWIssueEntryModel model = null;
if (validationResult.IsValid)
{
tblT_SOWIssue sowIssue = Insert(sowIssueDTO, dateStamp);
Db.SaveChanges();
success = true;
model = sowIssueEntryDataProvider.Get(sowIssue.SOWIssue_PK);
}
return(new SaveResult <SOWIssueEntryModel>
{
Success = success,
Message = validationResult.IsValid ? "Data successfully created." : "Validation error occured.",
Model = model,
ValidationResult = validationResult
});
}
public DeleteResult <tblT_SOWIssue> Execute(int sowIssuePK, DeleteMethod deleteMethod)
{
tblT_SOWIssue sowIssue = Db.tblT_SOWIssue.Find(sowIssuePK);
if (sowIssue == null)
{
return(new DeleteResult <tblT_SOWIssue>()
{
Success = false,
Message = $"Id '{sowIssuePK}' is not found.",
Record = null
});
}
switch (deleteMethod)
{
case DeleteMethod.Soft:
SoftDelete(sowIssue);
break;
case DeleteMethod.Hard:
HardDelete(sowIssue);
break;
default:
break;
}
Db.SaveChanges();
return(new DeleteResult <tblT_SOWIssue>()
{
Success = true,
Message = $"SOWIssue with Id '{sowIssuePK}' successfully deleted.",
Record = sowIssue
});
}
