public static bool Execute(string emailAddress)
{
using (var context = new UserModelContainer())
{
return(context.Users.Count(x => x.EmailAddress == emailAddress) == 1);
}
}
public ActionResult EnterVerificationKey(String verification_key, String email)
{
DateTime now = DateTime.Now;
DateTime now24 = now.AddHours(-24);
User user = (from u in db.Users
where u.verification_key.Equals(verification_key) &&
u.email.Equals(email) &&
now.CompareTo(u.date_verification_send) > 0 &&
now24.CompareTo(u.date_verification_send) > 0
select u).FirstOrDefault();
int?x = (from u in db.Users
where u.verification_key.Equals(verification_key) &&
u.email.Equals(email)
select u.id_user).FirstOrDefault();
using (var context = new UserModelContainer())
{
User userById = context.Users.Find(x);
if (x != null)
{
Session["verification_key"] = userById.verification_key;
return(RedirectToAction("SetNewPassword", new RouteValueDictionary(
new { action = "SetNewPassword", id_user = x })));
}
else
{
return(RedirectToAction("ErrorVerificationKey"));
}
}
}
public bool Exists()
{
using (var context = new UserModelContainer())
{
return(context.Users.Count(x => x.EmailAddress == EmailAddress) == 1);
}
}
private void PersistAsUnsubscribed()
{
using (var context = new UserModelContainer())
{
var user = context.Users.Single(x => x.EmailAddress == EmailAddress);
user.IsUnsubscribed = true;
user.UnsubscribedAt = DateTime.Now;
context.SaveChanges();
}
}
private void AssertUserEvent(string expectedEventCode, int timeoutSeconds)
{
RetryAssert.WithinTimeout(() =>
{
using (var context = new UserModelContainer())
{
return(context.UserEvents.Count(x => x.User.EmailAddress == _emailAddress &&
x.EventCode == expectedEventCode &&
x.RecordedAt > _testStartedAt) == 1);
}
}, 250, 1000 * timeoutSeconds, "Expected event code: {0} recorded after: {1}", expectedEventCode, _testStartedAt);
}
public void Run()
{
Thread.Sleep(UnsubscribeWorkflow.StepDuration);
using (var context = new UserModelContainer())
{
var user = context.Users.Single(x => x.EmailAddress == EmailAddress);
user.UserEvents.Add(new UserEvent
{
EventCode = "UNSUB-LEGACY",
RecordedAt = DateTime.Now
});
context.SaveChanges();
}
}
private void PersistAsUnsubscribed()
{
using (var context = new UserModelContainer())
{
var user = context.Users.Single(x => x.EmailAddress == EmailAddress);
user.IsUnsubscribed = true;
user.UnsubscribedAt = DateTime.Now;
user.UserEvents.Add(new UserEvent
{
EventCode = "UNSUB",
RecordedAt = DateTime.Now
});
context.SaveChanges();
}
}
static void Main(string[] args)
{
using (var container = new UserModelContainer())
{
var user = new User
{
FirstName = "Joe",
Surname = "Coder"
};
var address = new Address
{
AddressLine1 = "123 Any Street",
AddressLine2 = "Apt 2A",
City = "Anytown",
StateProvince = "CA",
PostalCode = "12345",
Country = "United States",
IsPublic = false
};
user.Lookups.Add(address);
container.SaveChanges();
}
using (var container = new UserModelContainer())
{
foreach (var user in container.Users)
{
Console.WriteLine("Name: {0} {1}", user.FirstName, user.Surname);
foreach (var address in user.Lookups.OfType <Address>())
{
Console.WriteLine(address.AddressLine1);
Console.WriteLine(address.AddressLine2);
Console.WriteLine(address.City);
Console.WriteLine(address.StateProvince);
Console.WriteLine(address.PostalCode);
Console.WriteLine(address.Country);
Console.WriteLine("Address is {0}", address.IsPublic ? "Public" : "Private");
}
}
}
}
