/// <summary>
/// Get family by id
/// </summary>
/// <param name="id">Id of family</param>
/// <returns>Family object</returns>
public static Family GetFamily(int id)
{
using (dbRamotEntities db = new dbRamotEntities())
{
return(Mapper.CastFamilyToComon(db.Families.Find(id)));
}
}
public static void RemoveCategory(Category category)
{
Categories c = Mapper.CastCategory(category);
using (dbRamotEntities db = new dbRamotEntities())
{
foreach (var item in db.Volunteers)
{
item.Categories.Remove(c);
}
foreach (var item in db.Families)
{
item.Categories.Remove(c);
}
foreach (var item in db.Events)
{
item.Categories.Remove(c);
}
foreach (var item in db.Organization)
{
item.Categories.Remove(c);
}
db.Categories.Remove(c);
db.SaveChanges();
}
}
/// <summary>
/// Get volunteer by id
/// </summary>
/// <param name="id">Id of volunteer searching for</param>
/// <returns>Volunteer</returns>
public static Volunteer GetVolunteer(int id)
{
using (dbRamotEntities db = new dbRamotEntities())
{
return(Mapper.CastVolunteerToComon(db.Volunteers.Find(id)));
}
}
public static Common.Organization GetOrganization(int id)
{
using (dbRamotEntities db = new dbRamotEntities())
{
return(Mapper.CastOrganizationToComon(db.Organization.Find(id)));
}
}
public static Common.VolunteerAndFamily GetVolunteerAndFamily(int id)
{
using (dbRamotEntities db = new dbRamotEntities())
{
return(Mapper.CastVolunteerAndFamilyToComon(db.VolunteerAndFamily.Find(id)));
}
}
public static Common.VolunteerAndEvent GetVolunteerAndEvent(int id)
{
using (dbRamotEntities db = new dbRamotEntities())
{
return(Mapper.CastVolunteerAndEventToComon(db.VolunteerAndEvent.Find(id)));
}
}
public static Category GetCategory(int id)
{
using (dbRamotEntities db = new dbRamotEntities())
{
return(Mapper.CastCategoryToCommon(db.Categories.Find(id)));
}
}
public static Group GetGroup(int id)
{
using (dbRamotEntities db = new dbRamotEntities())
{
return(Mapper.CastGroupToComon(db.Groups.Find(id)));
}
}
public static Event GetEvent(int id)
{
using (dbRamotEntities db = new dbRamotEntities())
{
return(Mapper.CastEventToComon(db.Events.Find(id)));
}
}
public static Volunteer GetMostVolunteer()
{
using (dbRamotEntities db = new dbRamotEntities())
{
var volunteer = db.Volunteers.OrderBy(v => v.VolunteerAndFamily.Count + v.VolunteerAndEvent.Count).ToList();
return(Mapper.CastVolunteerToComon(volunteer.Last()));
}
}
public static Family GetMostFamily()
{
using (dbRamotEntities db = new dbRamotEntities())
{
var family = db.Families.OrderBy(f => f.VolunteerAndFamily.Count + f.OrganizationAndFamily.Count).ToList();
return(Mapper.CastFamilyToComon(family.Last()));
}
}
public static Common.Organization GetMostOrganization()
{
using (dbRamotEntities db = new dbRamotEntities())
{
var organization = db.Organization.OrderBy(f => f.OrganizationAndFamily.Count).ToList();
return(Mapper.CastOrganizationToComon(organization.Last()));
}
}
public static void RemoveOrganizationAndFamily(int id)
{
using (dbRamotEntities db = new dbRamotEntities())
{
db.OrganizationAndFamily.Remove(db.OrganizationAndFamily.Find(id));
db.SaveChanges();
}
}
public static void RemoveVolunteerAndEvent(int id)
{
using (dbRamotEntities db = new dbRamotEntities())
{
db.VolunteerAndEvent.Remove(db.VolunteerAndEvent.Find(id));
db.SaveChanges();
}
}
/// <summary>
/// Remove category from volunter
/// </summary>
/// <param name="id">Id of volunteer</param>
/// <param name="category">Category object</param>
public static void RemoveCategoryFromVolunteer(int id, Category category)
{
using (dbRamotEntities db = new dbRamotEntities())
{
Volunteers v = db.Volunteers.Find(id);
v.Categories.Remove(Mapper.CastCategory(category));
db.SaveChanges();
}
}
public static void RemoveCategoryFromOrganization(int id, Category category)
{
using (dbRamotEntities db = new dbRamotEntities())
{
Organization e = db.Organization.Find(id);
e.Categories.Remove(Mapper.CastCategory(category));
db.SaveChanges();
}
}
public static void RemoveCategoryFromEvent(int id, Category category)
{
using (dbRamotEntities db = new dbRamotEntities())
{
Events e = db.Events.Find(id);
e.Categories.Remove(Mapper.CastCategory(category));
db.SaveChanges();
}
}
/// <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();
}
}
public static void RemoveGroup(int id)
{
using (dbRamotEntities db = new dbRamotEntities())
{
Groups g = db.Groups.Find(id);
db.Groups.Remove(g);
db.SaveChanges();
}
}
public static void UpdateGroup(Group group)
{
Groups g = Mapper.CastGroup(group);
using (dbRamotEntities db = new dbRamotEntities())
{
db.Entry <Groups>(db.Set <Groups>().Find(g.Id)).CurrentValues.SetValues(g);
db.SaveChanges();
}
}
public static void RemoveUser(Common.User user)
{
User u = Mapper.CastUser(user);
using (dbRamotEntities db = new dbRamotEntities())
{
db.User.Remove(u);
db.SaveChanges();
}
}
public static void AddGroup(Group group)
{
Groups g = Mapper.CastGroup(group);
using (dbRamotEntities db = new dbRamotEntities())
{ //if (db.Groups.Contains(g))
db.Groups.Add(g);
db.SaveChanges();
}
}
public static void UpdateVolunteerAndEvent(Common.VolunteerAndEvent vae)
{
VolunteerAndEvent g = Mapper.CastVolunteerAndEvent(vae);
using (dbRamotEntities db = new dbRamotEntities())
{
db.Entry <VolunteerAndEvent>(db.Set <VolunteerAndEvent>().Find(g.Id)).CurrentValues.SetValues(g);
db.SaveChanges();
}
}
public static void UpdateUser(Common.User user)
{
User u = Mapper.CastUser(user);
using (dbRamotEntities db = new dbRamotEntities())
{
db.Entry <User>(db.Set <User>().Find(u.Id)).CurrentValues.SetValues(u);
db.SaveChanges();
}
}
public static void AddCategory(Category category)
{
Categories c = Mapper.CastCategory(category);
using (dbRamotEntities db = new dbRamotEntities())
{
db.Categories.Add(c);
db.SaveChanges();
}
}
public static void AddCategoryToOrganization(int id, Category category)
{
using (dbRamotEntities db = new dbRamotEntities())
{
Organization e = db.Organization.Find(id);
var c = db.Categories.FirstOrDefault(ca => ca.Id == e.Id);
e.Categories.Add(c);
db.SaveChanges();
}
}
public static void UpdateCategory(Category category)
{
Categories c = Mapper.CastCategory(category);
using (dbRamotEntities db = new dbRamotEntities())
{
db.Entry <Categories>(db.Set <Categories>().Find(c.Id)).CurrentValues.SetValues(c);
db.SaveChanges();
}
}
public static void RemoveOrganization(Common.Organization organization)
{
Organization e = Mapper.CastOrganization(organization);
using (dbRamotEntities db = new dbRamotEntities())
{
db.Organization.Remove(e);
db.SaveChanges();
}
}
public static void UpdateOrganizationAndFamily(Common.OrganizationAndFamily oaf)
{
OrganizationAndFamily g = Mapper.CastOrganizationAndFamily(oaf);
using (dbRamotEntities db = new dbRamotEntities())
{
db.Entry <OrganizationAndFamily>(db.Set <OrganizationAndFamily>().Find(g.Id)).CurrentValues.SetValues(g);
db.SaveChanges();
}
}
public static IEnumerable <Group> GetGroups()
{
using (dbRamotEntities db = new dbRamotEntities())
{
List <Group> groups = new List <Group>();
foreach (var g in db.Groups.ToList())
{
groups.Add(Mapper.CastGroupToComon(g));
}
return(groups);
}
}
