/// <summary>
/// Change Password of account
/// </summary>
/// <param name="userName"></param>
/// <param name="newPWD"></param>
public void ChangePassword(string userName, string newPWD)
{
Account ac = db.Accounts.Where(p => p.ac_userName == userName).SingleOrDefault();
ac.ac_pwd = MyUtil.Encryptor.SHA256_Encrypt(newPWD);
db.SaveChanges();
}
/// <summary>
/// Delete - Inactive Pet
/// </summary>
/// <param name="id"></param>
public void InactivePet(string id)
{
Pet p = db.Pets.Where(pet => pet.p_id == id).SingleOrDefault();
p.p_status = "Inactive";
db.SaveChanges();
}
public void SeedCountries(int countriesCount)
{
Console.WriteLine("Seeding Countries");
var randomCountryName = randomGenerator.GetRandomString(5, 50);
var countriesNames = db.Countries.Select(d => d.Name).ToList();
for (int i = 0; i < countriesCount; i++)
{
while (countriesNames.Contains(randomCountryName))
{
randomCountryName = randomGenerator.GetRandomString(10, 50);
}
countriesNames.Add(randomCountryName);
var country = new Country()
{
Name = randomCountryName
};
db.Countries.Add(country);
OptimizedDbSave();
}
db.SaveChanges();
}
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 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 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();
}
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 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();
}
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 RestorePetMedicine(String pm_id)
{
using (var db = new PetStoreEntities())
{
var PetMedicine = db.PetMedicines.Find(pm_id);
PetMedicine.pm_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();
}
}
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>
/// 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();
}
}
/// <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 GenerateProducts(PetStoreEntities data, int amountPerCategory = 400)
{
var categories = data.Categories.OrderBy(e => Guid.NewGuid()).Select(x => x.Id).ToList();
var species = data.Species.OrderBy(e => Guid.NewGuid());
var speciesCount = species.Count();
data.Configuration.AutoDetectChangesEnabled = false;
data.Configuration.ValidateOnSaveEnabled = false;
Console.WriteLine("Importing products in each category.");
foreach (var category in categories)
{
for (int j = 0; j < amountPerCategory; j++)
{
var product = new Product
{
CategoryId = category,
Name = RandomGenerator.GetString(5, 25),
Price = RandomGenerator.GetDecimal(10, 1000)
};
var suitableSpecies = RandomGenerator.GetNumber(2, 10);
for (int i = 0; i < suitableSpecies; i++)
{
var toSkip = RandomGenerator.GetNumber(0, speciesCount - 1);
product.Species.Add(species.Skip(toSkip).Take(1).First());
}
data.Products.Add(product);
}
Console.Write(".");
data.SaveChanges();
}
Console.WriteLine();
data.SaveChanges();
}
private void bbiRestore_ItemClick(object sender, ItemClickEventArgs e)
{
int index = gridView.FocusedRowHandle;
int id = int.Parse(gridView.GetRowCellValue(index, "u_id").ToString());
using (var db = new PetStoreEntities())
{
var update = (from u in db.Users where u.u_id == id select u).Single();
update.u_status = "Active";
db.SaveChanges();
}
bbiRestore.Enabled = false;
}
public void UpdateUser(int uID, string uName, string uGender, string uMail, string uPhone, string uAddress)
{
using (var db = new PetStoreEntities())
{
var User = db.Users.Find(uID);
User.u_name = uName;
User.u_gender = uGender;
User.u_email = uMail;
User.u_phone = uPhone;
User.u_address = uAddress;
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 GenerateCategories(PetStoreEntities data, int amount = 50)
{
Console.WriteLine("Importing categories...");
for (int i = 0; i < amount; i++)
{
data.Categories.Add(new Category
{
Name = RandomGenerator.GetString(5, 20)
});
}
data.SaveChanges();
}
/// <summary>
/// update food by food id
/// </summary>
/// <param name="pmID"></param>
/// <param name="pmName"></param>
/// <param name="pmPrice"></param>
/// <param name="pmPriceSell"></param>
/// <param name="pmAmount"></param>
public void UpdateMedicint(String pmID, String pmName, String pmImage, int pmPrice, int pmSalePrices, int pmAmount, String pmDescription, String pmStatus)
{
using (var db = new PetStoreEntities())
{
var PetMedicine = db.PetMedicines.Find(pmID);
PetMedicine.pm_name = pmName;
PetMedicine.pm_image = pmImage;
PetMedicine.pm_prices = pmPrice;
PetMedicine.pm_salePrice = pmSalePrices;
PetMedicine.pm_amount = pmAmount;
PetMedicine.pm_description = pmDescription;
PetMedicine.pm_status = pmStatus;
db.SaveChanges();
}
}
/// <summary>
/// update food by food id
/// </summary>
/// <param name="pfID"></param>
/// <param name="pfName"></param>
/// <param name="pfPrice"></param>
/// <param name="pfPriceSell"></param>
/// <param name="pfAmount"></param>
/// <param name="typeID"></param>
public void UpdateFood(String pfID, String pfName, int pfPrice, int pfPriceSell, int pfAmount, int typeID, String pfStatus, String pfImage)
{
using (var db = new PetStoreEntities())
{
var Petfood = db.PetFoods.Find(pfID);
Petfood.pf_name = pfName;
Petfood.pf_prices = pfPrice;
Petfood.pf_image = pfImage;
Petfood.pf_salePrice = pfPriceSell;
Petfood.pf_amount = pfAmount;
Petfood.t_id = typeID;
Petfood.pf_status = pfStatus;
db.SaveChanges();
}
}
/// <summary>
/// update food by food id
/// </summary>
/// <param name="ptID"></param>
/// <param name="ptName"></param>
/// <param name="ptPrice"></param>
/// <param name="ptPriceSell"></param>
/// <param name="ptAmount"></param>
public void UpdateToys(String ptID, String ptName, String ptImage, int ptPrice, int ptSalePrices, int ptAmount, String ptDescription, String ptStatus)
{
using (var db = new PetStoreEntities())
{
var PetToys = db.PetToys.Find(ptID);
PetToys.pt_name = ptName;
PetToys.pt_image = ptImage;
PetToys.pt_prices = ptPrice;
PetToys.pt_salePrice = ptSalePrices;
PetToys.pt_amount = ptAmount;
PetToys.pt_description = ptDescription;
PetToys.pt_status = ptStatus;
db.SaveChanges();
}
}
/// <summary>
/// Update Pet
/// </summary>
/// <param name="ID"></param>
/// <param name="Name"></param>
/// <param name="OPrice"></param>
/// <param name="SPrice"></param>
/// <param name="image"></param>
/// <param name="description"></param>
/// <param name="status"></param>
/// <param name="tID"></param>
public void UpdatePet(string ID, string Name, int OPrice, int SPrice, string image,
string description, string status, int tID)
{
using (var db = new PetStoreEntities())
{
var Pet = db.Pets.Find(ID);
Pet.p_name = Name;
Pet.p_prices = OPrice;
Pet.p_image = image;
Pet.p_salePrice = SPrice;
Pet.t_id = tID;
Pet.p_status = status;
Pet.p_description = description;
db.SaveChanges();
}
}
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!");
}
public static void ImportPets(int count)
{
Console.WriteLine("ImportPets");
var data = new PetStoreEntities();
var speciesIds = data.Species.Select(c => c.Id).ToList();
var speciesCount = speciesIds.Count;
// generate 5000 ids list
var speciesRandomIds = new List <int>();
// add the unique
speciesRandomIds.AddRange(speciesIds);
// add the rest to count
for (int i = 0; i < count - speciesCount; i++)
{
var randomSpecieIndex = RandomInstance.Next(0, speciesCount);
var randomId = speciesIds[randomSpecieIndex];
speciesRandomIds.Add(randomId);
}
// randomize
var shuffledSpeciesIds = speciesRandomIds.OrderBy(g => Guid.NewGuid()).ToList();
var colorsId = data.Colors.Select(c => c.Id).ToList();
var colorsCount = colorsId.Count;
var counter = 0;
foreach (var specieId in shuffledSpeciesIds)
{
var randomPrice = (decimal)((RandomInstance.NextDouble() * (2500 - 5)) + 5);
var randomColorIndex = RandomInstance.Next(0, colorsCount);
var randomColorId = colorsId[randomColorIndex];
var randomDate = RandomGenerator.RandomDate(new DateTime(2010, 1, 1), DateTime.Now.AddDays(-60));
var randomBreed = RandomGenerator.RandomString(0, 30);
var newPet = new Pet()
{
SpecieId = specieId,
DateOfBirth = randomDate,
Price = randomPrice,
ColorId = randomColorId,
Breed = randomBreed
};
data.Pets.Add(newPet);
counter++;
if (counter % 100 == 0)
{
data.SaveChanges();
data.Dispose();
data = new PetStoreEntities();
Console.Write(".");
}
}
data.SaveChanges();
data.Dispose();
}
public static void ImportProducts(int count)
{
Console.WriteLine("ImportProducts");
var data = new PetStoreEntities();
var categoriesIds = data.Categories.Select(c => c.Id).ToList();
var categoriesCount = categoriesIds.Count;
// generate 20000 ids list
var categoriesRandomCountryIds = new List <int>();
// add the unique 50
categoriesRandomCountryIds.AddRange(categoriesIds);
// add the rest to count
for (int i = 0; i < count - categoriesCount; i++)
{
var randomCategoriesIndex = RandomInstance.Next(0, categoriesCount);
var randomId = categoriesIds[randomCategoriesIndex];
categoriesRandomCountryIds.Add(randomId);
}
// randomize
var shuffledCategoryIds = categoriesRandomCountryIds.OrderBy(g => Guid.NewGuid()).ToList();
var productsNames = new HashSet <string>();
do
{
productsNames.Add(RandomGenerator.RandomString(5, 25));
}while (productsNames.Count < count);
var counter = 0;
foreach (var product in productsNames)
{
var id = shuffledCategoryIds[0];
shuffledCategoryIds.RemoveAt(0);
var newProduct = new PetProduct()
{
Name = product,
CategoryId = id,
Price = (decimal)((RandomInstance.NextDouble() * (1000 - 10)) + 10)
};
data.PetProducts.Add(newProduct);
counter++;
// add species match here
var speciesCount = RandomInstance.Next(2, 11);
var speciesToAdd = new HashSet <Species>();
var species = data.Species.OrderBy(s => Guid.NewGuid()).Take(speciesCount).ToList();
while (speciesToAdd.Count != speciesCount)
{
var specieIdRandomIndex = RandomInstance.Next(0, species.Count);
var randomSpecie = species[specieIdRandomIndex];
speciesToAdd.Add(randomSpecie);
}
foreach (var specie in speciesToAdd)
{
newProduct.Species.Add(specie);
}
if (counter % 10 == 0)
{
data.SaveChanges();
data.Dispose();
data = new PetStoreEntities();
Console.Write(".");
}
}
data.SaveChanges();
data.Dispose();
}
