public bool Find(string username, string password)
{
using (var db = new ArtStoreDbContext())
{
return(db.Users.Any(u => u.Username == username && u.Password == password));
}
}
public bool IsAdmin(string username)
{
using (var db = new ArtStoreDbContext())
{
return(db.Users.Any(u => u.Username == username && u.IsAdmin));
}
}
public static void Seed(ArtStoreDbContext db)
{
if (!db.Shops.Any())
{
var owners = db
.Users
.Where(u => u.IsShopOwner == true)
.ToList();
var shops = new List <Shop>
{
new Shop
{
Description = "Best shop in the world. Must Visit",
Name = "Galaxy sheep",
OwnerId = 2,
DateCreated = DateTime.Now
},
new Shop
{
Description = "Please buy my things, I need money to eat",
Name = "Hipster extravaganza",
OwnerId = 3,
DateCreated = DateTime.Now
}
};
db.AddRange(shops);
db.SaveChanges();
}
}
public bool Create(string username, string email, string firstname, string lastName, string password)
{
using (var db = new ArtStoreDbContext())
{
if (db.Users.Any(u => u.Username == username))
{
return(false);
}
var isAdmin = !db.Users.Any();
var user = new User
{
Username = username,
Email = email,
FirstName = firstname,
LastName = lastName,
Password = password,
IsAdmin = isAdmin
};
db.Add(user);
db.SaveChanges();
}
return(true);
}
public void InitializeDatabase()
{
using (var db = new ArtStoreDbContext())
{
//db.Database.EnsureDeleted();
db.Database.EnsureCreated();
db.Database.Migrate();
//UserService.Seed(db);
//ShopService.Seed(db);
}
}
public User GetById(int id)
{
using (var db = new ArtStoreDbContext())
{
var user = db
.Users
.Where(u => u.Id == id)
.FirstOrDefault();
return(user);
}
}
public string GetById(int id)
{
using (var db = new ArtStoreDbContext())
{
var shop = db
.Shops
.Where(s => s.Id == id)
.Select(s => new ShopDTO(s).ToJson())
.FirstOrDefault();
return(shop);
}
}
public string GetById(int id)
{
using (var db = new ArtStoreDbContext())
{
var item = db
.ItemsForSale
.Where(i => i.Id == id)
.Select(i => new ItemForSaleDTO(i).ToJson())
.FirstOrDefault();
return(item);
}
}
public string All()
{
using (var db = new ArtStoreDbContext())
{
StringBuilder sb = new StringBuilder();
var data = db.Users.Select(u => new UserDTO(u).ToJson()).ToList();
sb.Append("{");
sb.Append(string.Join(',', data));
sb.Append("}");
return(sb.ToString());
}
}
public string All()
{
using (var db = new ArtStoreDbContext())
{
StringBuilder sb = new StringBuilder();
var data = db.ItemsForSale.Select(i => new ItemForSaleDTO(i).ToJson()).ToList();
sb.Append("{");
sb.Append(string.Join(',', data));
sb.Append("}");
return(sb.ToString());
}
}
public static void Seed(ArtStoreDbContext db)
{
if (!db.Users.Any())
{
var users = new List <User>
{
new User
{
Username = "******",
Password = "******",
Email = "*****@*****.**",
FirstName = "Dannie",
LastName = "Vasileva",
IsAdmin = true
},
new User
{
Username = "******",
Password = "******",
Email = "*****@*****.**",
FirstName = "Rali",
LastName = "Vasileva",
IsShopOwner = true
},
new User
{
Username = "******",
Password = "******",
Email = "*****@*****.**",
FirstName = "Arthur",
LastName = "The Cat",
IsShopOwner = true
},
new User
{
Username = "******",
Password = "******",
Email = "*****@*****.**",
FirstName = "Sisi",
LastName = "The Cat",
},
};
db.AddRange(users);
db.SaveChanges();
}
}
public bool Create(string name, string description, int ownerId)
{
using (var db = new ArtStoreDbContext())
{
var shop = new Shop
{
Name = name,
Description = description,
OwnerId = ownerId
};
db.Add(shop);
db.SaveChanges();
}
return(true);
}
public bool Create(string title, string description, decimal price, int sellerId)
{
using (var db = new ArtStoreDbContext())
{
var item = new ItemForSale
{
Title = title,
Description = description,
Price = price,
SellerId = sellerId,
DateCreated = DateTime.Now
};
db.Add(item);
db.SaveChanges();
}
return(true);
}
public static void Seed(ArtStoreDbContext db)
{
if (!db.ItemsForSale.Any())
{
var items = new List <ItemForSale>
{
new ItemForSale
{
Title = "Witchy Sticker Sheet # 1",
Description = "Compilation of cute stickers",
Price = 4.5m,
ShopId = 1,
SellerId = 2,
DateCreated = DateTime.Now
},
new ItemForSale
{
Title = "Witchy Sticker Sheet # 2",
Description = "Next generation cute stickers",
Price = 5m,
ShopId = 1,
SellerId = 2,
DateCreated = DateTime.Now
},
new ItemForSale
{
Title = "Mina Lisa",
Description = "Like, totally not a fake!!",
Price = 20000m,
ShopId = 2,
SellerId = 3,
DateCreated = DateTime.Now
},
};
db.AddRange(items);
db.SaveChanges();
}
}
