public bool IsWellCompletionQueryExisting(WellCompletionQuery wellCompletionQuery)
{
try
{
if (wellCompletionQuery == null)
{
return(false);
}
using (var db = new QueryBuilderEntities())
{
if (db.WellCompletionQueries.Count(m =>
m.WellId == wellCompletionQuery.WellId &&
m.CompanyId == wellCompletionQuery.CompanyId &&
(m.StartDate != null && m.StartDate.Value.Year == wellCompletionQuery.StartDate.Value.Year && wellCompletionQuery.StartDate != null) &&
(m.EndDate != null && m.EndDate.Value.Year == wellCompletionQuery.EndDate.Value.Year && wellCompletionQuery.EndDate != null) &&
m.EquipmentId == wellCompletionQuery.EquipmentId &&
m.TerrainId == wellCompletionQuery.TerrainId &&
m.ZoneId == wellCompletionQuery.ZoneId &&
m.CompletionTypeId == wellCompletionQuery.CompletionTypeId &&
m.WellClassId == wellCompletionQuery.WellClassId &&
m.WellTypeId == wellCompletionQuery.WellTypeId
) > 0)
{
return(true);
}
return(false);
}
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
return(false);
}
}
public long AddWellCompletionQueryCheckDuplicate(WellCompletionQuery wellCompletionQuery)
{
try
{
if (wellCompletionQuery == null)
{
return(-2);
}
using (var db = new QueryBuilderEntities())
{
if (db.WellCompletionQueries.Any())
{
if (db.WellCompletionQueries.Count(m => m.WellId == wellCompletionQuery.WellId &&
m.CompanyId == wellCompletionQuery.CompanyId &&
(m.StartDate != null && m.StartDate.Value.Year == wellCompletionQuery.StartDate.Value.Year && wellCompletionQuery.StartDate != null) &&
(m.EndDate != null && m.EndDate.Value.Year == wellCompletionQuery.EndDate.Value.Year && wellCompletionQuery.EndDate != null) &&
m.EquipmentId == wellCompletionQuery.EquipmentId &&
m.TerrainId == wellCompletionQuery.TerrainId &&
m.ZoneId == wellCompletionQuery.ZoneId &&
m.CompletionTypeId == wellCompletionQuery.CompletionTypeId &&
m.WellClassId == wellCompletionQuery.WellClassId &&
m.WellTypeId == wellCompletionQuery.WellTypeId
) > 0)
{
return(-3);
}
if (db.WellCompletionQueries.Count(m => m.WellCompletionQueryName.ToLower().Trim().Replace(" ", "") == wellCompletionQuery.WellCompletionQueryName.ToLower().Trim().Replace(" ", "")
) > 0)
{
return(-4);
}
}
var processedWellCompletionQuery = db.WellCompletionQueries.Add(wellCompletionQuery);
db.SaveChanges();
return(processedWellCompletionQuery.WellCompletionQueryId);
}
}
catch (Exception ex)
{
ErrorLogger.LogEror(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public ActionResult GetWellCompletions(WellCompletionQuery queryBuilder)
{
if (queryBuilder == null)
{
return(Json(new List <WellCompletionReportObject>(), JsonRequestBehavior.AllowGet));
}
if (queryBuilder.EquipmentId < 1 && queryBuilder.WellTypeId < 1 && queryBuilder.CompanyId < 1 && ((queryBuilder.StartDate != null && queryBuilder.StartDate.Value.Year == 0001) || (queryBuilder.StartDate == null)) && ((queryBuilder.EndDate != null && queryBuilder.EndDate.Value.Year == 0001) || (queryBuilder.EndDate == null)) && queryBuilder.CompletionTypeId < 1 && queryBuilder.WellClassId < 1 && queryBuilder.TerrainId < 1 && queryBuilder.ZoneId < 1 && queryBuilder.WellId < 1)
{
return(Json(new List <WellCompletionReportObject>(), JsonRequestBehavior.AllowGet));
}
var wellCompletionList = new WellCompletionServices().GetWellCompletionReports(queryBuilder) ?? new List <WellCompletionReportObject>();
if (!wellCompletionList.Any())
{
return(Json(new List <WellCompletionReportObject>(), JsonRequestBehavior.AllowGet));
}
Session["_successfulWellCompletionQuery"] = queryBuilder;
var jsonResult = Json(wellCompletionList, JsonRequestBehavior.AllowGet);
jsonResult.MaxJsonLength = int.MaxValue;
return(jsonResult);
}
