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(); } }
public static void RemoveVolunteerAndEvent(int id) { using (dbRamotEntities db = new dbRamotEntities()) { db.VolunteerAndEvent.Remove(db.VolunteerAndEvent.Find(id)); db.SaveChanges(); } }
public static void RemoveOrganizationAndFamily(int id) { using (dbRamotEntities db = new dbRamotEntities()) { db.OrganizationAndFamily.Remove(db.OrganizationAndFamily.Find(id)); 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 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(); } }
public static void RemoveGroup(int id) { using (dbRamotEntities db = new dbRamotEntities()) { Groups g = db.Groups.Find(id); db.Groups.Remove(g); 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 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 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 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 AddCategory(Category category) { Categories c = Mapper.CastCategory(category); using (dbRamotEntities db = new dbRamotEntities()) { db.Categories.Add(c); 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 RemoveUser(Common.User user) { User u = Mapper.CastUser(user); using (dbRamotEntities db = new dbRamotEntities()) { db.User.Remove(u); 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 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 RemoveOrganization(Common.Organization organization) { Organization e = Mapper.CastOrganization(organization); using (dbRamotEntities db = new dbRamotEntities()) { db.Organization.Remove(e); 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(); } }
/// <summary> /// Add category to volunter /// Helper func- does not work........ /// </summary> /// <param name="id">Id of volunteer</param> /// <param name="category">Category object</param> public static void AddCategoryToVolunteer(int id, Category[] category) { using (dbRamotEntities db = new dbRamotEntities()) { Volunteers v = db.Volunteers.Find(id); foreach (var item in category) { var c = db.Categories.FirstOrDefault(ca => ca.Id == item.Id); v.Categories.Add(c); 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 void RemoveOrganization(int id) { using (dbRamotEntities db = new dbRamotEntities()) { var query = from row in db.OrganizationAndFamily.AsEnumerable() where row.IdOrganization == id select row; if (query.ToList().Count > 0) { db.OrganizationAndFamily.FirstOrDefault().Families = null; // db.VolunteerAndFamily.Remove(db.VolunteerAndFamily.Find(query.FirstOrDefault().Id)); } db.Organization.Find(id).Categories.Clear(); db.Organization.Remove(db.Organization.Find(id)); db.SaveChanges(); } }
/// <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(); } }
/// <summary> /// Update volunteer with new information, including categories. /// </summary> /// <param name="volunteer">Volunteer object</param> /// <param name="categories">List of categories</param> public static void UpdateVolunteer(Volunteer volunteer, Category[] categories) { Volunteers v = Mapper.CastVolunteer(volunteer); using (dbRamotEntities db = new dbRamotEntities()) { db.Volunteers.Find(volunteer.Id).Categories.Clear(); foreach (var item in categories) { var c = db.Categories.FirstOrDefault(ca => ca.Id == item.Id); db.Volunteers.Find(volunteer.Id).Categories.Add(c); } db.Entry <Volunteers>(db.Set <Volunteers>().Find(v.Id)).CurrentValues.SetValues(v); db.SaveChanges(); } }
public static int AddEvent(Event eventt, Category[] categories) { int x = 0; Events v = Mapper.CastEvent(eventt); using (dbRamotEntities db = new dbRamotEntities()) { foreach (var item in categories) { var c = db.Categories.FirstOrDefault(ca => ca.Id == item.Id); v.Categories.Add(c); } db.Events.Add(v); db.SaveChanges(); x = db.Events.Local[0].Id; } return(x); }
/// <summary> /// Add volunteer to db, and categories for that volunteer. /// </summary> /// <param name="volunteer">Volunteer object</param> /// <param name="category">Category</param> /// <returns>Id of added volunteer</returns> public static int AddVolunteer(Volunteer volunteer, Category[] category) { int x = 0; Volunteers v = Mapper.CastVolunteer(volunteer); using (dbRamotEntities db = new dbRamotEntities()) { foreach (var item in category) { var c = db.Categories.FirstOrDefault(ca => ca.Id == item.Id); v.Categories.Add(c); } db.Volunteers.Add(v); db.SaveChanges(); x = db.Volunteers.Local[0].Id; } return(x); }
public static int AddOrganization(Common.Organization organization, Category[] categories) { int x = 0; Organization e = Mapper.CastOrganization(organization); using (dbRamotEntities db = new dbRamotEntities()) { foreach (var item in categories) { var c = db.Categories.FirstOrDefault(ca => ca.Id == item.Id); e.Categories.Add(c); } db.Organization.Add(e); db.SaveChanges(); x = db.Organization.Local[0].Id; } return(x); }
public static int UpdateEvent(Event eventt, Category[] categories) { int x = 0; Events e = Mapper.CastEvent(eventt); using (dbRamotEntities db = new dbRamotEntities()) { db.Events.Find(eventt.Id).Categories.Clear(); foreach (var item in categories) { var c = db.Categories.FirstOrDefault(ca => ca.Id == item.Id); db.Events.Find(eventt.Id).Categories.Add(c); } db.Entry <Events>(db.Set <Events>().Find(e.Id)).CurrentValues.SetValues(e); db.SaveChanges(); x = db.Events.Local[0].Id; } return(x); }
public static int UpdateOrganization(Common.Organization organization, Category[] categories) { int x = 0; Organization e = Mapper.CastOrganization(organization); using (dbRamotEntities db = new dbRamotEntities()) { db.Organization.Find(organization.Id).Categories.Clear(); foreach (var item in categories) { var c = db.Categories.FirstOrDefault(ca => ca.Id == item.Id); db.Organization.Find(organization.Id).Categories.Add(c); } db.Entry <Organization>(db.Set <Organization>().Find(e.Id)).CurrentValues.SetValues(e); db.SaveChanges(); x = db.Organization.Local[0].Id; } return(x); }
public static void AddVolunteerAndFamily(Common.VolunteerAndFamily vaf) { VolunteerAndFamily g = Mapper.CastVolunteerAndFamily(vaf); using (dbRamotEntities db = new dbRamotEntities()) { //if (db.VolunteerAndFamily.Contains(g)) Categories c = null; if (vaf.Category != null) { c = db.Categories.FirstOrDefault(ca => ca.Id == vaf.Category.Id); } var v = db.Volunteers.FirstOrDefault(ca => ca.Id == vaf.Volunteer.Id); var f = db.Families.FirstOrDefault(ca => ca.Id == vaf.Family.Id); g.Categories = c; g.Volunteers = v; g.Families = f; db.VolunteerAndFamily.Add(g); db.SaveChanges(); } }
public static void AddVolunteerAndEvent(Common.VolunteerAndEvent vae) { VolunteerAndEvent g = Mapper.CastVolunteerAndEvent(vae); using (dbRamotEntities db = new dbRamotEntities()) { Categories c = null; if (vae.Category != null) { c = db.Categories.FirstOrDefault(ca => ca.Id == vae.Category.Id); } var v = db.Volunteers.FirstOrDefault(ca => ca.Id == vae.Volunteer.Id); var e = db.Events.FirstOrDefault(ca => ca.Id == vae.Event.Id); g.Categories = c; g.Volunteers = v; g.Events = e; db.VolunteerAndEvent.Add(g); db.SaveChanges(); } }