public static int DeleteT_ATTAINS_REPORT(int aTTAINS_REPORT_IDX)
{
using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities())
{
try
{
T_ATTAINS_REPORT r = (from c in ctx.T_ATTAINS_REPORT
where c.ATTAINS_REPORT_IDX == aTTAINS_REPORT_IDX
select c).FirstOrDefault();
if (r.ATTAINS_SUBMIT_STATUS == "Y" || r.ATTAINS_SUBMIT_STATUS == "U")
{
return(-1);
}
ctx.DeleteObject(r);
ctx.SaveChanges();
return(1);
}
catch
{
return(0);
}
}
}
public static int DeleteT_VCCB_ROLE(int idx)
{
using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities())
{
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.DeleteObject(row);
ctx.SaveChanges();
return(1);
}
catch (Exception ex)
{
return(0);
}
}
}
public static int DeleteT_ATTAINS_ASSESS_UNITS(int aSSESS_UNIT_IDX)
{
using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities())
{
try
{
T_ATTAINS_ASSESS_UNITS r = (from c in ctx.T_ATTAINS_ASSESS_UNITS
where c.ATTAINS_ASSESS_UNIT_IDX == aSSESS_UNIT_IDX
select c).FirstOrDefault();
ctx.DeleteObject(r);
ctx.SaveChanges();
return(1);
}
catch
{
return(0);
}
}
}
public static int DeleteT_VCCB_USER_ROLE(int UserIDX, int RoleIDX)
{
using (OpenEnvironmentEntities ctx = new OpenEnvironmentEntities())
{
try
{
T_OE_USER_ROLES row = new T_OE_USER_ROLES();
row = (from c in ctx.T_OE_USER_ROLES
where c.ROLE_IDX == RoleIDX && c.USER_IDX == UserIDX
select c).FirstOrDefault();
ctx.DeleteObject(row);
ctx.SaveChanges();
return(1);
}
catch (Exception ex)
{
return(0);
}
}
}
