public Addresses GetAddress(short id)
{
using (var entityContext = new SiteDBEntities())
{
var address = entityContext.Addresses
.Where(a => a.Id == id)
.ProjectTo <AddressDTO>()
.FirstOrDefault();
return(address);
}
}
public ActionResult Register(RegisterModel model)
{
#if DEBUG
using (SiteDBEntities db = new SiteDBEntities(true))
#else
using (SiteDBEntities db = new SiteDBEntities(false))
#endif
{
if (db.Users.Any(s => s.Email.ToLower() == model.Email.ToLower()))
{
ModelState.AddModelError("", "Email already exists");
}
}
if (ModelState.IsValid)
{
// Attempt to register the user
try
{
string token = WebSecurity.CreateUserAndAccount(model.UserName, model.Password, propertyValues: new
{
Email = model.Email
}, requireConfirmationToken: true);
string confirmationLink = Url.Action("confirm", "account", new { code = token }, Request.Url.Scheme);
string emailBodyText =
"<p>Thank you for signing up with us! "
+ "Please confirm your registration by clicking the following link:</p>"
+ "<p><a href=\"" + confirmationLink + "\">Click to confirm your registration</a></p>"
+ "<p>If the link does not work, copy and paste this url into your browser:<br/><strong> "
+ confirmationLink
+ "</strong></p>";
Globals.SendEmail(model.Email, "Your account confirmation", emailBodyText);
ViewBag.Emailed = model.Email;
model = null;
return(View(model));
}
catch (MembershipCreateUserException e)
{
ModelState.AddModelError("", ErrorCodeToString(e.StatusCode));
}
}
// If we got this far, something failed, redisplay form
return(View(model));
}
/// <summary>
/// Fetch Posts from server to our SQL DB
/// </summary>
/// <returns>
/// Number of rows that changed
/// </returns>
private static async Task <int> FetchPosts()
{
List <Posts> posts = JsonConvert.DeserializeObject <List <Posts> >(await HttpRequestsManager.ExecuteRequestAsync(POSTS_URL));
using (SiteDBEntities db = new SiteDBEntities())
{
foreach (Posts post in posts)
{
if (!db.Posts.Any(u => u.id == post.id))
{
db.Posts.Add(post);
}
}
return(db.SaveChanges());
}
}
/// <summary>
/// Fetch Users from server to our SQL DB
/// </summary>
/// <returns>
/// Number of rows that changed
/// </returns>
private static async Task <int> FetchUsers()
{
List <JToken> tokens = JArray.Parse(await HttpRequestsManager.ExecuteRequestAsync(USERS_URL)).ToList();
using (SiteDBEntities db = new SiteDBEntities())
{
foreach (JToken token in tokens)
{
int id = (int)token["id"];
if (!db.Users.Any(u => u.Id == id))
{
db.Users.Add(Users.CreateUser(token));
}
}
return(db.SaveChanges());
}
}
public GenericRepository(SiteDBEntities context)
{
this.context = context;
this.dbSet = context.Set <TEntity>();
}
public ListingRepository(SiteDBEntities db)
{
this.db = db;
}