/// <summary>
/// Deprecated Method for adding a new object to the T_WQX_IMPORT_TEMPLATE EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToT_WQX_IMPORT_TEMPLATE(T_WQX_IMPORT_TEMPLATE t_WQX_IMPORT_TEMPLATE)
{
base.AddObject("T_WQX_IMPORT_TEMPLATE", t_WQX_IMPORT_TEMPLATE);
}
/// <summary>
/// Create a new T_WQX_IMPORT_TEMPLATE object.
/// </summary>
/// <param name="tEMPLATE_ID">Initial value of the TEMPLATE_ID property.</param>
/// <param name="oRG_ID">Initial value of the ORG_ID property.</param>
/// <param name="tYPE_CD">Initial value of the TYPE_CD property.</param>
/// <param name="tEMPLATE_NAME">Initial value of the TEMPLATE_NAME property.</param>
public static T_WQX_IMPORT_TEMPLATE CreateT_WQX_IMPORT_TEMPLATE(global::System.Int32 tEMPLATE_ID, global::System.String oRG_ID, global::System.String tYPE_CD, global::System.String tEMPLATE_NAME)
{
T_WQX_IMPORT_TEMPLATE t_WQX_IMPORT_TEMPLATE = new T_WQX_IMPORT_TEMPLATE();
t_WQX_IMPORT_TEMPLATE.TEMPLATE_ID = tEMPLATE_ID;
t_WQX_IMPORT_TEMPLATE.ORG_ID = oRG_ID;
t_WQX_IMPORT_TEMPLATE.TYPE_CD = tYPE_CD;
t_WQX_IMPORT_TEMPLATE.TEMPLATE_NAME = tEMPLATE_NAME;
return t_WQX_IMPORT_TEMPLATE;
}
// *************************** IMPORT_TEMPLATE ******************************
// *****************************************************************************
public static int InsertOrUpdateWQX_IMPORT_TEMPLATE(global::System.Int32? tEMPLATE_ID, global::System.String oRG_ID, string tYPE_CD, string tEMPLATE_NAME, String cREATE_USER = "******")
{
using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities())
{
Boolean insInd = false;
try
{
T_WQX_IMPORT_TEMPLATE a = new T_WQX_IMPORT_TEMPLATE();
if (tEMPLATE_ID != null)
a = (from c in ctx.T_WQX_IMPORT_TEMPLATE
where c.TEMPLATE_ID == tEMPLATE_ID
select c).FirstOrDefault();
if (tEMPLATE_ID == null) //insert case
insInd = true;
if (oRG_ID != null) a.ORG_ID = oRG_ID;
if (tYPE_CD != null) a.TYPE_CD = tYPE_CD;
if (tEMPLATE_NAME != null) a.TEMPLATE_NAME = tEMPLATE_NAME;
if (insInd) //insert case
{
a.CREATE_DT = System.DateTime.Now;
a.CREATE_USERID = cREATE_USER;
ctx.AddToT_WQX_IMPORT_TEMPLATE(a);
}
ctx.SaveChanges();
return a.TEMPLATE_ID;
}
catch (Exception ex)
{
return 0;
}
}
}
