public GeneralResponse EditQuery(EditQueryRequestOld request)
{
GeneralResponse response = new GeneralResponse();
Query query = new Query();
query = _queryRepository.FindBy(request.ID);
if (query != null)
{
try
{
query.ModifiedDate = PersianDateTime.Now;
query.ModifiedEmployee = _employeeRepository.FindBy(request.ModifiedEmployeeID);
query.PrmDefinition = request.PrmDefinition;
query.PrmValues = request.PrmValues;
query.QueryText = request.QueryText;
query.Title = request.Title;
if (query.RowVersion != request.RowVersion)
{
response.ErrorMessages.Add("EditConcurrencyKey");
return(response);
}
else
{
query.RowVersion += 1;
}
if (query.GetBrokenRules().Count() > 0)
{
foreach (BusinessRule businessRule in query.GetBrokenRules())
{
response.ErrorMessages.Add(businessRule.Rule);
}
return(response);
}
_queryRepository.Save(query);
_uow.Commit();
////response.success = true;
}
catch (Exception ex)
{
response.ErrorMessages.Add(ex.Message);
}
}
else
{
response.ErrorMessages.Add("NoItemToEditKey");
}
return(response);
}
public ActionResult Edit(string id, QueryDetailView queryDetailView)
{
#region Access Check
bool hasPermission = GetEmployee().IsGuaranteed("Query_Update");
if (!hasPermission)
{
ModelState.AddModelError("", "AccessDenied");
return(View(queryDetailView));
}
#endregion
queryDetailView.EmployeeView = GetEmployee();
if (ModelState.IsValid)
{
try
{
EditQueryRequestOld request = new EditQueryRequestOld();
request.ID = Guid.Parse(id);
request.ModifiedEmployeeID = GetEmployee().ID;
request.PrmDefinition = queryDetailView.QueryView.PrmDefinition;
request.QueryText = queryDetailView.QueryView.QueryText;
request.PrmValues = queryDetailView.QueryView.PrmValues;
request.Title = queryDetailView.QueryView.Title;
request.RowVersion = queryDetailView.QueryView.RowVersion;
GeneralResponse response = this._queryService.EditQuery(request);
if (response.success)
{
return(RedirectToAction("Index"));
}
else
{
foreach (string error in response.ErrorMessages)
{
ModelState.AddModelError("", error);
}
return(View(queryDetailView));
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.Message);
return(View(queryDetailView));
}
}
return(View(queryDetailView));
}
