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