public void DeleteJob(int JobId)
{
Job dbJob = dbContext.Jobs.FirstOrDefault(j => j.JobId == JobId);
if (dbJob != null)
{
dbContext.Jobs.Remove(dbJob);
dbContext.SaveChanges();
}
}
public Category DeleteCategory(int catId)
{
Category dbCat = dbContext.Categories.FirstOrDefault(c => c.CatId == catId);
if (dbCat != null)
{
foreach (Job j in dbCat.Jobs)
{
dbContext.Jobs.Remove(j);
}
dbContext.Categories.Remove(dbCat);
dbContext.SaveChanges();
}
return(dbCat);
}
public void SaveOrg(Organization org)
{
if (org.OrgId == 0)
{
dbContext.Organizations.Add(org);
}
else
{
Organization dbOrg = dbContext.Organizations.FirstOrDefault(o => o.OrgId == org.OrgId);
if (dbOrg != null)
{
dbOrg.OrgName = org.OrgName;
dbOrg.Address = org.Address;
dbOrg.Email = org.Email;
dbOrg.PostalCode = org.PostalCode;
dbOrg.PhoneNo = org.PhoneNo;
dbOrg.Website = org.Website;
dbOrg.Categories = org.Categories;
}
}
dbContext.SaveChanges();
}