public JsonResult Manage(SQLCommandHistoryModel model, GridManagingModel manageModel) { if (ModelState.IsValid || manageModel.Operation == GridOperationEnums.Del) { return Json(_sqlCommandServices.ManageSQLCommandHistory(manageModel.Operation, model)); } return Json(new ResponseModel { Success = false, Message = GetFirstValidationResults(ModelState).Message }); }
/// <summary> /// Manage user group /// </summary> /// <param name="operation">the operation</param> /// <param name="model">the user group model</param> /// <returns></returns> public ResponseModel ManageSQLCommandHistory(GridOperationEnums operation, SQLCommandHistoryModel model) { ResponseModel response; AutoMapper.Mapper.CreateMap<SQLCommandHistoryModel, SQLCommandHistory>(); SQLCommandHistory sqlCommandHistory; switch (operation) { case GridOperationEnums.Edit: sqlCommandHistory = _sqlCommandHistoryRepository.GetById(model.Id); sqlCommandHistory.Query = model.Query; sqlCommandHistory.RecordOrder = model.RecordOrder; sqlCommandHistory.RecordActive = model.RecordActive; response = Update(sqlCommandHistory); return response.SetMessage(response.Success ? _localizedResourceServices.T("AdminModule:::SQLCommandHistorys:::Messages:::UpdateSuccessfully:::Update command successfully.") : _localizedResourceServices.T("AdminModule:::SQLCommandHistorys:::Messages:::UpdateFailure:::Update command failed. Please try again later.")); case GridOperationEnums.Add: sqlCommandHistory = AutoMapper.Mapper.Map<SQLCommandHistoryModel, SQLCommandHistory>(model); response = Insert(sqlCommandHistory); return response.SetMessage(response.Success ? _localizedResourceServices.T("AdminModule:::SQLCommandHistorys:::Messages:::CreateSuccessfully:::Create command successfully.") : _localizedResourceServices.T("AdminModule:::SQLCommandHistorys:::Messages:::CreateFailure:::Create command failed. Please try again later.")); case GridOperationEnums.Del: response = Delete(model.Id); return response.SetMessage(response.Success ? _localizedResourceServices.T("AdminModule:::SQLCommandHistorys:::Messages:::DeleteSuccessfully:::Delete command successfully.") : _localizedResourceServices.T("AdminModule:::SQLCommandHistorys:::Messages:::DeleteFailure:::Delete command failed. Please try again later.")); } return new ResponseModel { Success = false, Message = _localizedResourceServices.T("AdminModule:::SQLCommandHistorys:::Messages:::ObjectNotFounded:::Command is not founded.") }; }
/// <summary> /// Save a SQL request into history for later use /// </summary> /// <param name="request"></param> public ResponseModel SaveCommand(SQLRequest request) { if (request.Query == null) { return new ResponseModel { Success = true }; } var last = GetLastCommand(); if (last != null && last.Query == request.Query) { return new ResponseModel { Success = true }; } var history = new SQLCommandHistoryModel { Query = request.Query }; var response = Insert(history); return response.SetMessage(response.Success ? _localizedResourceServices.T("AdminModule:::News:::Messages:::CreateSuccessfully:::Create news successfully.") : _localizedResourceServices.T("AdminModule:::News:::Messages:::CreateFailure:::Insert news failed. Please try again later.")); }
public ResponseModel Insert(SQLCommandHistoryModel historyModel) { var commandHistory = new SQLCommandHistory { Query = historyModel.Query, RecordActive = true }; return Insert(commandHistory); }