internal void UpdateNewsEmailID(string Email, bool Active) { NewsEmails CurRecord = dataContext.NewsEmails.SingleOrDefault(p => p.Email.Equals(Email)); if (CurRecord != null) { CurRecord.Active = Active; dataContext.SubmitChanges(); } }
internal bool ActivateNewsEmailID(string ID) { try { NewsEmails CurRecord = dataContext.NewsEmails.SingleOrDefault(p => p.ID.Equals(ID)); if (CurRecord != null) { CurRecord.Active = true; dataContext.SubmitChanges(); } return(true); } catch { return(false); } }
internal string InsertEmail(string ToEmail, string SenderIP) { NewsEmails CurRecord = dataContext.NewsEmails.SingleOrDefault(p => p.Email.Equals(ToEmail)); if (CurRecord != null) { return(CurRecord.ID); } else { CurRecord = new NewsEmails(); dataContext.NewsEmails.InsertOnSubmit(CurRecord); CurRecord.Email = ToEmail; CurRecord.SenderIP = SenderIP; Guid newGd = Guid.NewGuid(); string ID = newGd.ToString().Replace("-", ""); CurRecord.ID = ID; CurRecord.Active = false; dataContext.SubmitChanges(); return(ID); } }