/// <summary> /// Create a new T_WQX_REF_SAMP_PREP object. /// </summary> /// <param name="sAMP_PREP_IDX">Initial value of the SAMP_PREP_IDX property.</param> /// <param name="sAMP_PREP_METHOD_ID">Initial value of the SAMP_PREP_METHOD_ID property.</param> /// <param name="sAMP_PREP_METHOD_CTX">Initial value of the SAMP_PREP_METHOD_CTX property.</param> public static T_WQX_REF_SAMP_PREP CreateT_WQX_REF_SAMP_PREP(global::System.Int32 sAMP_PREP_IDX, global::System.String sAMP_PREP_METHOD_ID, global::System.String sAMP_PREP_METHOD_CTX) { T_WQX_REF_SAMP_PREP t_WQX_REF_SAMP_PREP = new T_WQX_REF_SAMP_PREP(); t_WQX_REF_SAMP_PREP.SAMP_PREP_IDX = sAMP_PREP_IDX; t_WQX_REF_SAMP_PREP.SAMP_PREP_METHOD_ID = sAMP_PREP_METHOD_ID; t_WQX_REF_SAMP_PREP.SAMP_PREP_METHOD_CTX = sAMP_PREP_METHOD_CTX; return t_WQX_REF_SAMP_PREP; }
public static int InsertOrUpdateT_WQX_REF_SAMP_PREP(global::System.Int32? sAMP_PREP_IDX, global::System.String sAMP_PREP_METHOD_ID, string sAMP_PREP_METHOD_CTX, string sAMP_PREP_METHOD_NAME, string sAMP_PREP_METHOD_DESC, bool aCT_IND) { using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities()) { try { Boolean insInd = true; T_WQX_REF_SAMP_PREP a = new T_WQX_REF_SAMP_PREP(); if (ctx.T_WQX_REF_SAMP_PREP.Any(o => o.SAMP_PREP_IDX == sAMP_PREP_IDX)) { //update case a = (from c in ctx.T_WQX_REF_SAMP_PREP where c.SAMP_PREP_IDX == sAMP_PREP_IDX select c).FirstOrDefault(); insInd = false; } else { if (ctx.T_WQX_REF_ANAL_METHOD.Any(o => o.ANALYTIC_METHOD_ID == sAMP_PREP_METHOD_ID && o.ANALYTIC_METHOD_CTX == sAMP_PREP_METHOD_CTX)) { //update case a = (from c in ctx.T_WQX_REF_SAMP_PREP where c.SAMP_PREP_METHOD_ID == sAMP_PREP_METHOD_ID && c.SAMP_PREP_METHOD_CTX == sAMP_PREP_METHOD_CTX select c).FirstOrDefault(); insInd = false; } } if (sAMP_PREP_METHOD_ID != null) a.SAMP_PREP_METHOD_ID = sAMP_PREP_METHOD_ID; if (sAMP_PREP_METHOD_CTX != null) a.SAMP_PREP_METHOD_CTX = sAMP_PREP_METHOD_CTX; if (sAMP_PREP_METHOD_NAME != null) a.SAMP_PREP_METHOD_NAME = sAMP_PREP_METHOD_NAME; if (sAMP_PREP_METHOD_DESC != null) a.SAMP_PREP_METHOD_DESC = sAMP_PREP_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_PREP(a); ctx.SaveChanges(); return a.SAMP_PREP_IDX; } catch (Exception ex) { return 0; } } }
/// <summary> /// Deprecated Method for adding a new object to the T_WQX_REF_SAMP_PREP EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToT_WQX_REF_SAMP_PREP(T_WQX_REF_SAMP_PREP t_WQX_REF_SAMP_PREP) { base.AddObject("T_WQX_REF_SAMP_PREP", t_WQX_REF_SAMP_PREP); }