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