/// <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; } } }