public ActionResult GetWellWorkovers2(int queryId)
{
if (queryId < 1)
{
return(Json(new List <WellWorkoverReportObject>(), JsonRequestBehavior.AllowGet));
}
var query = new WellWorkoverQueryBuilderServices().GetWellWorkoverQuery(queryId);
if (query == null || query.WellWorkoverQueryId < 1)
{
return(Json(new List <WellWorkoverReportObject>(), JsonRequestBehavior.AllowGet));
}
var wellWorkoverList = new WellWorkoverServices().GetOrderedWellWorkoverReportObjects(query) ?? new List <WellWorkoverReportObject>();
if (!wellWorkoverList.Any())
{
return(Json(new List <WellWorkoverReportObject>(), JsonRequestBehavior.AllowGet));
}
var jsonResult = Json(wellWorkoverList, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
private List <WellWorkoverQuery> GetWellWorkoverQueries()
{
var previousQueries = new WellWorkoverQueryBuilderServices().GetAllOrderedWellWorkoverQueries() ?? new List <WellWorkoverQuery>();
if (!previousQueries.Any())
{
return(new List <WellWorkoverQuery>());
}
return(previousQueries);
}
public ActionResult IsWellWorkoverQueryExisting()
{
var genVal = new GenericValidator();
try
{
if (Session["_successfulWellWorkoverQuery"] == null)
{
genVal.Code = -1;
return(Json(genVal, JsonRequestBehavior.AllowGet));
}
var queryBuilder = Session["_successfulWellWorkoverQuery"] as WellWorkoverQuery;
if (queryBuilder == null)
{
genVal.Code = -1;
return(Json(genVal, JsonRequestBehavior.AllowGet));
}
var k = new WellWorkoverQueryBuilderServices().IsWellWorkoverQueryExisting(queryBuilder);
if (k)
{
genVal.Code = 5;
return(Json(genVal, JsonRequestBehavior.AllowGet));
}
genVal.Code = -3;
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["_successfulWellWorkoverQuery"] == null)
{
genVal.Error = "Session has expired";
genVal.Code = -1;
return(Json(genVal, JsonRequestBehavior.AllowGet));
}
var queryBuilder = Session["_successfulWellWorkoverQuery"] as WellWorkoverQuery;
if (queryBuilder == null)
{
genVal.Error = "Session has expired";
genVal.Code = -1;
return(Json(genVal, JsonRequestBehavior.AllowGet));
}
queryBuilder.WellWorkoverQueryName = queryName.Trim();
var k = new WellWorkoverQueryBuilderServices().AddWellWorkoverQueryCheckDuplicate(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));
}
}
