public static int SetLocation(dom.Location domloc)
{
var _db = new PizzaStoreDbContext();
var dataloc = new Location()
{
ModifiedDate = DateTime.Now
};
_db.Location.Add(dataloc);
return(_db.SaveChanges());
}
public static dom.Location GetLocationByOrder(Order dr)
{
var _db = new PizzaStoreDbContext();
var dataStore = _db.Location.Where(l => l.LocationId == dr.StoreId).FirstOrDefault();
dom.Location domstore = new dom.Location()
{
Id = dataStore.LocationId
,
ModifiedDate = dataStore.ModifiedDate
};
return(domstore);
}
//public static double GetLocationSales(pdm.Location location)
//{
// var orders = OrderHelper.GetOrderByLocation(location);
// var sum = 0D;
// foreach (var item in orders)
// {
// sum += item.Total;
// }
// return sum;
//}
//public static List<pdm.User> GetLocationUsers(pdm.Location location)
//{
// var dataLocation = _db.Location.Where(l => l.LocationId == location.LocationId).FirstOrDefault();
// var users = new List<pdm.User>();
// foreach (var item in dataLocation.Order.ToList())
// {
// users.Add(new pdm.User()
// {
// UserId = item.User.UserId
// });
// }
// return users;
//}
public static bool SetLocation(pdm.Location location)
{
var dataLocation = new Location()
{
Name = location.Name
//Address = new Address()
//{
// City = location.Address.City,
// State = location.Address.State,
// Street = location.Address.Street
//}
};
_db.Location.Add(dataLocation);
return(_db.SaveChanges() == 1);
}
//private static PizzaStoreDbContext _db = new PizzaStoreDbContext();
public static List <dom.Location> GetLocations()
{
var _db = new PizzaStoreDbContext();
var ls = new List <dom.Location>();
foreach (var l in _db.Location.ToList())
{
if (l.Active == true)
{
dom.Location store = new dom.Location()
{
Id = l.LocationId,
ModifiedDate = l.ModifiedDate
};
ls.Add(store);
}
}
return(ls);
}