public void Delete(Guid id)
{
Models.DBObjects.Class dbClassModel = dbContext.Classes.FirstOrDefault(m => m.ClassId == id);
dbContext.Classes.DeleteOnSubmit(dbClassModel);
dbContext.SubmitChanges();
}
public void Update(ClassModel classModel)
{
Models.DBObjects.Class dbClassModel = dbContext.Classes.FirstOrDefault(m => m.ClassId == classModel.ClassId);
if (classModel != null)
{
dbClassModel.ClassId = classModel.ClassId;
dbClassModel.Name = classModel.Name;
dbContext.SubmitChanges();
}
}
public ClassModel GetClassById(Guid id)
{
ClassModel classModel = new ClassModel();
Models.DBObjects.Class dbClassModel = dbContext.Classes.FirstOrDefault(m => m.ClassId == id);
if (dbClassModel != null)
{
classModel.ClassId = dbClassModel.ClassId;
classModel.Name = dbClassModel.Name;
}
return(classModel);
}
public void Insert(ClassModel classModel)
{
classModel.ClassId = Guid.NewGuid();
if (classModel != null)
{
Models.DBObjects.Class dbClassModel = new Models.DBObjects.Class();
dbClassModel.ClassId = classModel.ClassId;
dbClassModel.Name = classModel.Name;
dbContext.Classes.InsertOnSubmit(dbClassModel);
dbContext.SubmitChanges();
}
}
