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