public ActionResult DataConnection_Update([DataSourceRequest] DataSourceRequest request, ConnectorDTO _dtoConnector)
{
if (_dtoConnector != null && ModelState.IsValid)
{
_dtoConnector.SessionId = Session.SessionID;
objConnectorRepository = new ConnectorRepository(_dtoConnector);
objConnectorRepository.SaveConnection();
}
return(Json(new[] { _dtoConnector }.ToDataSourceResult(request, ModelState), JsonRequestBehavior.AllowGet));
}
public ActionResult DataConnection_Insert([DataSourceRequest] DataSourceRequest request, ConnectorDTO _dtoConnector)
{
try
{
if (_dtoConnector != null && ModelState.IsValid)
{
_dtoConnector.SessionId = Session.SessionID;
objConnectorRepository = new ConnectorRepository(_dtoConnector);
objConnectorRepository.SaveConnection();
}
return(Json(new[] { _dtoConnector }.ToDataSourceResult(request, ModelState), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
ModelState.AddModelError(string.Empty, ex.Message);
return(Content(ex.Message + ex.InnerException.Message));
}
}
public ActionResult CreateDatabaseConnector(ConnectorsDTO objDCDTO)
{
if (ModelState.IsValid)
{
try
{
objDCDTO.SessionId = Session.SessionID;
objConnectorRepository = new ConnectorRepository(objDCDTO);
if (Request.Form["btnTest"] != null)
{
objConnectorRepository.TestConnection();
return(Json(new { success = true, message = Resources.Resources.ConnectorTestMessage }));
}
else
{
objConnectorRepository.SaveConnection();
GetAllExistingConnections();
return(Json(new { success = true, message = Resources.Resources.ConnectorSaveMessage }));
}
}
catch (Exception ex)
{
//ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists, see your system administrator.");
//Response.StatusCode = 400;
//ModelState.AddModelError(string.Empty, ex.Message + ex.InnerException.Message);
//return Content(ex.Message + ex.InnerException.Message);
return(Json(new { success = false, message = ex.Message + ex.InnerException.Message }));
}
}
else
{
return(Content(Resources.Resources.ConnectorValidationFailed));
}
}