public void Delete(Guid Id)
{
Models.DBObjects.Program programToDelete = dbContext.Programs.FirstOrDefault(m => m.ProgramId == Id);
dbContext.Programs.DeleteOnSubmit(programToDelete);
dbContext.SubmitChanges();
}
public void Update(ProgramModel programModelPassed)
{
Models.DBObjects.Program dbProgramModel = dbContext.Programs.FirstOrDefault(m => m.ProgramId == programModelPassed.ProgramId);
if (programModelPassed != null)
{
dbProgramModel.ProgramId = programModelPassed.ProgramId;
dbProgramModel.Name = programModelPassed.Name;
dbProgramModel.Hours_Mounth = programModelPassed.Hours_Mounth;
dbContext.SubmitChanges();
}
}
public ProgramModel GetProgramById(Guid Id)
{
Models.DBObjects.Program dbProgramModel = dbContext.Programs.FirstOrDefault(m => m.ProgramId == Id);
ProgramModel programModel = new ProgramModel();
if (dbProgramModel != null)
{
programModel.ProgramId = dbProgramModel.ProgramId;
programModel.Name = dbProgramModel.Name;
programModel.Hours_Mounth = dbProgramModel.Hours_Mounth;
}
return(programModel);
}
public void Insert(ProgramModel programModel)
{
programModel.ProgramId = Guid.NewGuid();
if (programModel != null)
{
Models.DBObjects.Program dbProgram = new Models.DBObjects.Program();
dbProgram.ProgramId = programModel.ProgramId;
dbProgram.Name = programModel.Name;
dbProgram.Hours_Mounth = programModel.Hours_Mounth;
dbContext.Programs.InsertOnSubmit(dbProgram);
dbContext.SubmitChanges();
}
}
