public void RemoveCompany(int id) { directory_dbEntities db = new directory_dbEntities(); Organization organization = new Organization(); organization = db.Organizations.Where(b => b.id == id).FirstOrDefault(); organization.id = id; db.Organizations.Remove(organization); db.SaveChanges(); }
public void AddCompany(string company, string last, string first, string phoneNum, string addr, string cityName, string prov, string ctry, string pc, string lat, string longit) { directory_dbEntities db = new directory_dbEntities(); Organization organization = new Organization(); //make sure organization is not already there. query database and compare two properties.... organization.companyName = company; organization.lastName = last; organization.firstName = first; organization.phone = phoneNum; organization.address = addr; organization.city = cityName; organization.province = prov; organization.country = ctry; organization.postalCode = pc; organization.latitude = lat; organization.longitude = longit; db.Organizations.Add(organization); db.SaveChanges(); }