private User getNewUser(Library.User user) { User u = Mapper.Map(user); u.DefaultLocation = db.Location.Find(user.DefaultLocation.LocationId); return(u); }
public static DataAccess.Users Map(Library.User user) => new DataAccess.Users { UserId = user.userID, FirstName = user.firstName, LastName = user.lastName, DefaultAddressId = user.defaultAddressID };
private List <Library.Order> GetOrderHistory(List <Order> os) { List <Library.Order> result = new List <Library.Order>(); foreach (var o in os) { Library.Location l = Mapper.Map(o.Location); Library.User u = Mapper.Map(o.User); Dictionary <Pizza, int> pizzas = new Dictionary <Pizza, int>(); foreach (OrderContent oc in o.OrderContent) { Pizza p = new Pizza() { Name = oc.Content.Name, Price = oc.Content.Price }; pizzas[p] = oc.Amount; } Library.Order tempOrder = new Library.Order() { OrderId = o.OrderId, User = u, Location = l, Contents = pizzas, OrderTime = o.OrderTime }; result.Add(tempOrder); } return(result); }
public static User Map(Library.User user) => new User { FirstName = user.FirstName, LastName = user.LastName, Order = new List <Order>(), //DefaultLocation = user.DefaultLocation != null ? Map(user.DefaultLocation) : null };
// GET: Main public ActionResult Index(PizzaStoreView psv) { if (Repo.UserExists(psv.FirstName, psv.LastName)) { var libUser = Repo.GetUser(psv.FirstName, psv.LastName); var webUser = new User { Id = libUser.Id, FirstName = libUser.FirstName, LastName = libUser.LastName, DefaultLocation = libUser.DefaultLocation }; psv.Id = libUser.Id; return(View("ContinueOrder", psv)); } else { var NewWebUser = new Library.User { FirstName = psv.FirstName, LastName = psv.LastName, DefaultLocation = psv.DefaultLocation }; Repo.AddUser(NewWebUser); Repo.Save(); psv.Id = Repo.GetUserID(NewWebUser); return(View("ContinueOrder", psv)); } }
public static ModelUser Map(Library.User user) => new ModelUser { UserId = user.UserId, FirstName = user.FirstName, LastName = user.LastName, DefaultLocation = user.DefaultLocation //!= null ? Map(user.DefaultLocation) : null };
public Library.Order GetOrder(int orderId) { Order order = db.Order.Include(a => a.User).Include(b => b.Location).Include("OrderContent.Content").First(o => o.OrderId == orderId); Library.Location l = Mapper.Map(order.Location); Library.User u = Mapper.Map(order.User); Dictionary <Pizza, int> pizzas = new Dictionary <Pizza, int>(); foreach (OrderContent oc in order.OrderContent) { Pizza p = new Pizza() { Name = oc.Content.Name, Price = oc.Content.Price }; pizzas[p] = oc.Amount; } Library.Order result = new Library.Order { OrderId = order.OrderId, User = u, Location = l, Contents = pizzas, OrderTime = order.OrderTime }; return(result); }
public ActionResult Edit([FromRoute] int id, User user) { try { if (ModelState.IsValid) { var libUser = new Library.User { Id = id, FirstName = user.FirstName, LastName = user.LastName, DefaultLocation = user.DefaultLocation, LatestLocation = user.LatestLocation, LatestOrderId = user.LatestOrderId }; Repo.UpdateUser(libUser); Repo.Save(); return(RedirectToAction(nameof(Index))); } return(View(user)); } catch (Exception) { return(View(user)); } }
public void AddUser(Library.User user) { User u = Mapper.Map(user); u.DefaultLocation = db.Location.Find(user.DefaultLocation.LocationId); db.Add(u); db.SaveChanges(); user.UserId = u.UserId; }
public static User Map(Library.User otherUser) => new User { Username = otherUser.Username, FirstName = otherUser.FirstName, LastName = otherUser.LastName, Email = otherUser.Email, Phone = otherUser.Phone, FavStore = otherUser.FavStore };
public static Context.User Map(Library.User user) => new Context.User { Id = user.Id, FirstName = user.FirstName, LastName = user.LastName, DefaultLocation = user.DefaultLocation, LatestLocation = user.LatestLocation, LatestOrderId = user.LatestOrderId };
public IActionResult OrderBuildingNew() { //Create new OrderBuilder Library.User curUser = RH.UserRepo.GetUserByUsername((string)TempData.Peek("CurrentUser")); //TempData.Put("CurrentOrder", new Library.Order(curUser.Username, curUser.FavStore)); TempData.Put("OrderBuilder", new Library.OrderBuilder(curUser.Username, curUser.FavStore)); TempData["obFlag"] = "y"; //return proceed with OrderBuilding return(RedirectToAction(nameof(OrderBuilding))); }
// mapping library class to DB entity public static DataAccess.User Map(Library.User user) => new DataAccess.User { UserName = user.UserName, FirstName = user.FirstName, LastName = user.LastName, Password = user.Password, Wallet = user.Wallet, CreditCard = user.CreditCard, Admin = user.Admin };
public bool UpdateUser(Library.User user) { var temp = db.User.Find(user.UserId); if (temp != null) { db.Entry(temp).CurrentValues.SetValues(getNewUser(user).UserId = user.UserId); db.SaveChanges(); return(true); } return(false); }
public int GetUserID(Library.User user) { var users = _db.Users; foreach (var item in users) { if (user.FirstName == item.FirstName && user.LastName == item.LastName) { return(item.Id); } } return(0); }
public ActionResult Login(Login login) { try { if (ModelState.IsValid) { var repoUsers = Repo.GetUsers().ToList(); var searchedUser = new Library.User(); int searchedUserId = 0; bool found = false; if (login.FirstName == "Admin" && login.LastName == "Mama") { return(RedirectToAction(nameof(Index), "Home/Admin")); } foreach (var user in repoUsers) { if (login.FirstName == user.FirstName && login.LastName == user.LastName) { searchedUser = user; searchedUserId = user.Id; found = true; TempData["UserId"] = user.Id; TempData["DefaultLocationId"] = user.DefaultLocation; if (user.LatestOrderId != null) { var latestOrder = Repo.GetOrderById((int)user.LatestOrderId); TempData["LatestPizzaCount"] = latestOrder.CountPizzas(); TempData["LatestOrderTime"] = latestOrder.DateTime; TempData["LatestOrderLocation"] = latestOrder.LocationId; } } } if (!found) { var newId = repoUsers.Last().Id + 1; TempData["UserId"] = newId; return(RedirectToAction(nameof(Index), "User/Create")); } return(RedirectToAction(nameof(Index), "Order/Create")); } return(RedirectToAction(nameof(Index), "Order/Create")); } catch { return(View()); } }
public bool AddUser(Library.User user) { bool success = true; try { var userDB = Mapper.Map(user); _db.Add(userDB); _db.SaveChanges(); return(success); } catch { success = false; return(success); } }
public bool UpdateUser(Library.User user) { bool success = true; try { User userDB = Mapper.Map(user); _db.Entry(_db.User.Find(userDB.UserName)).CurrentValues.SetValues(userDB); // _db.Update(userDB); _db.SaveChanges(); return(success); } catch { success = false; return(success); } }
public ActionResult Index(OrderView order) { order.StoreNumber = order.PrefLocation; if (Repo.IsUserInDB(order.FirstName, order.LastName)) { order.UserId = Repo.GetUser(order.FirstName, order.LastName).ID; return(View("Order", order)); } var newUser = new Library.User { First = order.FirstName, Last = order.LastName, PrefLocation = order.PrefLocation }; Repo.AddUserToDB(newUser); Repo.Save(); return(View("Order", order)); }
private void btnLogin_Click(object sender, EventArgs e) { SQLiteConnection sqlite_conn; try { sqlite_conn = new SQLiteConnection("Data Source=ObrtnikDatabase.db;Version=3;New=false;Compress=True;"); sqlite_conn.Open(); Library.Helpers.SqLite.DBConnectionString = "Data Source=ObrtnikDatabase.db;Version=3;New=false;Compress=True;"; sqlite_conn.Close(); } catch (Exception) { XtraMessageBox.Show("Baza nije kreirana, molimo kreirajte bazu i usera!", "Greška", MessageBoxButtons.OK); return; } Library.User user = new Library.User(); if (user.CheckIfExist(txtUsername.Text)) { user.GetData(txtUsername.Text); Library.Helpers.Common.User = user; Microsoft.Win32.RegistryKey username; username = Microsoft.Win32.Registry.CurrentUser.CreateSubKey("Obrtnik Username"); username.SetValue("Obrtnik Username", txtUsername.Text); username.Close(); Microsoft.Win32.RegistryKey password; password = Microsoft.Win32.Registry.CurrentUser.CreateSubKey("Obrtnik Password"); password.SetValue("Obrtnik Password", txtPassword.Text); password.Close(); this.Close(); } else { XtraMessageBox.Show("Korisnik sa tim podacima nije pronađen!", "Greška", MessageBoxButtons.OK); return; } }
private void btnSignUp_Click(object sender, EventArgs e) { SQLiteConnection sqlite_conn; SQLiteCommand sqlite_cmd; try { sqlite_conn = new SQLiteConnection("Data Source=ObrtnikDatabase.db;Version=3;New=false;Compress=True;"); sqlite_conn.Open(); Library.Helpers.SqLite.DBConnectionString = "Data Source=ObrtnikDatabase.db;Version=3;New=false;Compress=True;"; Library.User user = new Library.User(); if (!user.CheckIfExist(txtUsername.Text)) { sqlite_cmd = sqlite_conn.CreateCommand(); //Unos novoga Korisnika sqlite_cmd.CommandText = "INSERT INTO Users (Username, Password) VALUES ('" + txtUsername.Text + "', '" + txtPassword.Text + "');"; sqlite_cmd.ExecuteNonQuery(); user.GetData(txtUsername.Text); Library.Helpers.Common.User = user; } else { user.GetData(txtUsername.Text); Library.Helpers.Common.User = user; XtraMessageBox.Show("Korisnik sa tim imenom već postoji, logiramo se s njime!", "Greška", MessageBoxButtons.OK); } sqlite_conn.Close(); this.Close(); } catch (Exception) { sqlite_conn = new SQLiteConnection("Data Source=ObrtnikDatabase.db;Version=3;New=True;Compress=True;"); sqlite_conn.Open(); sqlite_cmd = sqlite_conn.CreateCommand(); //Kreiranje tablica //Tablica korisnika sqlite_cmd.CommandText = "CREATE TABLE Users (Id INTEGER PRIMARY KEY, Username VARCHAR(100), Password VARCHAR(100));"; sqlite_cmd.ExecuteNonQuery(); //Tablica o obrtu sqlite_cmd.CommandText = "CREATE TABLE Obrt (Id INTEGER PRIMARY KEY,NazivObrta VARCHAR(100), Vlasnik VARCHAR(100)," + "Adresa VARCHAR(100),OIB VARCHAR(100),IBAN VARCHAR(100),Banka VARCHAR(100),Djelatnost VARCHAR(512), Logo BLOB);"; sqlite_cmd.ExecuteNonQuery(); //Tablica usluga sqlite_cmd.CommandText = "CREATE TABLE UslugeProizvodi (Id INTEGER PRIMARY KEY, Naziv VARCHAR(512), Kategorija VARCHAR(512));"; sqlite_cmd.ExecuteNonQuery(); //Tablica jedinica mjere sqlite_cmd.CommandText = "CREATE TABLE JedinicaMjere (Id INTEGER PRIMARY KEY, Naziv VARCHAR(512));"; sqlite_cmd.ExecuteNonQuery(); //Tablica Zakoni sqlite_cmd.CommandText = "CREATE TABLE Zakoni (Id INTEGER PRIMARY KEY, Naziv VARCHAR(512), Napomena VARCHAR(512));"; sqlite_cmd.ExecuteNonQuery(); //Tablica racun sqlite_cmd.CommandText = "CREATE TABLE Racuni (Id INTEGER PRIMARY KEY, KupacNaziv VARCHAR(512), Adresa VARCHAR(512)," + "Mjesto VARCHAR(512), OibKupca VARCHAR(512), NadnevakIzdavanjaRacuna DATETIME, DatumPredvideneIsporuke DATETIME," + "VrijemeIzrade DATETIME, DospijecePlacanja DATETIME, Napomena VARCHAR(512), IznosNaplacenGotovinom DECIMAL(10,2)," + "IznosNaplacenVirmanski DECIMAL(10,2), BrojIzvodaUplatnice INTEGER, NadnevakDatumUplate DATETIME);"; sqlite_cmd.ExecuteNonQuery(); //Tablica uslugaProizvod sqlite_cmd.CommandText = "CREATE TABLE UslugaProizvod (Id INTEGER PRIMARY KEY, UslugaIliProizvod VARCHAR(512), JedinicaMjere VARCHAR(512)," + "Kolicina INTEGER, Cijena DECIMAL(10,2), Iznos DECIMAL(10,2), Rabat INTEGER, RacunId INTEGER);"; sqlite_cmd.ExecuteNonQuery(); //Popunjavanje tablica //Popunjavanje tablice sa korisnikom sqlite_cmd.CommandText = "INSERT INTO Users (Username, Password) VALUES ('" + txtUsername.Text + "', '" + txtPassword.Text + "');"; sqlite_cmd.ExecuteNonQuery(); //Popunjavanje tablice sa mjernim jedinicama sqlite_cmd.CommandText = "INSERT INTO JedinicaMjere (Naziv) VALUES ('kg');"; sqlite_cmd.ExecuteNonQuery(); sqlite_cmd.CommandText = "INSERT INTO JedinicaMjere (Naziv) VALUES ('kom');"; sqlite_cmd.ExecuteNonQuery(); sqlite_cmd.CommandText = "INSERT INTO JedinicaMjere (Naziv) VALUES ('l');"; sqlite_cmd.ExecuteNonQuery(); sqlite_cmd.CommandText = "INSERT INTO JedinicaMjere (Naziv) VALUES ('sat');"; sqlite_cmd.ExecuteNonQuery(); //Popunjavanje tablice sa zakonima sqlite_cmd.CommandText = "INSERT INTO Zakoni (Naziv, Napomena) VALUES ('Usluge za domaće klijente', 'Oslobođeno PDV-a temeljem članka 90. Zakona o PDV-u');"; sqlite_cmd.ExecuteNonQuery(); sqlite_cmd.CommandText = "INSERT INTO Zakoni (Naziv, Napomena) VALUES ('Usluge za inozemne klijente', 'Oslobođeno PDV-a temeljem članka 17.točka 1 Zakona o PDV-u - reverse charge');"; sqlite_cmd.ExecuteNonQuery(); sqlite_cmd.CommandText = "INSERT INTO Zakoni (Naziv, Napomena) VALUES ('Roba za domaće klijente', 'Oslobođeno PDV-a temeljem članka 90. Zakona o PDV-u');"; sqlite_cmd.ExecuteNonQuery(); sqlite_cmd.CommandText = "INSERT INTO Zakoni (Naziv, Napomena) VALUES ('Roba za inozemne klijente', 'Oslobođeno PDV-a temeljem članka 90. Zakona o PDV-u');"; sqlite_cmd.ExecuteNonQuery(); sqlite_conn.Close(); Library.Helpers.SqLite.DBConnectionString = "Data Source=ObrtnikDatabase.db;Version=3;New=false;Compress=True;"; //Auto login Library.User user = new Library.User(); if (user.CheckIfExist(txtUsername.Text)) { user.GetData(txtUsername.Text); Library.Helpers.Common.User = user; } this.Close(); } }
public void DeleteUser(Library.User user) { db.Remove(db.User.Find(user.UserId)); }
//DOESN'T WORK BUT DO WE NEED THIS IMPLEMENTATION...? public void DeleteUser(Library.User user) { _db.Remove(Mapper.Map(user)); }
//Users public void AddUser(Library.User user) { _db.Add(Models.Mapper.Map(user)); }
public List <Library.Order> GetUserOrderHistory(Library.User user) { List <Order> os = db.Order.Where(a => a.UserId == user.UserId).Include(a => a.User).Include(b => b.Location).Include("OrderContent.Content").ToList(); return(GetOrderHistory(os)); }
public void UpdateUser(Library.User user) { _db.Entry(_db.Users.Find(user.Id)).CurrentValues.SetValues(Mapper.Map(user)); }
public bool DeleteUser(Library.User user) { return(DeleteUserId(user.UserId)); }
public List <Library.Order> GetUserOrderHistory(Library.User user) { return(GetUserIdOrderHistory(user.UserId)); }