public static int DeleteT_OE_REF_ENTERPRISE_PLATFORM(int id)
{
using (EECIPEntities ctx = new EECIPEntities())
{
try
{
T_OE_REF_ENTERPRISE_PLATFORM rec = new T_OE_REF_ENTERPRISE_PLATFORM {
ENT_PLATFORM_IDX = id
};
ctx.Entry(rec).State = System.Data.Entity.EntityState.Deleted;
ctx.SaveChanges();
return(1);
}
catch (Exception ex)
{
LogEFException(ex);
return(0);
}
}
}
public static int InsertUpdatetT_OE_REF_ENTERPRISE_PLATFORM(int eNT_PLATFORM_IDX, string eNT_PLATFORM_NAME, string eNT_PLATFORM_DESC, string eNT_PLATFORM_EXAMPLE,
int?sEQ_NO, bool?aCT_IND, int?cREATE_USER = 0)
{
using (EECIPEntities ctx = new EECIPEntities())
{
try
{
Boolean insInd = false;
T_OE_REF_ENTERPRISE_PLATFORM e = (from c in ctx.T_OE_REF_ENTERPRISE_PLATFORM
where c.ENT_PLATFORM_IDX == eNT_PLATFORM_IDX
select c).FirstOrDefault();
if (e == null)
{
insInd = true;
e = new T_OE_REF_ENTERPRISE_PLATFORM();
}
if (eNT_PLATFORM_NAME != null)
{
e.ENT_PLATFORM_NAME = eNT_PLATFORM_NAME;
}
if (eNT_PLATFORM_DESC != null)
{
e.ENT_PLATFORM_DESC = eNT_PLATFORM_DESC;
}
if (eNT_PLATFORM_EXAMPLE != null)
{
e.ENT_PLATFORM_EXAMPLE = eNT_PLATFORM_EXAMPLE;
}
if (sEQ_NO != null)
{
e.SEQ_NO = sEQ_NO;
}
if (e.SEQ_NO == null)
{
e.SEQ_NO = GetT_OE_REF_ENTERPRISE_PLATFORM_MaxSeq() + 1;
}
if (aCT_IND != null)
{
e.ACT_IND = aCT_IND ?? true;
}
e.MODIFY_DT = System.DateTime.Now;
e.MODIFY_USERIDX = cREATE_USER;
if (insInd)
{
ctx.T_OE_REF_ENTERPRISE_PLATFORM.Add(e);
}
ctx.SaveChanges();
return(e.ENT_PLATFORM_IDX);
}
catch (Exception ex)
{
LogEFException(ex);
return(0);
}
}
}
