private static List <DPRFull> AssignDataInput()
{
try
{
List <DPRFull> objDPR = new List <DPRFull>();
DPRFull obj = new DPRFull();
DPRFull obj1 = new DPRFull();
obj.FormalWellName = "BL6P10";
obj.CommonWellName = "BL6P10";
obj.BasinName = "Belize";
obj.BlockNumber = "14";
obj.LatDeg = 5;
obj.LatMin = 37;
obj.LatSec = 6.95;
obj.Ns = "S";
obj.LongDeg = 11;
obj.LongMin = 54;
obj.LongSec = 44.9;
obj.Ew = "E";
obj.DrillingContractor = "KCAD";
obj.RigName = "BBLT";
obj.OwnerDrilled = 1;
obj.HoleType = "N";
obj.LocatorWell = "N";
obj.MultiLateral = "N";
obj.WellType = "D";
obj.PlayType = "H";
obj.RigType = "PL";
obj.DrillingMethod = "TAM";
obj.UnitOfMeasurement = "F";
obj.WaterDepth = 1281;
obj.SpudDepthBrt = 1482;
obj.Mtd = 17900;
obj.Tvd = 8138;
obj.SubSalt = "N";
obj.ComplexWell = "N";
obj.MaximumAngleDegrees = 81;
obj.FinalDrillBitSize = 12.25;
obj.DryHoleDays = 31.2;
objDPR.Add(obj);
obj1.FormalWellName = "bl6p10";
objDPR.Add(obj1);
return(objDPR);
}
catch (Exception ex)
{
throw ex;
}
}
private static void ValidateTDDPRColumns(DPRTDData obj, List <DPRFull> objDPRList, int rowindex)
{
ErrorMessage errorObj = new ErrorMessage();
ValidationError objerror = new ValidationError();
double?mtd1 = 0;
double?mtd2 = 0;
try
{
for (int j = 0; j < obj.NoOfDay.Count; j++)
{
if (obj.NoOfDay[j] == null)
{
//Console.WriteLine(errorObj.MDays);
objerror.WellName = obj.WellName;
objerror.ErrorMessage = errorObj.MDays;
objerror.Row = j + rowindex + 3;
obj.Errors.Add(objerror);
}
if (obj.Actualdepth[j] == null)
{
// Console.WriteLine(errorObj.MDepths);
objerror.WellName = obj.WellName;
objerror.ErrorMessage = errorObj.MDepths;
objerror.Row = j + rowindex + 3;
obj.Errors.Add(objerror);
}
if (obj.HoleSize[j] == null)
{
//Console.WriteLine(errorObj.MHole);
objerror.WellName = obj.WellName;
objerror.ErrorMessage = errorObj.MHole;
objerror.Row = j + rowindex + 3;
obj.Errors.Add(objerror);
}
}
CheckDUplicate(obj, rowindex);
CheckDepthsSpike(obj, rowindex);
CheckDaysSeq(obj, rowindex);
CheckDaysDesc(obj, rowindex);
for (int i = 0; i < objDPRList.Count; i++)
{
DPRFull objFull = objDPRList[i];
if (obj.WellName == objFull.FormalWellName)
{
mtd1 = objFull.Mtd + (objFull.Mtd * 0.01);
mtd2 = objFull.Mtd - (objFull.Mtd * 0.01);
if (!obj.Actualdepth.Contains(objFull.Mtd))
{
//Console.WriteLine(errorObj.MTDMissing);
objerror.WellName = obj.WellName;
objerror.Row = i + rowindex + 3;
objerror.ErrorMessage = errorObj.MTDMissing;
obj.Errors.Add(objerror);
}
double?max = obj.Actualdepth.Max();
if (!(max < mtd1 && max > mtd2))
{
//Console.WriteLine(errorObj.MTDLargest);
objerror.WellName = obj.WellName;
objerror.Row = i + rowindex + 3;
objerror.ErrorMessage = errorObj.MTDLargest;
obj.Errors.Add(objerror);
}
if (obj.HoleSize.Last() != objFull.FinalDrillBitSize)
{
//Console.WriteLine(errorObj.HSDrill);
objerror.WellName = obj.WellName;
objerror.Row = i + rowindex + 3;
objerror.ErrorMessage = errorObj.HSDrill;
obj.Errors.Add(objerror);
}
for (int j = 0; j < obj.NoOfDay.Count; j++)
{
if (obj.Actualdepth[j] < mtd1 && obj.Actualdepth[j] > mtd2)
{
obj.DepthFlag = true;
}
else
{
obj.DepthFlag = false;
}
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw ex;
}
}
private static void ValidateDPRFullData(List <DPRTDData> objlist, List <DPRFull> objFull, int rowindex)
{
ErrorMessage errorObj = new ErrorMessage();
ValidationError objerror = new ValidationError();
bool status = false;
for (int i = 0; i < objFull.Count; i++)
{
DPRFull objDPRFull = objFull[i];
for (int j = 0; j < objlist.Count; j++)
{
if (objlist[j].WellName == objDPRFull.FormalWellName)
{
status = true;
break;
}
else
{
status = false;
}
}
if (!status)
{
if (objDPRFull.DryHoleDays > 10)
{
//Console.WriteLine(errorObj.Data);
objerror.WellName = objDPRFull.FormalWellName;
objerror.ErrorMessage = errorObj.Data;
objerror.Row = i;
objDPRFull.Errors.Add(objerror);
}
else
{
//Console.WriteLine(errorObj.LT10);
objerror.WellName = objDPRFull.FormalWellName;
objerror.ErrorMessage = errorObj.LT10;
objerror.Row = i;
objDPRFull.Errors.Add(objerror);
}
}
}
for (int i = 0; i < objlist.Count; i++)
{
for (int j = 0; j < objFull.Count; j++)
{
if (objFull[j].FormalWellName.ToLower() == objlist[i].WellName.ToLower())
{
if (!objlist[i].WellName.Equals(objFull[j].FormalWellName, StringComparison.Ordinal))
{
//Console.WriteLine(errorObj.Case);
objerror.WellName = objlist[i].WellName;
objerror.ErrorMessage = errorObj.Case;
objerror.Row = i + rowindex + 3;
objlist[i].Errors.Add(objerror);
}
break;
}
else
{
objerror.WellName = objlist[i].WellName;
objerror.ErrorMessage = errorObj.TD;
objerror.Row = i + rowindex + 3;
objlist[i].Errors.Add(objerror);
}
if (objFull[j].UnitOfMeasurement != objlist[i].Units)
{
//Console.WriteLine(errorObj.UnitsMatch);
objerror.WellName = objlist[i].WellName;
objerror.ErrorMessage = errorObj.UnitsMatch;
objerror.Row = i + rowindex + 3;
objlist[i].Errors.Add(objerror);
}
}
}
}
