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); } } }