public SavedSearchFilterDto UpdateSavedSearchFilter(SavedSearchFilterDto model)
{
try
{
var oldSavedFilterSearch = _context.savedsearchfilters.FirstOrDefault(x => x.Id == model.Id);
var updatedSavedFilterSearch = Mapper.Map <savedsearchfilter>(model);
updatedSavedFilterSearch.Created = DateTime.Now;
updatedSavedFilterSearch.CreatedBy = model.CreatedBy;
_context.Entry(oldSavedFilterSearch).CurrentValues.SetValues(updatedSavedFilterSearch);
_context.SaveChanges();
return(model);
}
catch (DbEntityValidationException ex)
{
var errorMsg = EisHelper.ParseDbEntityValidationException(ex);
_logger.LogError(LogEntryType.VendorProductService, errorMsg, ex.StackTrace);
throw ex;
}
catch (Exception ex)
{
_logger.LogError(LogEntryType.VendorProductService, EisHelper.GetExceptionMessage(ex), ex.StackTrace);
throw ex;
}
}
public SavedSearchFilterDto CreateSavedSearchFilter(SavedSearchFilterDto model)
{
try
{
var savedsearchfilter = Mapper.Map <savedsearchfilter>(model);
savedsearchfilter.Created = DateTime.UtcNow;
savedsearchfilter.CreatedBy = model.CreatedBy;
_context.savedsearchfilters.Add(savedsearchfilter);
_context.SaveChanges();
model.Id = savedsearchfilter.Id;
return(model);
}
catch (DbEntityValidationException ex)
{
var errorMsg = EisHelper.ParseDbEntityValidationException(ex);
_logger.LogError(LogEntryType.VendorService, errorMsg, ex.StackTrace);
throw ex;
}
catch (Exception ex)
{
_logger.LogError(LogEntryType.VendorService, EisHelper.GetExceptionMessage(ex), ex.StackTrace);
throw ex;
}
}
public JsonResult _ManageSearchFilter(int selectedSearchFilter, string filterName, string searchString)
{
var isNameExists = _savedSearchFilterService.IsFilterExist(selectedSearchFilter,
EnumSavedSearchFilters.VendorProduct,
filterName, User.Identity.Name);
if (isNameExists)
{
return(Json(new { status = "error", message = "filter name already exists." }, JsonRequestBehavior.AllowGet));
}
var model = new SavedSearchFilterDto()
{
Created = DateTime.Now,
CreatedBy = User.Identity.Name,
Id = selectedSearchFilter,
SavedSearchFilterId = Convert.ToInt32(EnumSavedSearchFilters.VendorProduct),
SavedSearchFilterName = filterName,
SearchString = searchString
};
if (model.Id == 0)
{
_savedSearchFilterService.CreateSavedSearchFilter(model);
}
else
{
_savedSearchFilterService.UpdateSavedSearchFilter(model);
}
return(Json(new { status = "success", message = "filter search saved successfully." }, JsonRequestBehavior.AllowGet));
}
