public static int DeleteT_OE_USER_ROLE(int UserIDX, int RoleIDX) { using (EECIPEntities ctx = new EECIPEntities()) { try { 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.T_OE_USER_ROLES.Remove(row); ctx.SaveChanges(); return(1); } catch (Exception ex) { db_Ref.LogEFException(ex); return(0); } } }
public static int CreateT_OE_USER_ROLE(global::System.Int32 rOLE_IDX, global::System.Int32 uSER_IDX, int?cREATE_USER = 0) { using (EECIPEntities ctx = new EECIPEntities()) { try { T_OE_USER_ROLES ur = new T_OE_USER_ROLES(); ur.ROLE_IDX = rOLE_IDX; ur.USER_IDX = uSER_IDX; ur.CREATE_DT = System.DateTime.Now; ur.CREATE_USERIDX = cREATE_USER; ctx.T_OE_USER_ROLES.Add(ur); ctx.SaveChanges(); return(1); } catch (Exception ex) { db_Ref.LogEFException(ex); return(0); } } }