public static int InsertUpdatetT_OE_REF_SYNONYMS(int?sYNONYM_IDX, string sYNONYM_TEXT, int?cREATE_USER = 0) { using (EECIPEntities ctx = new EECIPEntities()) { try { Boolean insInd = false; T_OE_REF_SYNONYMS e = (from c in ctx.T_OE_REF_SYNONYMS where c.SYNONYM_IDX == sYNONYM_IDX select c).FirstOrDefault(); if (e == null) { insInd = true; e = new T_OE_REF_SYNONYMS(); e.CREATE_DT = System.DateTime.Now; e.CREATE_USERIDX = cREATE_USER; } else { e.MODIFY_DT = System.DateTime.Now; e.MODIFY_USERIDX = cREATE_USER; } if (sYNONYM_TEXT != null) { e.SYNONYM_TEXT = sYNONYM_TEXT.ToLower(); } if (insInd) { ctx.T_OE_REF_SYNONYMS.Add(e); } ctx.SaveChanges(); return(e.SYNONYM_IDX); } catch (Exception ex) { LogEFException(ex); return(0); } } }
public static int DeleteT_OE_REF_SYNONYMS(int id) { using (EECIPEntities ctx = new EECIPEntities()) { try { T_OE_REF_SYNONYMS rec = new T_OE_REF_SYNONYMS { SYNONYM_IDX = id }; ctx.Entry(rec).State = System.Data.Entity.EntityState.Deleted; ctx.SaveChanges(); return(1); } catch (Exception ex) { LogEFException(ex); return(0); } } }