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