/// <summary> /// Updates the mapping between medicines and groups /// Removes the existing mappings and then adds these new ones /// Maps the passed groups for a given medicine /// </summary> /// <param name="Groups">Groups to be mapped against a medicine</param> /// <param name="medicine">Medicine to be mapped</param> public static void UpdateGroupsOfMedicine(IList<Group> groups, Medicine medicine) { db.MedicinesGroups.DeleteAllOnSubmit(medicine.GroupsIds); List<Medicine_Group> medicine_groups = new List<Medicine_Group>(groups.Count); foreach (var group in groups) medicine_groups.Add(new Medicine_Group() { GroupId = group.Id, MedicineId = medicine.Id }); medicine.GroupsIds.Clear(); medicine.GroupsIds.AddRange(medicine_groups); }
/// <summary> /// Gets the existing connection if any for DB /// Creates an empty Medicine instance /// Used for creating a new medicine as we do not have any ID for it yet /// </summary> public MedicineViewModel() { db = App.ViewModel.db; db.Refresh(RefreshMode.OverwriteCurrentValues, db.Medicines); // Clear any unsaved changes Medicine = new Medicine(); }
public ReminderFactory(Medicine _medicine) { medicine = _medicine; }
/// <summary> /// Inserts sample data into the database /// </summary> /// <param name="db">Database context to use</param> private void InsertSampleData(MedicineContext db) { // Sample Medicines Medicine m1 = new Medicine() { Name = "saridon (sample)", MfgDate = DateTime.Now, ExpDate = DateTime.Now.AddMonths(3), CureFor = "Headache", Dosage = "4", DosageType = "cups", AgeGroup = "18+", Price = 20.50F, BoughtAddress = "Near Canara bank, Kormangala, Bangalore. Ph: 080-23399239", Quantity = 2, QuantityType = "pills", CreatedAt = DateTime.Now, UpdatedAt = DateTime.Now }; db.Medicines.InsertOnSubmit(m1); Medicine m2 = new Medicine() { Name = "nice (sample)", MfgDate = DateTime.Now, ExpDate = DateTime.Now.AddMonths(3), IsUsing = true, CureFor = "Fever", Dosage = "3", DosageType = "spoons", AgeGroup = "20+", Price = 25.50F, BoughtAddress = "Indiranagar, Bangalore. Ph: 080-23399239", Quantity = 4, QuantityType = "pills", CreatedAt = DateTime.Now, UpdatedAt = DateTime.Now }; db.Medicines.InsertOnSubmit(m2); db.SubmitChanges(); // Sample Groups Group g1 = new Group() { Name = "Is Using (sample)", CreatedAt = DateTime.Now, UpdatedAt = DateTime.Now }; db.Groups.InsertOnSubmit(g1); Group g2 = new Group() { Name = "Not Using (sample)", CreatedAt = DateTime.Now, UpdatedAt = DateTime.Now }; db.Groups.InsertOnSubmit(g2); db.SubmitChanges(); // Sample Associations db.MedicinesGroups.InsertOnSubmit(new Medicine_Group() { Medicine = m1, Group = g1 }); db.MedicinesGroups.InsertOnSubmit(new Medicine_Group() { Medicine = m2, Group = g2 }); db.SubmitChanges(); }