/// <summary> /// Create a new T_WQX_REF_COUNTY object. /// </summary> /// <param name="sTATE_CODE">Initial value of the STATE_CODE property.</param> /// <param name="cOUNTY_CODE">Initial value of the COUNTY_CODE property.</param> /// <param name="cOUNTY_NAME">Initial value of the COUNTY_NAME property.</param> public static T_WQX_REF_COUNTY CreateT_WQX_REF_COUNTY(global::System.String sTATE_CODE, global::System.String cOUNTY_CODE, global::System.String cOUNTY_NAME) { T_WQX_REF_COUNTY t_WQX_REF_COUNTY = new T_WQX_REF_COUNTY(); t_WQX_REF_COUNTY.STATE_CODE = sTATE_CODE; t_WQX_REF_COUNTY.COUNTY_CODE = cOUNTY_CODE; t_WQX_REF_COUNTY.COUNTY_NAME = cOUNTY_NAME; return t_WQX_REF_COUNTY; }
//******************REF COUNTY **************************************** public static int InsertOrUpdateT_WQX_REF_COUNTY(global::System.String sTATE_CODE, global::System.String cOUNTY_CODE, global::System.String cOUNTY_NAME, global::System.Boolean? UsedInd) { using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities()) { try { Boolean insInd = true; T_WQX_REF_COUNTY a = new T_WQX_REF_COUNTY(); if (ctx.T_WQX_REF_COUNTY.Any(o => o.STATE_CODE == sTATE_CODE && o.COUNTY_CODE == cOUNTY_CODE)) { //update case a = (from c in ctx.T_WQX_REF_COUNTY where c.STATE_CODE == sTATE_CODE && c.COUNTY_CODE == cOUNTY_CODE select c).FirstOrDefault(); insInd = false; } a.STATE_CODE = sTATE_CODE; a.COUNTY_CODE = cOUNTY_CODE; a.COUNTY_NAME = cOUNTY_NAME; if (UsedInd != null) a.USED_IND = UsedInd; a.UPDATE_DT = System.DateTime.Now; a.ACT_IND = true; if (insInd) //insert case { if (UsedInd == null) a.USED_IND = true; ctx.AddToT_WQX_REF_COUNTY(a); } ctx.SaveChanges(); return 1; } catch (Exception ex) { return 0; } } }
/// <summary> /// Deprecated Method for adding a new object to the T_WQX_REF_COUNTY EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToT_WQX_REF_COUNTY(T_WQX_REF_COUNTY t_WQX_REF_COUNTY) { base.AddObject("T_WQX_REF_COUNTY", t_WQX_REF_COUNTY); }