public static void InsertSubjectCategory(SubjectCategory subjectCategory)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
db.SubjectCategories.Add(subjectCategory);
db.SaveChanges();
}
}
public static void InsertPostType(PostType postType)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
db.PostTypes.Add(postType);
db.SaveChanges();
}
}
public static void InsertLogType(LogType logType)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
db.LogTypes.Add(logType);
db.SaveChanges();
}
}
public static void InsertSubject(Subject subject)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
db.Subjects.Add(subject);
db.SaveChanges();
}
}
public static void InsertFeedbackType(FeedbackType feedbackType)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
db.FeedbackTypes.Add(feedbackType);
db.SaveChanges();
}
}
public static void InsertJobType(JobType jobType)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
db.JobTypes.Add(jobType);
db.SaveChanges();
}
}
public static void InsertInstitute(Institute institute)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
db.Institutes.Add(institute);
db.SaveChanges();
}
}
public static void InsertDegree(Degree degree)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
db.Degrees.Add(degree);
db.SaveChanges();
}
}
public static void InsertTestLevel(TestLevel testLevel)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
db.TestLevels.Add(testLevel);
db.SaveChanges();
}
}
public static void InsertArea(Area area)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
db.Areas.Add(area);
db.SaveChanges();
}
}
public static void InsertTestType(TestType testType)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
db.TestTypes.Add(testType);
db.SaveChanges();
}
}
public static void UpdateTestType(TestType testType)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
var tempTesttype = db.TestTypes.Single(x => x.Id == testType.Id);
tempTesttype.TestTypeName = testType.TestTypeName;
db.SaveChanges();
}
}
public static void UpdateDegreeType(DegreeType degreeType)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
var tempDegreetype = db.DegreeTypes.Single(x => x.Id == degreeType.Id);
tempDegreetype.DegreeTypeName = degreeType.DegreeTypeName;
db.SaveChanges();
}
}
public static void DeleteSubject(int subjectId)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
var tempSubject = db.Subjects.Single(x => x.Id == subjectId);
db.Subjects.Remove(tempSubject);
db.SaveChanges();
}
}
public static void UpdateFeedbackType(FeedbackType feedbackType)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
var tempFeedbacktype = db.FeedbackTypes.Single(x => x.Id == feedbackType.Id);
tempFeedbacktype.FeedbackTypeName = feedbackType.FeedbackTypeName;
db.SaveChanges();
}
}
public static void DeleteLog(int logId)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
var tempLog = db.Logs.Single(x => x.Id == logId);
db.Logs.Remove(tempLog);
db.SaveChanges();
}
}
public static void DeletePostType(int postTypeId)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
var tempPostType = db.PostTypes.Single(x => x.Id == postTypeId);
db.PostTypes.Remove(tempPostType);
db.SaveChanges();
}
}
public static void DeleteInstitute(int instituteId)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
var tempInstitute = db.Institutes.Single(x => x.Id == instituteId);
db.Institutes.Remove(tempInstitute);
db.SaveChanges();
}
}
public static void DeleteFeedbackType(int feedbackTypeId)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
var tempFeedbackType = db.FeedbackTypes.Single(x => x.Id == feedbackTypeId);
db.FeedbackTypes.Remove(tempFeedbackType);
db.SaveChanges();
}
}
public static void DeleteTestLevel(int testLevelId)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
var tempTestLevel = db.TestLevels.Single(x => x.Id == testLevelId);
db.TestLevels.Remove(tempTestLevel);
db.SaveChanges();
}
}
public static void DeleteDegree(int degreeId)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
var tempDegree = db.Degrees.Single(x => x.Id == degreeId);
db.Degrees.Remove(tempDegree);
db.SaveChanges();
}
}
public static void UpdateSubjectCategory(SubjectCategory subjectCategory)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
var tempSubjectCategory = db.SubjectCategories.Single(x => x.Id == subjectCategory.Id);
tempSubjectCategory.SubjectCategoryName = subjectCategory.SubjectCategoryName;
db.SaveChanges();
}
}
public static void DeleteArea(int areaId)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
var tempAreas = db.Areas.Single(x => x.Id == areaId);
db.Areas.Remove(tempAreas);
db.SaveChanges();
}
}
public static void UpdateLogType(LogType logType)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
var tempLogtype = db.LogTypes.Single(x => x.Id == logType.Id);
tempLogtype.LogTypeName = logType.LogTypeName;
db.SaveChanges();
}
}
public static void UpdateJobType(JobType jobType)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
var tempJobType = db.JobTypes.Single(x => x.Id == jobType.Id);
tempJobType.JobTypeName = jobType.JobTypeName;
db.SaveChanges();
}
}
public static void UpdateSubject(Subject subject)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
var tempSubject = db.Subjects.Single(x => x.Id == subject.Id);
tempSubject.SubjectName = subject.SubjectName;
tempSubject.SubjectCategoryId = subject.SubjectCategoryId;
db.SaveChanges();
}
}
public static void UpdatePostType(PostType postType)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
var tempPostType = db.PostTypes.Single(x => x.Id == postType.Id);
tempPostType.PostTypeName = postType.PostTypeName;
db.SaveChanges();
}
}
public static void UpdateLog(Log log)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
var tempLog = db.Logs.Single(x => x.Id == log.Id);
tempLog.LogTypeId = log.LogTypeId;
tempLog.LogDetail = log.LogDetail;
db.SaveChanges();
}
}
public static void UpdateArea(Area area)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
var tempArea = db.Areas.Single(x => x.Id == area.Id);
tempArea.AreaName = area.AreaName;
tempArea.CityId = area.CityId;
db.SaveChanges();
}
}
public static void UpdateInstitute(Institute institute)
{
using (FindEducatorsContext db = new FindEducatorsContext())
{
var tempInstitute = db.Institutes.Single(x => x.Id == institute.Id);
tempInstitute.InstituteName = institute.InstituteName;
tempInstitute.CityId = institute.CityId;
db.SaveChanges();
}
}