public static int DeleteT_OE_ROLE(int idx)
{
using (EECIPEntities ctx = new EECIPEntities())
{
try
{
T_OE_ROLES row = new T_OE_ROLES();
row = (from c in ctx.T_OE_ROLES where c.ROLE_IDX == idx select c).First();
ctx.T_OE_ROLES.Remove(row);
ctx.SaveChanges();
return(1);
}
catch (Exception ex)
{
db_Ref.LogEFException(ex);
return(0);
}
}
}
//*****************ROLES **********************************
public static int CreateT_OE_ROLES(global::System.String rOLE_NAME, global::System.String rOLE_DESC, int?cREATE_USER = 0)
{
using (EECIPEntities ctx = new EECIPEntities())
{
try
{
T_OE_ROLES r = new T_OE_ROLES();
r.ROLE_NAME = rOLE_NAME;
r.ROLE_DESC = rOLE_DESC;
r.CREATE_DT = System.DateTime.Now;
r.CREATE_USERIDX = cREATE_USER;
ctx.T_OE_ROLES.Add(r);
ctx.SaveChanges();
return(1);
}
catch (Exception ex)
{
db_Ref.LogEFException(ex);
return(0);
}
}
}
public static int UpdateT_OE_ROLE(int idx, string newROLE_NAME, string newROLE_DESC, int?newMODIFY_USR)
{
using (EECIPEntities ctx = new EECIPEntities())
{
try
{
T_OE_ROLES row = new T_OE_ROLES();
row = (from c in ctx.T_OE_ROLES where c.ROLE_IDX == idx select c).First();
if (newROLE_NAME != null)
{
row.ROLE_NAME = newROLE_NAME;
}
if (newROLE_DESC != null)
{
row.ROLE_DESC = newROLE_DESC;
}
if (newMODIFY_USR != null)
{
row.MODIFY_USERIDX = newMODIFY_USR;
}
row.MODIFY_DT = System.DateTime.Now;
ctx.SaveChanges();
return(row.ROLE_IDX);
}
catch (Exception ex)
{
db_Ref.LogEFException(ex);
return(0);
}
}
}
