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