public ActionResult GetWells2(int queryId)
{
if (queryId < 1)
{
return(Json(new List <WellReportObject>(), JsonRequestBehavior.AllowGet));
}
var query = new WellQueryBuilderServices().GetWellQuery(queryId);
if (query == null || query.WellQueryId < 1)
{
return(Json(new List <WellReportObject>(), JsonRequestBehavior.AllowGet));
}
var wellList = new WellServices().GetOrderedWellReportObjects(query) ?? new List <WellReportObject>();
if (!wellList.Any())
{
return(Json(new List <WellReportObject>(), JsonRequestBehavior.AllowGet));
}
var jsonResult = Json(wellList, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
private List <WellQuery> GetWellQueries()
{
var previousQueries = new WellQueryBuilderServices().GetAllOrderedWellQueries() ?? new List <WellQuery>();
if (!previousQueries.Any())
{
return(new List <WellQuery>());
}
return(previousQueries);
}
public ActionResult IsWellQueryExisting()
{
var genVal = new GenericValidator();
try
{
if (Session["_successfulWellQuery"] == null)
{
genVal.Code = -1;
return(Json(genVal, JsonRequestBehavior.AllowGet));
}
var queryBuilder = Session["_successfulWellQuery"] as WellQuery;
if (queryBuilder == null)
{
genVal.Code = -1;
return(Json(genVal, JsonRequestBehavior.AllowGet));
}
var k = new WellQueryBuilderServices().IsWellQueryExisting(queryBuilder);
if (k)
{
genVal.Code = 5;
return(Json(genVal, JsonRequestBehavior.AllowGet));
}
if (Roles.IsUserInRole("Admin"))
{
genVal.Code = -5;
}
else
{
genVal.Code = -2;
}
return(Json(genVal, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
genVal.Code = 0;
return(Json(genVal, JsonRequestBehavior.AllowGet));
}
}
public ActionResult SaveSuccessfulQuery(string queryName)
{
var genVal = new GenericValidator();
try
{
if (string.IsNullOrEmpty(queryName))
{
genVal.Error = "Please supply all required fields and try again";
genVal.Code = -1;
return(Json(genVal, JsonRequestBehavior.AllowGet));
}
if (Session["_successfulWellQuery"] == null)
{
genVal.Error = "Session has expired";
genVal.Code = -1;
return(Json(genVal, JsonRequestBehavior.AllowGet));
}
var queryBuilder = Session["_successfulWellQuery"] as WellQuery;
if (queryBuilder == null)
{
genVal.Error = "Session has expired";
genVal.Code = -1;
return(Json(genVal, JsonRequestBehavior.AllowGet));
}
queryBuilder.WellQueryName = queryName.Trim();
var k = new WellQueryBuilderServices().AddWellQueryCheckDuplicate(queryBuilder);
if (k < 1)
{
if (k == -3)
{
genVal.Error = "Query already exists";
genVal.Code = -3;
return(Json(genVal, JsonRequestBehavior.AllowGet));
}
if (k == -4)
{
genVal.Error = "Query Name already exists. Please provide a different one";
genVal.Code = -3;
return(Json(genVal, JsonRequestBehavior.AllowGet));
}
genVal.Error = "Process Failed! Please contact the Admin or try again later";
genVal.Code = 0;
return(Json(genVal, JsonRequestBehavior.AllowGet));
}
genVal.Error = "Query was successfully saved";
genVal.Code = (int)k;
return(Json(genVal, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
//ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
genVal.Error = "An unknown error was encountered. Query could not be saved. Please try again.";
genVal.Code = 0;
return(Json(genVal, JsonRequestBehavior.AllowGet));
}
}
