Esempi in C# (CSharp) per OpenEnvironment.App_Logic.DataAccessLayer T_WQX_REF_SAMP_PREP

Esempio n. 1

File: db_model.Designer.cs Progetto: open-environment/open-waters

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

Esempio n. 2

File: db_Ref.cs Progetto: OTIE-Zimmer/Open-Waters

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

Esempio n. 3

File: db_model.Designer.cs Progetto: open-environment/open-waters

 /// <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&lt;T&gt; 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);
 }