/// <summary> /// Remove category from family. /// </summary> /// <param name="id">Id of family</param> /// <param name="category">Category object</param> public static void RemoveCategoryFromFamily(int id, Category category) { using (dbRamotEntities db = new dbRamotEntities()) { Families f = db.Families.Find(id); f.Categories.Remove(Mapper.CastCategory(category)); db.SaveChanges(); } }
/// <summary> /// Add category to family. /// </summary> /// <param name="id">Id of family</param> /// <param name="category">Category object</param> public static void AddCategoryToFamily(int id, Category[] category) { using (dbRamotEntities db = new dbRamotEntities()) { Families f = db.Families.Find(id); foreach (var item in category) { var c = db.Categories.FirstOrDefault(ca => ca.Id == item.Id); f.Categories.Add(c); } db.SaveChanges(); } }
public static IEnumerable <Common.Organization> GetOrganizations(int id) { List <Common.Organization> organizations = new List <Common.Organization>(); using (dbRamotEntities db = new dbRamotEntities()) { Families v = db.Families.Find(id); var f = db.OrganizationAndFamily.Where(g => g.IdFamily == id).Select(g => g.IdOrganization).ToArray(); foreach (var o in f) { organizations.Add(Mapper.CastOrganizationToComon(db.Organization.Find(o))); } } return(organizations); }
/// <summary> /// Update family with new information, including categories. /// </summary> /// <param name="family">Family object</param> /// <param name="categories">List of categories</param> public static void UpdateFamily(Family family, Category[] categories) { Families v = Mapper.CastFamily(family); using (dbRamotEntities db = new dbRamotEntities()) { db.Families.Find(family.Id).Categories.Clear(); foreach (var item in categories) { var c = db.Categories.FirstOrDefault(ca => ca.Id == item.Id); db.Families.Find(family.Id).Categories.Add(c); } db.Entry <Families>(db.Set <Families>().Find(v.Id)).CurrentValues.SetValues(v); db.SaveChanges(); } }
public static Family CastFamilyToComon(Families family) { return(family == null ? null : new Family() { Id = family.Id, FirstNameFather = family.FirstNameFather, FirstNameMother = family.FirstNameMother, Address = family.Address, LastName = family.LastName, NumChildren = family.NumChildren, PelephoneFather = family.PelephoneFather, PelephoneMother = family.PelephoneMother, Reason = family.Reason, Reference = family.Reference, Status = family.Status, Telephone = family.Telephone }); }
/// <summary> /// Add family to db. /// </summary> /// <param name="family">Family object</param> /// <param name="categories">List of categories</param> /// <returns>Id of added family</returns> public static int AddFamily(Family family, Category[] categories) { int x = 0; Family newFamily = null; Families f = Mapper.CastFamily(family); using (dbRamotEntities db = new dbRamotEntities()) { foreach (var item in categories) { var c = db.Categories.FirstOrDefault(ca => ca.Id == item.Id); f.Categories.Add(c); } db.Families.Add(f); db.SaveChanges(); x = db.Families.Local[0].Id; newFamily = Mapper.CastFamilyToComon(db.Families.Local[0]); } return(x); }