//*****************USERS ********************************** public static int CreateT_OE_USERS(string uSER_ID, string pWD_HASH, string pWD_SALT, string fNAME, string lNAME, string eMAIL, bool aCT_IND, bool iNITAL_PWD_FLAG, DateTime?lASTLOGIN_DT, string pHONE, string pHONE_EXT, int?cREATE_USERIDX) { using (EECIPEntities ctx = new EECIPEntities()) { try { T_OE_USERS u = new T_OE_USERS(); u.USER_ID = uSER_ID; u.PWD_HASH = pWD_HASH; u.PWD_SALT = pWD_SALT; u.FNAME = fNAME; u.LNAME = lNAME; u.EMAIL = eMAIL; u.ACT_IND = aCT_IND; u.INITAL_PWD_FLAG = iNITAL_PWD_FLAG; u.EFFECTIVE_DT = System.DateTime.Now; u.LASTLOGIN_DT = lASTLOGIN_DT; u.PHONE = pHONE; u.PHONE_EXT = pHONE_EXT; u.CREATE_DT = System.DateTime.Now; u.CREATE_USERIDX = cREATE_USERIDX; ctx.T_OE_USERS.Add(u); ctx.SaveChanges(); return(u.USER_IDX); } catch (Exception ex) { db_Ref.LogEFException(ex); throw ex; } } }
public static int DeleteT_OE_USERS(int idx) { using (EECIPEntities ctx = new EECIPEntities()) { try { T_OE_USERS row = ctx.T_OE_USERS.First(i => i.USER_IDX == idx); ctx.T_OE_USERS.Remove(row); ctx.SaveChanges(); return(1); } catch (Exception ex) { db_Ref.LogEFException(ex); return(0); } } }
public static int UpdateT_OE_USERS_WelcomeEmailSent(int idx) { using (EECIPEntities ctx = new EECIPEntities()) { try { T_OE_USERS row = (from c in ctx.T_OE_USERS where c.USER_IDX == idx select c).First(); row.NEW_USER_EMAIL_IND = true; ctx.SaveChanges(); return(row.USER_IDX); } catch (Exception ex) { db_Ref.LogEFException(ex); return(0); } } }
public static int UpdateT_OE_USERS_UnlockGovernance(int idx) { using (EECIPEntities ctx = new EECIPEntities()) { try { T_OE_USERS row = (from c in ctx.T_OE_USERS where c.USER_IDX == idx select c).First(); row.ALLOW_GOVERNANCE = true; ctx.SaveChanges(); return(row.USER_IDX); } catch (Exception ex) { db_Ref.LogEFException(ex); return(0); } } }
public static int UpdateT_OE_USERS_SyncInd(int idx, bool sYNC_IND) { using (EECIPEntities ctx = new EECIPEntities()) { try { T_OE_USERS row = new T_OE_USERS(); row = (from c in ctx.T_OE_USERS where c.USER_IDX == idx select c).First(); row.SYNC_IND = sYNC_IND; ctx.SaveChanges(); return(1); } catch (Exception ex) { db_Ref.LogEFException(ex); return(0); } } }
public static int DeleteT_OE_USERS(int idx) { using (EECIPEntities ctx = new EECIPEntities()) { try { T_OE_USERS row = ctx.T_OE_USERS.First(i => i.USER_IDX == idx); ctx.T_OE_USERS.Remove(row); ctx.SaveChanges(); return(1); } catch (Exception ex) { //set to inactive if cannot delete UpdateT_OE_USERS(idx, null, null, null, null, null, false, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null); db_Ref.LogEFException(ex); return(0); } } }
public static int UpdateT_OE_USERS_Avatar(int idx, Byte[] UserAvatar) { using (EECIPEntities ctx = new EECIPEntities()) { try { T_OE_USERS row = (from c in ctx.T_OE_USERS where c.USER_IDX == idx select c).First(); if (UserAvatar != null) { row.USER_AVATAR = UserAvatar; } ctx.SaveChanges(); return(row.USER_IDX); } catch (Exception ex) { db_Ref.LogEFException(ex); return(0); } } }
public static int UpdateT_OE_USERS(int idx, string pWD_HASH, string pWD_SALT, string fNAME, string lNAME, string eMAIL, bool?aCT_IND, bool?iNIT_PWD_FLG, DateTime?eFF_DATE, DateTime?lAST_LOGIN_DT, string pHONE, string pHONE_EXT, int?mODIFY_USR, int?LogAtmpt, Guid?oRG_IDX, string jOB_TITLE) { using (EECIPEntities ctx = new EECIPEntities()) { try { T_OE_USERS row = new T_OE_USERS(); row = (from c in ctx.T_OE_USERS where c.USER_IDX == idx select c).First(); if (pWD_HASH != null) { row.PWD_HASH = pWD_HASH; } if (pWD_SALT != null) { row.PWD_SALT = pWD_SALT; } if (fNAME != null) { row.FNAME = fNAME; } if (lNAME != null) { row.LNAME = lNAME; } if (eMAIL != null) { row.EMAIL = eMAIL; } if (aCT_IND != null) { row.ACT_IND = (bool)aCT_IND; } if (iNIT_PWD_FLG != null) { row.INITAL_PWD_FLAG = (bool)iNIT_PWD_FLG; } if (eFF_DATE != null) { row.EFFECTIVE_DT = (DateTime)eFF_DATE; } if (lAST_LOGIN_DT != null) { row.LASTLOGIN_DT = (DateTime)lAST_LOGIN_DT; } if (pHONE != null) { row.PHONE = pHONE; } if (pHONE_EXT != null) { row.PHONE_EXT = pHONE_EXT; } if (mODIFY_USR != null) { row.MODIFY_USERIDX = mODIFY_USR; } if (LogAtmpt != null) { row.LOG_ATMPT = LogAtmpt; } if (oRG_IDX != null) { row.ORG_IDX = oRG_IDX; } if (jOB_TITLE != null) { row.JOB_TITLE = jOB_TITLE; } row.MODIFY_DT = System.DateTime.Now; ctx.SaveChanges(); return(1); } catch (Exception ex) { db_Ref.LogEFException(ex); return(0); } } }
public static int UpdateT_OE_USERS(int idx, string pWD_HASH, string pWD_SALT, string fNAME, string lNAME, string eMAIL, bool?aCT_IND, bool?iNIT_PWD_FLG, DateTime?eFF_DATE, DateTime?lAST_LOGIN_DT, string pHONE, string pHONE_EXT, int?mODIFY_USR, int?LogAtmpt, Guid?oRG_IDX, string jOB_TITLE, string lINKED_IN, bool?NodeAdmin, bool?ExcludeBadges, bool?nOTIFY_DISCUSSION_IND, bool?nOTIFY_BADGE_IND, bool?nOTIFY_NEWSLETTER) { using (EECIPEntities ctx = new EECIPEntities()) { try { T_OE_USERS row = new T_OE_USERS(); row = (from c in ctx.T_OE_USERS where c.USER_IDX == idx select c).First(); if (pWD_HASH != null) { row.PWD_HASH = pWD_HASH; } if (pWD_SALT != null) { row.PWD_SALT = pWD_SALT; } if (fNAME != null) { row.FNAME = fNAME; } if (lNAME != null) { row.LNAME = lNAME; } if (eMAIL != null) { row.EMAIL = eMAIL; } if (aCT_IND != null) { row.ACT_IND = (bool)aCT_IND; } if (iNIT_PWD_FLG != null) { row.INITAL_PWD_FLAG = (bool)iNIT_PWD_FLG; } if (eFF_DATE != null) { row.EFFECTIVE_DT = (DateTime)eFF_DATE; } if (lAST_LOGIN_DT != null) { row.LASTLOGIN_DT = (DateTime)lAST_LOGIN_DT; } if (pHONE != null) { row.PHONE = pHONE; } if (pHONE_EXT != null) { row.PHONE_EXT = pHONE_EXT; } if (mODIFY_USR != null) { row.MODIFY_USERIDX = mODIFY_USR; } if (LogAtmpt != null) { row.LOG_ATMPT = LogAtmpt; } if (oRG_IDX != null) { row.ORG_IDX = oRG_IDX; } if (oRG_IDX == Guid.Empty) { row.ORG_IDX = null; //handling blanking out of OrgIDX } if (jOB_TITLE != null) { row.JOB_TITLE = jOB_TITLE; } if (lINKED_IN != null) { row.LINKEDIN = lINKED_IN; } if (NodeAdmin != null) { row.NODE_ADMIN = NodeAdmin ?? false; } if (ExcludeBadges != null) { row.EXCLUDE_POINTS_IND = (bool)ExcludeBadges; } if (nOTIFY_DISCUSSION_IND != null) { row.NOTIFY_DISCUSSION_IND = (bool)nOTIFY_DISCUSSION_IND; } if (nOTIFY_BADGE_IND != null) { row.NOTIFY_BADGE_IND = (bool)nOTIFY_BADGE_IND; } if (nOTIFY_NEWSLETTER != null) { row.NOTIFY_NEWSLETTER = (bool)nOTIFY_NEWSLETTER; } row.MODIFY_DT = System.DateTime.Now; ctx.SaveChanges(); return(1); } catch (Exception ex) { db_Ref.LogEFException(ex); return(0); } } }