public Store(List <AIngredient> inv, Location loc)
{
Orders = new List <Order>();
StoreLocation = loc;
Inventory = inv;
foreach (var item in inv)
{
item.Store = this;
}
var locToDb = new Data.Entities.Location
{
Address1 = loc.Address1,
Address2 = loc.Address2,
City = loc.City,
State = loc.State,
ZipCode = loc.ZipCode
};
// _db.Location.Add(locToDb);
// _db.SaveChanges();
// var storeToDb = new Data.Entities.Store
// {
// StoreNavigation = _db.Location.FirstOrDefault(l => l.Address1 == loc.Address1)
// };
// _db.Store.Add(storeToDb);
// _db.SaveChanges();
}
public Domain.Location ReadLocation(string name)
{
try
{
List <Data.Entities.Location> location = db.Location
.Where(l => l.Name.ToLower().Equals(name.ToLower()))
.ToList();
Data.Entities.Location loc = location.First();
var invEntity = db.InventoryItem
.Include(c => c.C)
.Where(ie => ie.LocId == loc.LocId)
.ToList();
var o = new Location(loc.Name, loc.Address);
o.Inventory = GetInventory(invEntity);
return(o);
}
catch (System.InvalidOperationException)
{
return(null);
}
}
public void ModifyInventory(Domain.Location loc, Domain.PizzaComponent pc, int quantity)
{
Data.Entities.Location locEntity = GetLocationEntity(loc.Name);
Data.Entities.Component compEntity = GetComponentEntity(pc);
if (compEntity is null)
{
compEntity = RegisterComponent(pc);
}
Data.Entities.InventoryItem invEntity = locEntity.InventoryItem.ToList()
.Find(i => i.Cid.Equals(compEntity.Cid));
if (!(invEntity is null))
{
invEntity.Quantity = quantity;
db.SaveChanges();
return;
}
invEntity = new Data.Entities.InventoryItem();
invEntity.Loc = locEntity;
invEntity.C = compEntity;
invEntity.Quantity = quantity;
locEntity.InventoryItem.Add(invEntity);
db.SaveChanges();
}
public User(string fn, string ln, string email, string pw, Location loc)
{
Orders = new List <Order>();
var locToDb = new Data.Entities.Location
{
Address1 = loc.Address1,
Address2 = loc.Address2,
City = loc.City,
State = loc.State,
ZipCode = loc.ZipCode
};
_db.Location.Add(locToDb);
_db.SaveChanges();
var usertoDb = new Data.Entities.User
{
FirstName = fn,
LastName = ln,
EmailAddress = email,
Password = pw,
Location = _db.Location.FirstOrDefault(l => l.Address1 == loc.Address1)
};
_db.User.Add(usertoDb);
_db.SaveChanges();
}
public static Domain.Location Map(Data.Entities.Location deLocation) => new Domain.Location
{
Id = deLocation.Id,
Street = deLocation.Street,
City = deLocation.City,
State = deLocation.State,
ZipCode = deLocation.ZipCode,
Phone = deLocation.Phone
};
public static Domain.Location Map(Data.Entities.Location deLocation) => new Domain.Location
{
Locationid = deLocation.Locationid,
Street1 = deLocation.Street1,
Street2 = deLocation.Street2,
City = deLocation.City,
State = deLocation.State,
Country = deLocation.Country,
Zipcode = deLocation.Zipcode
};
public void RegisterLocation(string name, string address)
{
if (ReadLocation(name) is null)
{
Data.Entities.Location _loc = new Data.Entities.Location();
_loc.Name = name;
_loc.Address = address;
db.Add(_loc);
db.SaveChanges();
}
}
public void SaveOrder(Domain.Order order, Domain.Location loc, Domain.User u)
{
try
{
List <Data.Entities.Location> location = db.Location
.Where(l => l.Name.ToLower().Equals(loc.Name.ToLower()))
.ToList();
Data.Entities.Location locEntity = location.First();
List <Data.Entities.User> user = db.User
.Where(us => us.Username.ToLower().Equals(u.Username.ToLower()))
.ToList();
Data.Entities.User userEntity = user.First();
Data.Entities.Order result = new Data.Entities.Order();
result.User = userEntity;
result.Loc = locEntity;
foreach (var p in order._pizzas)
{
Data.Entities.Pizza pizzaEntity = new Data.Entities.Pizza();
Data.Entities.PizzaComponent cheeseEntity = new Data.Entities.PizzaComponent();
cheeseEntity.C = GetComponentEntity(p.Cheese);
Data.Entities.PizzaComponent crustEntity = new Data.Entities.PizzaComponent();
crustEntity.C = GetComponentEntity(p.Crust);
Data.Entities.PizzaComponent sizeEntity = new Data.Entities.PizzaComponent();
sizeEntity.C = GetComponentEntity(p.Size);
pizzaEntity.PizzaComponent.Add(cheeseEntity);
pizzaEntity.PizzaComponent.Add(crustEntity);
pizzaEntity.PizzaComponent.Add(sizeEntity);
foreach (var t in p._toppings)
{
Data.Entities.PizzaComponent toppingEntity = new Data.Entities.PizzaComponent();
toppingEntity.C = GetComponentEntity(t);
pizzaEntity.PizzaComponent.Add(toppingEntity);
}
result.Pizza.Add(pizzaEntity);
}
db.Add(result);
db.SaveChanges();
}
catch (System.InvalidOperationException)
{
}
}
public Data.Entities.Location GetLocationEntity(string name)
{
try
{
List <Data.Entities.Location> location = db.Location
.Where(l => l.Name.ToLower().Equals(name.ToLower()))
.ToList();
Data.Entities.Location loc = location.First();
return(loc);
}
catch (System.InvalidOperationException)
{
return(null);
}
}
public Location(string a1, string a2, string city, string state, int zip)
{
Address1 = a1;
Address2 = a2;
City = city;
State = state;
ZipCode = zip;
var locToDb = new Data.Entities.Location
{
Address1 = a1,
Address2 = a2,
City = city,
State = state,
ZipCode = zip
};
_db.Location.Add(locToDb);
_db.SaveChanges();
}
