/// <summary>
/// Deprecated Method for adding a new object to the T_WQX_IMPORT_TEMP_MONLOC EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToT_WQX_IMPORT_TEMP_MONLOC(T_WQX_IMPORT_TEMP_MONLOC t_WQX_IMPORT_TEMP_MONLOC)
{
base.AddObject("T_WQX_IMPORT_TEMP_MONLOC", t_WQX_IMPORT_TEMP_MONLOC);
}
/// <summary>
/// Create a new T_WQX_IMPORT_TEMP_MONLOC object.
/// </summary>
/// <param name="tEMP_MONLOC_IDX">Initial value of the TEMP_MONLOC_IDX property.</param>
/// <param name="uSER_ID">Initial value of the USER_ID property.</param>
/// <param name="lATITUDE_MSR">Initial value of the LATITUDE_MSR property.</param>
/// <param name="lONGITUDE_MSR">Initial value of the LONGITUDE_MSR property.</param>
public static T_WQX_IMPORT_TEMP_MONLOC CreateT_WQX_IMPORT_TEMP_MONLOC(global::System.Int32 tEMP_MONLOC_IDX, global::System.String uSER_ID, global::System.String lATITUDE_MSR, global::System.String lONGITUDE_MSR)
{
T_WQX_IMPORT_TEMP_MONLOC t_WQX_IMPORT_TEMP_MONLOC = new T_WQX_IMPORT_TEMP_MONLOC();
t_WQX_IMPORT_TEMP_MONLOC.TEMP_MONLOC_IDX = tEMP_MONLOC_IDX;
t_WQX_IMPORT_TEMP_MONLOC.USER_ID = uSER_ID;
t_WQX_IMPORT_TEMP_MONLOC.LATITUDE_MSR = lATITUDE_MSR;
t_WQX_IMPORT_TEMP_MONLOC.LONGITUDE_MSR = lONGITUDE_MSR;
return t_WQX_IMPORT_TEMP_MONLOC;
}
public static int InsertWQX_IMPORT_TEMP_MONLOC_New(string uSER_ID, string oRG_ID, Dictionary<string, string> colVals)
{
using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities())
{
try
{
//get import config rules
List<ConfigInfoType> _allRules = Utils.GetAllColumnInfo("M");
T_WQX_IMPORT_TEMP_MONLOC a = new T_WQX_IMPORT_TEMP_MONLOC();
a.IMPORT_STATUS_CD = "P";
a.IMPORT_STATUS_DESC = "";
if (!string.IsNullOrEmpty(uSER_ID)) a.USER_ID = uSER_ID;
if (!string.IsNullOrEmpty(oRG_ID)) a.ORG_ID = oRG_ID;
//*************** PRE CUSTOM VALIDATION **********************************************
string _t = null;
_t = Utils.GetValueOrDefault(colVals, "TRIBAL_LAND_IND");
if (!string.IsNullOrEmpty(_t))
{
if (_t.ToUpper() == "TRUE") colVals["TRIBAL_LAND_IND"] = "Y";
if (_t.ToUpper() == "FALSE") colVals["TRIBAL_LAND_IND "] = "N";
}
//if there is a match of county value to reference data text (in case user is importing county text instead of code)
_t = Utils.GetValueOrDefault(colVals, "COUNTY_CODE");
if (!string.IsNullOrEmpty(_t))
{
T_WQX_REF_COUNTY c = db_Ref.GetT_WQX_REF_COUNTY_ByCountyNameAndState(Utils.GetValueOrDefault(colVals, "STATE_CODE"), _t);
if (c != null)
a.COUNTY_CODE = c.COUNTY_CODE;
else
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "COUNTY_CODE");
}
//********************** end custom validation ********************************************
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "MONLOC_ID");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "MONLOC_NAME");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "MONLOC_TYPE");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "MONLOC_DESC");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "HUC_EIGHT");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "HUC_TWELVE");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "TRIBAL_LAND_IND");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "TRIBAL_LAND_NAME");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "LATITUDE_MSR");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "LONGITUDE_MSR");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "SOURCE_MAP_SCALE");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "HORIZ_COLL_METHOD");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "HORIZ_REF_DATUM");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "VERT_MEASURE");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "VERT_MEASURE_UNIT");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "VERT_COLL_METHOD");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "VERT_REF_DATUM");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "COUNTRY_CODE");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "STATE_CODE");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "WELL_TYPE");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "AQUIFER_NAME");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "FORMATION_TYPE");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "WELLHOLE_DEPTH_MSR");
WQX_IMPORT_TEMP_MONLOC_GenVal(ref a, _allRules, colVals, "WELLHOLE_DEPTH_MSR_UNIT");
//*************** POST CUSTOM VALIDATION **********************************************
if (!string.IsNullOrEmpty(a.MONLOC_ID))
if (db_WQX.GetWQX_MONLOC_ByIDString(oRG_ID, a.MONLOC_ID) != null) { a.IMPORT_STATUS_CD = "F"; a.IMPORT_STATUS_DESC += "Monitoring Location ID already exists. "; }
decimal ii;
if (!string.IsNullOrEmpty(a.LATITUDE_MSR))
if (Decimal.TryParse(a.LATITUDE_MSR, out ii) == false) { a.IMPORT_STATUS_CD = "F"; a.IMPORT_STATUS_DESC += "Latitude is not decimal format. "; }
if (!string.IsNullOrEmpty(a.LONGITUDE_MSR))
if (Decimal.TryParse(a.LONGITUDE_MSR, out ii) == false) { a.IMPORT_STATUS_CD = "F"; a.IMPORT_STATUS_DESC += "Longitude is not decimal format. "; }
//*************** END CUSTOM VALIDATION **********************************************
ctx.AddToT_WQX_IMPORT_TEMP_MONLOC(a);
ctx.SaveChanges();
return a.TEMP_MONLOC_IDX;
}
catch (Exception ex)
{
return 0;
}
}
}
public static void WQX_IMPORT_TEMP_MONLOC_GenVal(ref T_WQX_IMPORT_TEMP_MONLOC a, List<ConfigInfoType> t, Dictionary<string, string> colVals, string f)
{
string _value = Utils.GetValueOrDefault(colVals, f); //supplied value for this field
var _rules = t.Find(item => item._name == f); //import rules for this field
if (!string.IsNullOrEmpty(_value)) //if value is supplied
{
_value = _value.Trim();
//strings: field length validation and substring
if (_rules._datatype == "" && _rules._length != null)
{
if (_value.Length > _rules._length)
{
a.IMPORT_STATUS_CD = "F";
a.IMPORT_STATUS_DESC = (a.IMPORT_STATUS_DESC + f + " length (" + _rules._length + ") exceeded. ").SubStringPlus(0, 100);
_value = _value.SubStringPlus(0, (int)_rules._length);
}
}
//integers: check type
if (_rules._datatype == "int")
{
int n;
if (int.TryParse(_value, out n) == false)
{
a.IMPORT_STATUS_CD = "F";
a.IMPORT_STATUS_DESC = (a.IMPORT_STATUS_DESC + f + " not numeric. ").SubStringPlus(0, 100);
}
}
//ref data lookup
if (_rules._fkey.Length > 0)
{
if (db_Ref.GetT_WQX_REF_DATA_ByKey(_rules._fkey, _value) == false)
{
a.IMPORT_STATUS_CD = "F";
a.IMPORT_STATUS_DESC = (a.IMPORT_STATUS_DESC + f + " not valid. ").SubStringPlus(0, 100);
}
}
}
else
{
//required check
if (_rules._req == "Y")
{
_value = "-";
a.IMPORT_STATUS_CD = "F";
a.IMPORT_STATUS_DESC = (a.IMPORT_STATUS_DESC + "Required field " + f + " missing. ").SubStringPlus(0, 100);
}
}
//finally set the value before returning
if (_rules._datatype == "")
typeof(T_WQX_IMPORT_TEMP_MONLOC).GetProperty(f).SetValue(a, _value);
else if (_rules._datatype == "int")
typeof(T_WQX_IMPORT_TEMP_MONLOC).GetProperty(f).SetValue(a, _value.ConvertOrDefault<int?>());
}
// *************************** IMPORT: MONLOC ******************************
// *****************************************************************************
public static int InsertOrUpdateWQX_IMPORT_TEMP_MONLOC(int? tEMP_MONLOC_IDX, string uSER_ID, int? mONLOC_IDX, string oRG_ID, string mONLOC_ID,
string mONLOC_NAME, string mONLOC_TYPE, string mONLOC_DESC, string hUC_EIGHT, string HUC_TWELVE, string tRIBAL_LAND_IND, string tRIBAL_LAND_NAME, string lATITUDE_MSR,
string lONGITUDE_MSR, int? sOURCE_MAP_SCALE, string hORIZ_ACCURACY, string hORIZ_ACCURACY_UNIT, string hORIZ_COLL_METHOD, string hORIZ_REF_DATUM, string vERT_MEASURE,
string vERT_MEASURE_UNIT, string vERT_COLL_METHOD, string vERT_REF_DATUM, string cOUNTRY_CODE, string sTATE_CODE, string cOUNTY_CODE, string wELL_TYPE,
string aQUIFER_NAME, string fORMATION_TYPE, string wELLHOLE_DEPTH_MSR, string wELLHOLE_DEPTH_MSR_UNIT, string sTATUS_CD, string sTATUS_DESC)
{
using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities())
{
Boolean insInd = false;
try
{
T_WQX_IMPORT_TEMP_MONLOC a = new T_WQX_IMPORT_TEMP_MONLOC();
if (tEMP_MONLOC_IDX != null)
a = (from c in ctx.T_WQX_IMPORT_TEMP_MONLOC
where c.TEMP_MONLOC_IDX == tEMP_MONLOC_IDX
select c).FirstOrDefault();
else
insInd = true;
if (uSER_ID != null)
{
a.USER_ID = uSER_ID;
if (uSER_ID.Length > 25) { sTATUS_CD = "F"; sTATUS_DESC += "User ID length exceeded. "; }
}
if (mONLOC_IDX != null) a.MONLOC_IDX = mONLOC_IDX;
if (oRG_ID != null) a.ORG_ID = oRG_ID;
if (mONLOC_ID != null)
{
a.MONLOC_ID = mONLOC_ID.SubStringPlus(0, 35).Trim();
if (mONLOC_ID.Length > 35) { sTATUS_CD = "F"; sTATUS_DESC += "Monitoring Location ID length exceeded. "; }
T_WQX_MONLOC mtemp = db_WQX.GetWQX_MONLOC_ByIDString(oRG_ID, mONLOC_ID);
if (mtemp != null) { sTATUS_CD = "F"; sTATUS_DESC += "Monitoring Location ID already exists. "; }
}
if (!string.IsNullOrEmpty(mONLOC_NAME))
{
a.MONLOC_NAME = mONLOC_NAME.SubStringPlus(0, 255).Trim();
if (mONLOC_NAME.Length > 255) { sTATUS_CD = "F"; sTATUS_DESC += "Monitoring Location Name length exceeded. "; }
}
if (!string.IsNullOrEmpty(mONLOC_TYPE))
{
a.MONLOC_TYPE = mONLOC_TYPE.SubStringPlus(0, 45);
if (db_Ref.GetT_WQX_REF_DATA_ByKey("MonitoringLocationType", mONLOC_TYPE.Trim()) == false) { sTATUS_CD = "F"; sTATUS_DESC += "Monitoring Location Type not valid. "; }
}
if (!string.IsNullOrEmpty(mONLOC_DESC))
{
a.MONLOC_DESC = mONLOC_DESC.SubStringPlus(0, 1999);
if (mONLOC_DESC.Length > 1999) { sTATUS_CD = "F"; sTATUS_DESC += "Monitoring Location Description length exceeded. "; }
}
if (!string.IsNullOrEmpty(hUC_EIGHT))
{
a.HUC_EIGHT = hUC_EIGHT.Trim().SubStringPlus(0, 8);
if (hUC_EIGHT.Length > 8) { sTATUS_CD = "F"; sTATUS_DESC += "HUC8 length exceeded. "; }
}
if (!string.IsNullOrEmpty(HUC_TWELVE))
{
a.HUC_TWELVE = HUC_TWELVE.Trim().SubStringPlus(0, 12);
if (HUC_TWELVE.Length > 12) { sTATUS_CD = "F"; sTATUS_DESC += "HUC12 length exceeded. "; }
}
if (!string.IsNullOrEmpty(tRIBAL_LAND_IND))
{
if (tRIBAL_LAND_IND.ToUpper() == "TRUE") tRIBAL_LAND_IND = "Y";
if (tRIBAL_LAND_IND.ToUpper() == "FALSE") tRIBAL_LAND_IND = "N";
a.TRIBAL_LAND_IND = tRIBAL_LAND_IND.SubStringPlus(0, 1);
if (tRIBAL_LAND_IND.Length > 1) { sTATUS_CD = "F"; sTATUS_DESC += "Tribal Land Indicator length exceeded. "; }
}
if (!string.IsNullOrEmpty(tRIBAL_LAND_NAME))
{
a.TRIBAL_LAND_NAME = tRIBAL_LAND_NAME.SubStringPlus(0, 200);
if (tRIBAL_LAND_NAME.Length > 200) { sTATUS_CD = "F"; sTATUS_DESC += "Tribal Land Name length exceeded. "; }
}
if (!string.IsNullOrEmpty(lATITUDE_MSR))
{
a.LATITUDE_MSR = lATITUDE_MSR.SubStringPlus(0, 30);
decimal iii = 0;
if (Decimal.TryParse(lATITUDE_MSR, out iii) == false) { sTATUS_CD = "F"; sTATUS_DESC += "Latitude is not decimal format. "; }
}
if (!string.IsNullOrEmpty(lONGITUDE_MSR))
{
a.LONGITUDE_MSR = lONGITUDE_MSR.SubStringPlus(0, 30);
decimal iii = 0;
if (Decimal.TryParse(lONGITUDE_MSR, out iii) == false) { sTATUS_CD = "F"; sTATUS_DESC += "Longitude is not decimal format. "; }
}
if (sOURCE_MAP_SCALE != null)
{
a.SOURCE_MAP_SCALE = sOURCE_MAP_SCALE;
}
if (!string.IsNullOrEmpty(hORIZ_COLL_METHOD))
{
a.HORIZ_COLL_METHOD = hORIZ_COLL_METHOD.SubStringPlus(0, 150).Trim();
if (db_Ref.GetT_WQX_REF_DATA_ByKey("HorizontalCollectionMethod", hORIZ_COLL_METHOD.Trim()) == false) { sTATUS_CD = "F"; sTATUS_DESC += "Horizontal Collection Method not valid. "; }
}
if (!string.IsNullOrEmpty(hORIZ_REF_DATUM))
{
a.HORIZ_REF_DATUM = hORIZ_REF_DATUM.Trim().SubStringPlus(0, 6);
if (db_Ref.GetT_WQX_REF_DATA_ByKey("HorizontalCoordinateReferenceSystemDatum", hORIZ_REF_DATUM.Trim()) == false) { sTATUS_CD = "F"; sTATUS_DESC += "Horizontal Collection Datum not valid. "; }
}
if (!string.IsNullOrEmpty(vERT_MEASURE))
{
a.VERT_MEASURE = vERT_MEASURE.Trim().SubStringPlus(0, 12);
if (vERT_MEASURE.Length > 12) { sTATUS_CD = "F"; sTATUS_DESC += "Vertical Measure length exceeded. "; }
}
if (!string.IsNullOrEmpty(vERT_MEASURE_UNIT))
{
a.VERT_MEASURE_UNIT = vERT_MEASURE_UNIT.Trim().SubStringPlus(0, 12);
if (db_Ref.GetT_WQX_REF_DATA_ByKey("MeasureUnit", vERT_MEASURE_UNIT.Trim()) == false) { sTATUS_CD = "F"; sTATUS_DESC += "Vertical Measure Unit not valid. "; }
}
if (!string.IsNullOrEmpty(vERT_COLL_METHOD))
{
a.VERT_COLL_METHOD = vERT_COLL_METHOD.Trim().SubStringPlus(0, 50);
if (db_Ref.GetT_WQX_REF_DATA_ByKey("VerticalCollectionMethod", vERT_COLL_METHOD.Trim()) == false) { sTATUS_CD = "F"; sTATUS_DESC += "Vertical Collection Method not acceptable. "; }
}
if (!string.IsNullOrEmpty(vERT_REF_DATUM))
{
a.VERT_REF_DATUM = vERT_REF_DATUM.Trim().SubStringPlus(0, 6);
if (db_Ref.GetT_WQX_REF_DATA_ByKey("VerticalCoordinateReferenceSystemDatum", vERT_REF_DATUM.Trim()) == false) { sTATUS_CD = "F"; sTATUS_DESC += "Vertical Collection Datum not acceptable. "; }
}
if (!string.IsNullOrEmpty(cOUNTRY_CODE))
{
//if there is a match of country NAME value to reference data text (in case user is importing country name instead of code)
T_WQX_REF_DATA rd = db_Ref.GetT_WQX_REF_DATA_ByTextGetRow("Country", cOUNTRY_CODE);
if (rd != null)
a.COUNTRY_CODE = rd.VALUE.SubStringPlus(0, 2);
else
{
a.COUNTRY_CODE = cOUNTRY_CODE.SubStringPlus(0, 2);
if (cOUNTRY_CODE.Length > 2) { sTATUS_CD = "F"; sTATUS_DESC += "Country Code length exceeded. "; }
}
}
if (!string.IsNullOrEmpty(sTATE_CODE))
{
//if there is a match of state value to reference data text (in case user is importing state name instead of code)
T_WQX_REF_DATA rd = db_Ref.GetT_WQX_REF_DATA_ByTextGetRow("State", sTATE_CODE);
if (rd != null)
a.STATE_CODE = rd.VALUE;
else
{
a.STATE_CODE = sTATE_CODE.SubStringPlus(0, 2);
if (sTATE_CODE.Length > 2) { sTATUS_CD = "F"; sTATUS_DESC += "State Code length exceeded. "; }
}
}
if (!string.IsNullOrEmpty(cOUNTY_CODE))
{
//if there is a match of county value to reference data text (in case user is importing county text instead of code)
T_WQX_REF_COUNTY c = db_Ref.GetT_WQX_REF_COUNTY_ByCountyNameAndState(sTATE_CODE, cOUNTY_CODE);
if (c != null)
a.COUNTY_CODE = c.COUNTY_CODE;
else
{
a.COUNTY_CODE = cOUNTY_CODE.SubStringPlus(0, 3);
if (cOUNTY_CODE.Length > 3) { sTATUS_CD = "F"; sTATUS_DESC += "County Code length exceeded. "; }
}
}
if (!string.IsNullOrEmpty(wELL_TYPE))
{
a.WELL_TYPE = wELL_TYPE.Trim().SubStringPlus(0, 255);
}
if (!string.IsNullOrEmpty(aQUIFER_NAME))
{
a.AQUIFER_NAME = aQUIFER_NAME.Trim().SubStringPlus(0, 120);
}
if (!string.IsNullOrEmpty(fORMATION_TYPE))
{
a.FORMATION_TYPE = fORMATION_TYPE.Trim().SubStringPlus(0, 50);
}
if (!string.IsNullOrEmpty(wELLHOLE_DEPTH_MSR))
{
a.WELLHOLE_DEPTH_MSR = wELLHOLE_DEPTH_MSR.Trim().SubStringPlus(0, 12);
}
if (!string.IsNullOrEmpty(wELLHOLE_DEPTH_MSR_UNIT))
{
a.WELLHOLE_DEPTH_MSR_UNIT = wELLHOLE_DEPTH_MSR_UNIT.Trim().SubStringPlus(0, 12);
}
if (sTATUS_CD != null) a.IMPORT_STATUS_CD = sTATUS_CD;
if (sTATUS_DESC != null) a.IMPORT_STATUS_DESC = sTATUS_DESC.SubStringPlus(0, 100);
if (insInd) //insert case
ctx.AddToT_WQX_IMPORT_TEMP_MONLOC(a);
ctx.SaveChanges();
return a.TEMP_MONLOC_IDX;
}
catch (Exception ex)
{
return 0;
}
}
}
