C# (CSharp) OpenEnvironment.App_Logic.DataAccessLayer T_OE_APP_TASKS Examples

Example #1

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

 /// <summary>
 /// Deprecated Method for adding a new object to the T_OE_APP_TASKS EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddToT_OE_APP_TASKS(T_OE_APP_TASKS t_OE_APP_TASKS)
 {
     base.AddObject("T_OE_APP_TASKS", t_OE_APP_TASKS);
 }

Example #2

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

        public static int UpdateT_OE_APP_TASKS(string tASK_NAME, string tASK_STATUS, int? tASK_FREQ_MS, string mODIFY_USERID)
        {
            using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities())
            {
                try
                {
                    T_OE_APP_TASKS t = new T_OE_APP_TASKS();
                        t = (from c in ctx.T_OE_APP_TASKS
                             where c.TASK_NAME == tASK_NAME
                             select c).First();

                    if (tASK_STATUS != null) t.TASK_STATUS = tASK_STATUS;
                    if (tASK_FREQ_MS != null) t.TASK_FREQ_MS = (int)tASK_FREQ_MS;
                    if (mODIFY_USERID != null) t.MODIFY_USERID = mODIFY_USERID;
                    t.MODIFY_DT = System.DateTime.Now;
                    ctx.SaveChanges();

                    return t.TASK_IDX;
                }
                catch
                {
                    return 0;
                }
            }
        }

Example #3

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

 /// <summary>
 /// Create a new T_OE_APP_TASKS object.
 /// </summary>
 /// <param name="tASK_IDX">Initial value of the TASK_IDX property.</param>
 /// <param name="tASK_NAME">Initial value of the TASK_NAME property.</param>
 /// <param name="tASK_DESC">Initial value of the TASK_DESC property.</param>
 /// <param name="tASK_STATUS">Initial value of the TASK_STATUS property.</param>
 /// <param name="tASK_FREQ_MS">Initial value of the TASK_FREQ_MS property.</param>
 public static T_OE_APP_TASKS CreateT_OE_APP_TASKS(global::System.Int32 tASK_IDX, global::System.String tASK_NAME, global::System.String tASK_DESC, global::System.String tASK_STATUS, global::System.Int32 tASK_FREQ_MS)
 {
     T_OE_APP_TASKS t_OE_APP_TASKS = new T_OE_APP_TASKS();
     t_OE_APP_TASKS.TASK_IDX = tASK_IDX;
     t_OE_APP_TASKS.TASK_NAME = tASK_NAME;
     t_OE_APP_TASKS.TASK_DESC = tASK_DESC;
     t_OE_APP_TASKS.TASK_STATUS = tASK_STATUS;
     t_OE_APP_TASKS.TASK_FREQ_MS = tASK_FREQ_MS;
     return t_OE_APP_TASKS;
 }