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!"); }