public static void Import(PetStoreEntities db, int count)
{
var categoriesIds = db.Categories.OrderBy(c => Guid.NewGuid()).Select(c => c.Id).ToList();
var generator = RandomGenerator.Instance;
Console.WriteLine("Adding products");
for (int i = 0; i < count; i++)
{
var numberOfSpeciesTheProductIsSuitableFor = generator.GetRandomNumber(2, 10);
var speciesForCurrentProduct = db.Species.OrderBy(s => Guid.NewGuid()).Take(numberOfSpeciesTheProductIsSuitableFor).ToList();
db.Products.Add(new Product()
{
Price = generator.GetRandomNumber(10, 1000),
Name = generator.GetRandomString(5, 25),
CategoryId = categoriesIds[generator.GetRandomNumber(0, categoriesIds.Count - 1)],
Species = speciesForCurrentProduct
});
if (i % 100 == 0)
{
db.SaveChanges();
db.Dispose();
db = new PetStoreEntities();
db.Configuration.AutoDetectChangesEnabled = false;
db.Configuration.ValidateOnSaveEnabled = false;
Console.Write(".");
}
}
db.SaveChanges();
}
private void bbiEdit_ItemClick(object sender, ItemClickEventArgs e)
{
if (pfIDSelected != "")
{
EditPetFood epf = new EditPetFood();
var db = new PetStoreEntities();
var pf = db.PetFoods.Find(pfIDSelected);
var type = db.Types.Find(pf.t_id);
List <PetStore.Type> typeList = db.Types.ToList();
foreach (var item in typeList)
{
epf.te_Type.Properties.Items.Add(item.t_name);
}
epf.te_Type.SelectedItem = type.t_name;
//set data of item edit to Edit form
epf.te_FoodID.Text = pf.pf_id;
epf.te_FoodName.Text = pf.pf_name;
epf.te_FoodPrice.Text = pf.pf_prices + "";
epf.te_FoodSalePrice.Text = pf.pf_salePrice + "";
epf.te_FoodStatus.SelectedItem = pf.pf_status;
epf.te_FoodAmount.Text = pf.pf_amount + "";
//epf.te_Type.Text = type.t_name;
//show Edit form
epf.ShowDialog();
}
else
{
XtraMessageBox.Show("Please choose a food item to edit !!!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public static void Import(PetStoreEntities db, int count)
{
var speciesIds = db.Species.OrderBy(s => Guid.NewGuid()).Select(s => s.Id).ToList();
var generator = RandomGenerator.Instance;
var colorIds = db.Colors.OrderBy(c => Guid.NewGuid()).Select(c => c.Id).ToList();
Console.WriteLine("Adding pets");
for (int i = 0; i < count; i++)
{
db.Pets.Add(new Pet()
{
Breed = generator.GetRandomString(5, 30),
Price = generator.GetRandomNumber(5, 2500),
ColorId = colorIds[generator.GetRandomNumber(0, colorIds.Count - 1)],
DateOfBirth = generator.GetRandomDate(new DateTime(2010, 1, 1), DateTime.Now.AddDays(-60)),
SpeciesId = speciesIds[generator.GetRandomNumber(0, speciesIds.Count - 1)]
});
if (i % 100 == 0)
{
db.SaveChanges();
db.Dispose();
db = new PetStoreEntities();
db.Configuration.AutoDetectChangesEnabled = false;
db.Configuration.ValidateOnSaveEnabled = false;
Console.Write(".");
}
}
db.SaveChanges();
}
public PetAccessory getPetAccessory(String pa_id)
{
var db = new PetStoreEntities();
var pa = db.PetAccessories.Find(pa_id);
return(pa);
}
public static void ImportCategories(int count)
{
Console.WriteLine("ImportCategories");
var categoriesNames = new HashSet <string>();
do
{
categoriesNames.Add(RandomGenerator.RandomString(5, 20));
}while (categoriesNames.Count < count);
var data = new PetStoreEntities();
var counter = 0;
foreach (var category in categoriesNames)
{
var newcategory = new Category()
{
Name = category
};
data.Categories.Add(newcategory);
counter++;
if (counter % 100 == 0)
{
data.SaveChanges();
data.Dispose();
data = new PetStoreEntities();
Console.Write(".");
}
}
data.SaveChanges();
data.Dispose();
}
public static void GenerateCountries(PetStoreEntities data, int amount = 20)
{
var hash = new HashSet <string>();
Console.WriteLine("Importing countries...");
for (int i = 0; i < amount; i++)
{
var countryName = RandomGenerator.GetString(5, 50);
if (hash.Contains(countryName.ToLower()))
{
i--;
continue;
}
hash.Add(countryName.ToLower());
data.Countries.Add(new Country
{
Name = countryName
});
}
data.SaveChanges();
}
public static void GeneratePets(PetStoreEntities data)
{
var species = data.Species.OrderBy(e => Guid.NewGuid());
var colors = data.Colors.Select(c => c.Id).ToList();
var colorsLen = colors.Count;
Console.WriteLine("Importing pets for each species...");
foreach (var entry in species)
{
// Average of 50
var numberOfPets = RandomGenerator.GetNumber(20, 80);
for (int i = 0; i < numberOfPets; i++)
{
var pet = new Pet
{
Price = RandomGenerator.GetDecimal(5, 2500),
ColorId = colors[RandomGenerator.GetNumber(0) % colorsLen],
DateOfBirth = RandomGenerator.GetDate(DateTime.Now.AddYears(-5), DateTime.Now.AddDays(-60)),
Breed = RandomGenerator.GetString(5, 15)
};
entry.Pets.Add(pet);
}
Console.Write(".");
}
Console.WriteLine();
data.SaveChanges();
}
/// <summary>
/// Get Pets by ID
/// </summary>
/// <param name="pId"></param>
/// <returns></returns>
public Pet getPet(String pId)
{
var db = new PetStoreEntities();
var Pet = db.Pets.Find(pId);
return(Pet);
}
/// <summary>
/// Get gift by ID
/// </summary>
/// <param name="gId"></param>
/// <returns></returns>
public Gift getGift(String gId)
{
var db = new PetStoreEntities();
var Gift = db.Gifts.Find(gId);
return(Gift);
}
/// <summary>
///
/// </summary>
/// <param name="pmId"></param>
/// <returns></returns>
public PetMedicine getPetMedicine(String pmId)
{
var db = new PetStoreEntities();
var PetMedicine = db.PetMedicines.Find(pmId);
return(PetMedicine);
}
/// <summary>
/// get all food to arraylist
/// </summary>
/// <returns></returns>
public ArrayList GetAllPetMedicineToArrayList()
{
pmList = new ArrayList();
using (var db = new PetStoreEntities())
{
var selectStr = (from m in db.PetMedicines
select new
{
m.pm_id,
m.pm_name,
m.pm_salePrice,
m.pm_amount,
m.pm_description,
m.pm_status
});
foreach (var data in selectStr)
{
if (data.pm_amount > 0)
{
pmList.Add(new Object.Medicine(data.pm_id, data.pm_name, Convert.ToInt32(data.pm_salePrice),
Convert.ToInt32(data.pm_amount), data.pm_description, "Active"));
}
else
{
pmList.Add(new Object.Medicine(data.pm_id, data.pm_name, Convert.ToInt32(data.pm_salePrice),
Convert.ToInt32(data.pm_amount), data.pm_description, "Inactive"));
}
}
}
return(pmList);
}
/// <summary>
///
/// </summary>
/// <param name="pfId"></param>
/// <returns></returns>
public PetFood getPetFood(String pfId)
{
var db = new PetStoreEntities();
var Petfood = db.PetFoods.Find(pfId);
return(Petfood);
}
/// <summary>
/// Get Pet and type add to list
/// </summary>
/// <returns></returns>
public ArrayList getAllPet()
{
pList = new ArrayList();
using (PetStoreEntities db = new PetStoreEntities())
{
//join 2 table Pets and Type on database and retrieve specific fields
var query = (from p in db.Pets
join t in db.Types on p.t_id equals t.t_id
select new
{
p.p_id,
p.p_name,
p.p_salePrice,
p.p_description,
p.p_status,
t.t_name
});
//Add each result on query to list
foreach (var item in query)
{
pList.Add(new Object.Pet(item.p_id, item.p_name,
Convert.ToInt32(item.p_salePrice), item.p_description, item.p_status,
item.t_name));
}
}
return(pList);
}
/// <summary>
/// get all data comment reply
/// </summary>
/// <returns>comment detail list</returns>
public ArrayList GetAllDataToArrayList()
{
cmtdList = new ArrayList();
using (var db = new PetStoreEntities())
{
var selectStr = (from cmtd in db.CommentDetails
join u in db.Users on cmtd.u_id equals u.u_id
join cmt in db.Comments on cmtd.cmt_id equals cmt.cmt_id
select new
{
cmtd.cmtd_id,
cmt.cmt_content,
cmtd.cmtd_content,
cmtd.cmtd_published,
u.u_name,
cmtd.cmtd_status
});
foreach (var data in selectStr)
{
cmtdList.Add(new Object.CommentDetail(data.cmtd_id, data.cmt_content, data.cmtd_content, data.cmtd_published.ToString(), data.u_name, data.cmtd_status));
}
}
return(cmtdList);
}
/// <summary>
/// get all food to arraylist
/// </summary>
/// <returns></returns>
public ArrayList GetAllPetFoodToArrayList()
{
pfList = new ArrayList();
using (var db = new PetStoreEntities())
{
var selectStr = (from f in db.PetFoods
join t in db.Types on f.t_id equals t.t_id
select new
{
f.pf_id,
f.pf_name,
f.pf_salePrice,
f.pf_amount,
t.t_name,
f.pf_status
});
foreach (var data in selectStr)
{
if (data.pf_amount > 0)
{
pfList.Add(new Object.Food(data.pf_id, data.pf_name, Convert.ToInt32(data.pf_salePrice),
Convert.ToInt32(data.pf_amount), data.t_name, "Active"));
}
else
{
pfList.Add(new Object.Food(data.pf_id, data.pf_name, Convert.ToInt32(data.pf_salePrice),
Convert.ToInt32(data.pf_amount), data.t_name, "Inactive"));
}
}
}
return(pfList);
}
/// <summary>
///
/// </summary>
/// <param name="ptId"></param>
/// <returns></returns>
public PetToy getPetToy(String ptId)
{
var db = new PetStoreEntities();
var PetToys = db.PetToys.Find(ptId);
return(PetToys);
}
public void DeleteAcc(String pa_id)
{
using (var db = new PetStoreEntities())
{
var PetAccessories = db.PetAccessories.Find(pa_id);
}
}
public static void GenerateSpecies(PetStoreEntities data, int amount = 100)
{
var countries = data.Countries.OrderBy(e => Guid.NewGuid());
var hash = new HashSet <string>();
Console.WriteLine("Importing species for each country...");
foreach (var country in countries)
{
// Average of 5, as per Ivaylo's video... or as per Basic Maths
var numberOfSpecies = RandomGenerator.GetNumber(2, 8);
for (int i = 0; i < numberOfSpecies; i++)
{
var speciesName = RandomGenerator.GetString(5, 50);
if (hash.Contains(speciesName.ToLower()))
{
i--;
continue;
}
hash.Add(speciesName.ToLower());
var species = new Species
{
Name = speciesName
};
country.Species.Add(species);
}
}
data.SaveChanges();
}
public static void ImportSpecies(int count)
{
Console.WriteLine("ImportSpecies");
var data = new PetStoreEntities();
var coutriesIds = data.Countries.Select(c => c.Id).ToList();
var countriesCount = coutriesIds.Count;
// generate 100 ids list
var countriesRandomCountryIds = new List <int>();
// add the unique 20
countriesRandomCountryIds.AddRange(coutriesIds);
// add the rest to count
for (int i = 0; i < count - countriesCount; i++)
{
var randomCountryIndex = RandomInstance.Next(0, countriesCount);
var randomId = coutriesIds[randomCountryIndex];
countriesRandomCountryIds.Add(randomId);
}
// randomize
var shuffledCountryIds = countriesRandomCountryIds.OrderBy(g => Guid.NewGuid()).ToList();
var speciesNames = new HashSet <string>();
do
{
speciesNames.Add(RandomGenerator.RandomString(5, 50));
}while (speciesNames.Count < count);
var counter = 0;
foreach (var specie in speciesNames)
{
var id = shuffledCountryIds[0];
shuffledCountryIds.RemoveAt(0);
var newSpecie = new Species()
{
Name = specie,
CountryId = id
};
data.Species.Add(newSpecie);
counter++;
if (counter % 100 == 0)
{
data.SaveChanges();
data.Dispose();
data = new PetStoreEntities();
Console.Write(".");
}
}
data.SaveChanges();
data.Dispose();
}
public void GetImage(String pm_id)
{
using (var db = new PetStoreEntities())
{
var PMDImage = db.PetMedicines.Find(pm_id);
string imagelink = PMDImage.pm_image;
}
}
private void AddSpecies(PetStoreEntities db, string name, int countryId)
{
db.Species.Add(new Species
{
Name = name,
CountryId = countryId
});
}
/// <summary>
/// delete comment reply by id
/// </summary>
/// <param name="cmtd_id"></param>
public void RestoreCommentDetail(int cmtd_id)
{
using (var db = new PetStoreEntities())
{
var cmt = db.CommentDetails.Find(cmtd_id);
cmt.cmtd_status = "Active";
db.SaveChanges();
}
}
public void RestorePetFood(String pf_id)
{
using (var db = new PetStoreEntities())
{
var Petfood = db.PetFoods.Find(pf_id);
Petfood.pf_status = "Active";
db.SaveChanges();
}
}
public void RestorePetToys(String pt_id)
{
using (var db = new PetStoreEntities())
{
var PetToys = db.PetToys.Find(pt_id);
PetToys.pt_status = "Active";
db.SaveChanges();
}
}
/// <summary>
/// Restore gift
/// </summary>
/// <param name="g_id"></param>
public void RestoreGift(String g_id)
{
using (var db = new PetStoreEntities())
{
var Gift = db.Gifts.Find(g_id);
Gift.g_status = "Active";
db.SaveChanges();
}
}
public void DeletePetAccessories(String pa_id)
{
using (var db = new PetStoreEntities())
{
var PetAccessories = db.PetAccessories.Find(pa_id);
PetAccessories.pa_status = "Inactive";
db.SaveChanges();
}
}
/// <summary>
///
/// </summary>
/// <param name="cmt_id"></param>
public void DeleteComment(int cmt_id)
{
using (var db = new PetStoreEntities())
{
var cmt = db.Comments.Find(cmt_id);
cmt.cmt_status = "Inactive";
db.SaveChanges();
}
}
private void OptimizedDbSave()
{
if (db.ChangeTracker.Entries().Count() > 100)
{
db.SaveChanges();
db = new PetStoreEntities();
Console.Write(".");
}
}
public void RestorePetMedicine(String pm_id)
{
using (var db = new PetStoreEntities())
{
var PetMedicine = db.PetMedicines.Find(pm_id);
PetMedicine.pm_status = "Active";
db.SaveChanges();
}
}
public string getUName(int?uID)
{
using (var db = new PetStoreEntities())
{
var User = db.Users.Find(uID);
return(User.u_name);
}
return(null);
}
private void AddSpecies(PetStoreEntities db, int speciesId, int colorId)
{
db.Pets.Add(new Pet
{
BirthTime = RandomGenerator.RandomDateTime(),
Breed = RandomGenerator.RandomString(5, 30),
ColorId = colorId,
Price = RandomGenerator.RandomNumber(5, 2500),
SpeciesId = speciesId
});
}
/// <summary>
/// Update gift
/// </summary>
/// <param name="gID"></param>
/// <param name="gName"></param>
/// <param name="gStatus"></param>
/// <param name="gImage"></param>
public void UpdateGift(String gID, String gName, String gStatus, String gImage)
{
using (var db = new PetStoreEntities())
{
var Gift = db.Gifts.Find(gID);
Gift.g_name = gName;
Gift.g_image = gImage;
Gift.g_status = gStatus;
db.SaveChanges();
}
}
public static void Import(PetStoreEntities db, int count)
{
for (int i = 0; i < count; i++)
{
db.Categories.Add(new Category()
{
Name = RandomGenerator.Instance.GetRandomString(5, 20)
});
}
db.SaveChanges();
Console.WriteLine("Categories added!");
}
public static void Main()
{
var data = new PetStoreEntities();
var commands = new List<ICommand>()
{
new CountiesCommand(data),
new SpeciesCommand(data),
new PetsCommand(data),
new CategoriesCommand(data),
new ProductsCommand(data)
};
foreach (var command in commands)
{
command.Execute();
Console.WriteLine("\n" + command.Message());
}
}
public static void Import(PetStoreEntities db, int count)
{
// using hashset because we must have unique names
var countryNames = new HashSet<string>();
while (countryNames.Count < count)
{
var name = RandomGenerator.Instance.GetRandomString(5, 50);
countryNames.Add(name);
}
foreach (var countryName in countryNames)
{
db.Countries.Add(new Country() { Name = countryName });
}
db.SaveChanges();
Console.WriteLine("Countries added!");
}
public static void Import(PetStoreEntities db, int count)
{
var countryIds = db.Countries.OrderBy(c => Guid.NewGuid()).Select(c => c.Id).ToList();
// using hashset because we must have unique names
var speciesNames = new HashSet<string>();
while (speciesNames.Count < count)
{
var name = RandomGenerator.Instance.GetRandomString(5, 50);
speciesNames.Add(name);
}
var speciesNamesAsList = speciesNames.ToList();
// ensure there is atleast one species per country
for (int i = 0; i < countryIds.Count; i++)
{
db.Species.Add(new Species()
{
Name = speciesNamesAsList[i],
OriginCountryId = countryIds[i],
});
}
// assign country to other species at random
for (int i = countryIds.Count; i < speciesNamesAsList.Count; i++)
{
db.Species.Add(new Species()
{
Name = speciesNamesAsList[i],
OriginCountryId = countryIds[RandomGenerator.Instance.GetRandomNumber(0, countryIds.Count - 1)],
});
}
db.SaveChanges();
Console.WriteLine("Species added!");
}
