/// <summary>
/// Create a new T_WQX_REF_SAMP_COL_METHOD object.
/// </summary>
/// <param name="sAMP_COLL_METHOD_IDX">Initial value of the SAMP_COLL_METHOD_IDX property.</param>
/// <param name="sAMP_COLL_METHOD_ID">Initial value of the SAMP_COLL_METHOD_ID property.</param>
/// <param name="sAMP_COLL_METHOD_CTX">Initial value of the SAMP_COLL_METHOD_CTX property.</param>
public static T_WQX_REF_SAMP_COL_METHOD CreateT_WQX_REF_SAMP_COL_METHOD(global::System.Int32 sAMP_COLL_METHOD_IDX, global::System.String sAMP_COLL_METHOD_ID, global::System.String sAMP_COLL_METHOD_CTX)
{
T_WQX_REF_SAMP_COL_METHOD t_WQX_REF_SAMP_COL_METHOD = new T_WQX_REF_SAMP_COL_METHOD();
t_WQX_REF_SAMP_COL_METHOD.SAMP_COLL_METHOD_IDX = sAMP_COLL_METHOD_IDX;
t_WQX_REF_SAMP_COL_METHOD.SAMP_COLL_METHOD_ID = sAMP_COLL_METHOD_ID;
t_WQX_REF_SAMP_COL_METHOD.SAMP_COLL_METHOD_CTX = sAMP_COLL_METHOD_CTX;
return t_WQX_REF_SAMP_COL_METHOD;
}
public static int InsertOrUpdateT_WQX_REF_SAMP_COL_METHOD(global::System.Int32? sAMP_COLL_METHOD_IDX, global::System.String sAMP_COLL_METHOD_ID,
string sAMP_COLL_METHOD_CTX, string sAMP_COLL_METHOD_NAME, string sAMP_COLL_METHOD_DESC, bool aCT_IND)
{
using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities())
{
try
{
Boolean insInd = true;
T_WQX_REF_SAMP_COL_METHOD a = new T_WQX_REF_SAMP_COL_METHOD();
if (ctx.T_WQX_REF_SAMP_COL_METHOD.Any(o => o.SAMP_COLL_METHOD_IDX == sAMP_COLL_METHOD_IDX))
{
//update case
a = (from c in ctx.T_WQX_REF_SAMP_COL_METHOD
where c.SAMP_COLL_METHOD_IDX == sAMP_COLL_METHOD_IDX
select c).FirstOrDefault();
insInd = false;
}
else
{
if (ctx.T_WQX_REF_ANAL_METHOD.Any(o => o.ANALYTIC_METHOD_ID == sAMP_COLL_METHOD_ID && o.ANALYTIC_METHOD_CTX == sAMP_COLL_METHOD_CTX))
{
//update case
a = (from c in ctx.T_WQX_REF_SAMP_COL_METHOD
where c.SAMP_COLL_METHOD_ID == sAMP_COLL_METHOD_ID
&& c.SAMP_COLL_METHOD_CTX == sAMP_COLL_METHOD_CTX
select c).FirstOrDefault();
insInd = false;
}
}
if (sAMP_COLL_METHOD_ID != null) a.SAMP_COLL_METHOD_ID = sAMP_COLL_METHOD_ID;
if (sAMP_COLL_METHOD_CTX != null) a.SAMP_COLL_METHOD_CTX = sAMP_COLL_METHOD_CTX;
if (sAMP_COLL_METHOD_NAME != null) a.SAMP_COLL_METHOD_NAME = sAMP_COLL_METHOD_NAME;
if (sAMP_COLL_METHOD_DESC != null) a.SAMP_COLL_METHOD_DESC = sAMP_COLL_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_COL_METHOD(a);
ctx.SaveChanges();
return a.SAMP_COLL_METHOD_IDX;
}
catch (Exception ex)
{
return 0;
}
}
}
/// <summary>
/// Deprecated Method for adding a new object to the T_WQX_REF_SAMP_COL_METHOD EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToT_WQX_REF_SAMP_COL_METHOD(T_WQX_REF_SAMP_COL_METHOD t_WQX_REF_SAMP_COL_METHOD)
{
base.AddObject("T_WQX_REF_SAMP_COL_METHOD", t_WQX_REF_SAMP_COL_METHOD);
}
