/// <summary>
/// Deprecated Method for adding a new object to the T_WQX_REF_ANAL_METHOD EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToT_WQX_REF_ANAL_METHOD(T_WQX_REF_ANAL_METHOD t_WQX_REF_ANAL_METHOD)
{
base.AddObject("T_WQX_REF_ANAL_METHOD", t_WQX_REF_ANAL_METHOD);
}
public static int InsertOrUpdateT_WQX_REF_ANAL_METHOD(global::System.Int32? aNALYTIC_METHOD_IDX, global::System.String aNALYTIC_METHOD_ID, string aNALYTIC_METHOD_CTX,
string aNALYTIC_METHOD_NAME, string aNALYTIC_METHOD_DESC, bool aCT_IND)
{
using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities())
{
try
{
Boolean insInd = true;
T_WQX_REF_ANAL_METHOD a = new T_WQX_REF_ANAL_METHOD();
if (ctx.T_WQX_REF_ANAL_METHOD.Any(o => o.ANALYTIC_METHOD_IDX == aNALYTIC_METHOD_IDX))
{
//update case
a = (from c in ctx.T_WQX_REF_ANAL_METHOD
where c.ANALYTIC_METHOD_IDX == aNALYTIC_METHOD_IDX
select c).FirstOrDefault();
insInd = false;
}
else
{
if (ctx.T_WQX_REF_ANAL_METHOD.Any(o => o.ANALYTIC_METHOD_ID == aNALYTIC_METHOD_ID && o.ANALYTIC_METHOD_CTX == aNALYTIC_METHOD_CTX))
{
//update case
a = (from c in ctx.T_WQX_REF_ANAL_METHOD
where c.ANALYTIC_METHOD_ID == aNALYTIC_METHOD_ID
&& c.ANALYTIC_METHOD_CTX == aNALYTIC_METHOD_CTX
select c).FirstOrDefault();
insInd = false;
}
}
if (aNALYTIC_METHOD_ID != null) a.ANALYTIC_METHOD_ID = aNALYTIC_METHOD_ID;
if (aNALYTIC_METHOD_CTX != null) a.ANALYTIC_METHOD_CTX = aNALYTIC_METHOD_CTX;
if (aNALYTIC_METHOD_NAME != null) a.ANALYTIC_METHOD_NAME = aNALYTIC_METHOD_NAME;
if (aNALYTIC_METHOD_DESC != null) a.ANALYTIC_METHOD_DESC = aNALYTIC_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_ANAL_METHOD(a);
ctx.SaveChanges();
return a.ANALYTIC_METHOD_IDX;
}
catch (Exception ex)
{
return 0;
}
}
}
/// <summary>
/// Create a new T_WQX_REF_ANAL_METHOD object.
/// </summary>
/// <param name="aNALYTIC_METHOD_IDX">Initial value of the ANALYTIC_METHOD_IDX property.</param>
/// <param name="aNALYTIC_METHOD_ID">Initial value of the ANALYTIC_METHOD_ID property.</param>
/// <param name="aNALYTIC_METHOD_CTX">Initial value of the ANALYTIC_METHOD_CTX property.</param>
public static T_WQX_REF_ANAL_METHOD CreateT_WQX_REF_ANAL_METHOD(global::System.Int32 aNALYTIC_METHOD_IDX, global::System.String aNALYTIC_METHOD_ID, global::System.String aNALYTIC_METHOD_CTX)
{
T_WQX_REF_ANAL_METHOD t_WQX_REF_ANAL_METHOD = new T_WQX_REF_ANAL_METHOD();
t_WQX_REF_ANAL_METHOD.ANALYTIC_METHOD_IDX = aNALYTIC_METHOD_IDX;
t_WQX_REF_ANAL_METHOD.ANALYTIC_METHOD_ID = aNALYTIC_METHOD_ID;
t_WQX_REF_ANAL_METHOD.ANALYTIC_METHOD_CTX = aNALYTIC_METHOD_CTX;
return t_WQX_REF_ANAL_METHOD;
}
