/// <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);
}
