/// <summary> /// Create a new T_WQX_REF_SAMP_COL_METHOD object. /// </summary> /// <param name="sAMP_COLL_METHOD_IDX">Initial value of the SAMP_COLL_METHOD_IDX property.</param> /// <param name="sAMP_COLL_METHOD_ID">Initial value of the SAMP_COLL_METHOD_ID property.</param> /// <param name="sAMP_COLL_METHOD_CTX">Initial value of the SAMP_COLL_METHOD_CTX property.</param> public static T_WQX_REF_SAMP_COL_METHOD CreateT_WQX_REF_SAMP_COL_METHOD(global::System.Int32 sAMP_COLL_METHOD_IDX, global::System.String sAMP_COLL_METHOD_ID, global::System.String sAMP_COLL_METHOD_CTX) { T_WQX_REF_SAMP_COL_METHOD t_WQX_REF_SAMP_COL_METHOD = new T_WQX_REF_SAMP_COL_METHOD(); t_WQX_REF_SAMP_COL_METHOD.SAMP_COLL_METHOD_IDX = sAMP_COLL_METHOD_IDX; t_WQX_REF_SAMP_COL_METHOD.SAMP_COLL_METHOD_ID = sAMP_COLL_METHOD_ID; t_WQX_REF_SAMP_COL_METHOD.SAMP_COLL_METHOD_CTX = sAMP_COLL_METHOD_CTX; return t_WQX_REF_SAMP_COL_METHOD; }
public static int InsertOrUpdateT_WQX_REF_SAMP_COL_METHOD(global::System.Int32? sAMP_COLL_METHOD_IDX, global::System.String sAMP_COLL_METHOD_ID, string sAMP_COLL_METHOD_CTX, string sAMP_COLL_METHOD_NAME, string sAMP_COLL_METHOD_DESC, bool aCT_IND) { using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities()) { try { Boolean insInd = true; T_WQX_REF_SAMP_COL_METHOD a = new T_WQX_REF_SAMP_COL_METHOD(); if (ctx.T_WQX_REF_SAMP_COL_METHOD.Any(o => o.SAMP_COLL_METHOD_IDX == sAMP_COLL_METHOD_IDX)) { //update case a = (from c in ctx.T_WQX_REF_SAMP_COL_METHOD where c.SAMP_COLL_METHOD_IDX == sAMP_COLL_METHOD_IDX select c).FirstOrDefault(); insInd = false; } else { if (ctx.T_WQX_REF_ANAL_METHOD.Any(o => o.ANALYTIC_METHOD_ID == sAMP_COLL_METHOD_ID && o.ANALYTIC_METHOD_CTX == sAMP_COLL_METHOD_CTX)) { //update case a = (from c in ctx.T_WQX_REF_SAMP_COL_METHOD where c.SAMP_COLL_METHOD_ID == sAMP_COLL_METHOD_ID && c.SAMP_COLL_METHOD_CTX == sAMP_COLL_METHOD_CTX select c).FirstOrDefault(); insInd = false; } } if (sAMP_COLL_METHOD_ID != null) a.SAMP_COLL_METHOD_ID = sAMP_COLL_METHOD_ID; if (sAMP_COLL_METHOD_CTX != null) a.SAMP_COLL_METHOD_CTX = sAMP_COLL_METHOD_CTX; if (sAMP_COLL_METHOD_NAME != null) a.SAMP_COLL_METHOD_NAME = sAMP_COLL_METHOD_NAME; if (sAMP_COLL_METHOD_DESC != null) a.SAMP_COLL_METHOD_DESC = sAMP_COLL_METHOD_DESC; if (aCT_IND != null) a.ACT_IND = aCT_IND; a.UPDATE_DT = System.DateTime.Now; if (insInd) //insert case ctx.AddToT_WQX_REF_SAMP_COL_METHOD(a); ctx.SaveChanges(); return a.SAMP_COLL_METHOD_IDX; } catch (Exception ex) { return 0; } } }
/// <summary> /// Deprecated Method for adding a new object to the T_WQX_REF_SAMP_COL_METHOD EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToT_WQX_REF_SAMP_COL_METHOD(T_WQX_REF_SAMP_COL_METHOD t_WQX_REF_SAMP_COL_METHOD) { base.AddObject("T_WQX_REF_SAMP_COL_METHOD", t_WQX_REF_SAMP_COL_METHOD); }