/// <summary> /// Create a new T_WQX_REF_LAB object. /// </summary> /// <param name="lAB_IDX">Initial value of the LAB_IDX property.</param> /// <param name="lAB_NAME">Initial value of the LAB_NAME property.</param> /// <param name="oRG_ID">Initial value of the ORG_ID property.</param> public static T_WQX_REF_LAB CreateT_WQX_REF_LAB(global::System.Int32 lAB_IDX, global::System.String lAB_NAME, global::System.String oRG_ID) { T_WQX_REF_LAB t_WQX_REF_LAB = new T_WQX_REF_LAB(); t_WQX_REF_LAB.LAB_IDX = lAB_IDX; t_WQX_REF_LAB.LAB_NAME = lAB_NAME; t_WQX_REF_LAB.ORG_ID = oRG_ID; return t_WQX_REF_LAB; }
public static int InsertOrUpdateT_WQX_REF_LAB(global::System.Int32? lAB_IDX, global::System.String lAB_NAME, string lAB_ACCRED_IND, string lAB_ACCRED_AUTHORITY, string oRG_ID, bool aCT_IND) { using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities()) { try { Boolean insInd = true; T_WQX_REF_LAB a = new T_WQX_REF_LAB(); if (ctx.T_WQX_REF_LAB.Any(o => o.LAB_IDX == lAB_IDX)) { //update case a = (from c in ctx.T_WQX_REF_LAB where c.LAB_IDX == lAB_IDX select c).FirstOrDefault(); insInd = false; } else { if (ctx.T_WQX_REF_LAB.Any(o => o.LAB_NAME == lAB_NAME && o.ORG_ID == oRG_ID)) { //update case a = (from c in ctx.T_WQX_REF_LAB where c.LAB_NAME == lAB_NAME && c.ORG_ID == oRG_ID select c).FirstOrDefault(); insInd = false; } } if (lAB_NAME != null) a.LAB_NAME = lAB_NAME; if (lAB_ACCRED_IND != null) a.LAB_ACCRED_IND = lAB_ACCRED_IND; if (lAB_ACCRED_AUTHORITY != null) a.LAB_ACCRED_AUTHORITY = lAB_ACCRED_AUTHORITY; if (oRG_ID != null) a.ORG_ID = oRG_ID; a.ACT_IND = aCT_IND; a.UPDATE_DT = System.DateTime.Now; if (insInd) //insert case { a.CREATE_DT = System.DateTime.Now; ctx.AddToT_WQX_REF_LAB(a); } ctx.SaveChanges(); return a.LAB_IDX; } catch (Exception ex) { return 0; } } }
/// <summary> /// Deprecated Method for adding a new object to the T_WQX_REF_LAB EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToT_WQX_REF_LAB(T_WQX_REF_LAB t_WQX_REF_LAB) { base.AddObject("T_WQX_REF_LAB", t_WQX_REF_LAB); }