public void TestMethod1() { // // TODO: Add test logic here // UsersContext db = new UsersContext(); Assert.IsTrue(db != null, "Veza s bazom nije uspostavljena"); }
public CreatePrihodView() { db = new UsersContext(); var kategorije = db.Kategorija.Where(k => k.TipKategorijaID == 2 && k.UserId == WebSecurity.CurrentUserId).ToList(); Kategorije = new List<SelectListItem>(); foreach (var item in kategorije) { Kategorije.Add(new SelectListItem() { Text = item.Naziv, Value = item.IDKategorija.ToString() }); } }
public SimpleMembershipInitializer() { Database.SetInitializer<UsersContext>(null); try { using (var context = new UsersContext()) { if (!context.Database.Exists()) { // Create the SimpleMembership database without Entity Framework migration schema ((IObjectContextAdapter)context).ObjectContext.CreateDatabase(); } } if (!WebMatrix.WebData.WebSecurity.Initialized) { WebSecurity.InitializeDatabaseConnection("csPRA15IPTim1", "UserProfile", "UserId", "UserName", autoCreateTables: true); } } catch (Exception ex) { throw new InvalidOperationException("The ASP.NET Simple Membership database could not be initialized. For more information, please see http://go.microsoft.com/fwlink/?LinkId=256588", ex); } }
public ActionResult Register(RegisterModel model) { if (ModelState.IsValid) { // Attempt to register the user try { WebSecurity.CreateUserAndAccount(model.UserName, model.Password); WebSecurity.Login(model.UserName, model.Password); using (UsersContext db = new UsersContext()) { Kategorija k = new Kategorija(); k.Naziv = "Plaća"; k.Aktivno = true; k.DatumVrijeme = DateTime.Now; k.TipKategorijaID = 2; k.UserId = db.UserProfiles.Count(); db.Kategorija.Add(k); db.SaveChanges(); Kategorija kt = new Kategorija(); kt.Naziv = "Režije"; kt.Aktivno = true; kt.DatumVrijeme = DateTime.Now; kt.TipKategorijaID = 1; kt.UserId = k.UserId; db.Kategorija.Add(kt); db.SaveChanges(); } return RedirectToAction("Index", "Home"); } catch (MembershipCreateUserException e) { ModelState.AddModelError("", ErrorCodeToString(e.StatusCode)); } } // If we got this far, something failed, redisplay form return View(model); }
public ActionResult ExternalLoginConfirmation(RegisterExternalLoginModel model, string returnUrl) { string provider = null; string providerUserId = null; if (User.Identity.IsAuthenticated || !OAuthWebSecurity.TryDeserializeProviderUserId(model.ExternalLoginData, out provider, out providerUserId)) { return RedirectToAction("Manage"); } if (ModelState.IsValid) { // Insert a new user into the database using (UsersContext db = new UsersContext()) { UserProfile user = db.UserProfiles.FirstOrDefault(u => u.UserName.ToLower() == model.UserName.ToLower()); // Check if user already exists if (user == null) { // Insert name into the profile table db.UserProfiles.Add(new UserProfile { UserName = model.UserName }); db.SaveChanges(); OAuthWebSecurity.CreateOrUpdateAccount(provider, providerUserId, model.UserName); OAuthWebSecurity.Login(provider, providerUserId, createPersistentCookie: false); return RedirectToLocal(returnUrl); } else { ModelState.AddModelError("UserName", "User name already exists. Please enter a different user name."); } } } ViewBag.ProviderDisplayName = OAuthWebSecurity.GetOAuthClientData(provider).DisplayName; ViewBag.ReturnUrl = returnUrl; return View(model); }