// GET: /GestionDesClasses/CreateClasse
public ActionResult CreateClasse(Guid?etablissement, Guid?user, Guid?year)
{
ClasseModels model;
using (ClasseRepository repository = new ClasseRepository())
{
IQueryable <Users> users = repository.GetUsers();
IQueryable <Years> years = repository.GetYears();
IQueryable <Establishments> etablissements = repository.GetEtablissements();
model = new ClasseModels
{
mode = -1,
users = getListUsers(users),
years = getListYears(years),
etablissements = getListEtablissements(etablissements),
};
if (etablissement != null)
{
model.etablissementId = (Guid)etablissement;
}
if (user != null)
{
model.userId = (Guid)user;
}
if (year != null)
{
model.yearId = (Guid)year;
}
}
return(View(model));
}
//
// GET: /GestionDesClasses/EditClasse/5
public ActionResult EditClasse(Guid id)
{
ClasseModels model;
using (ClasseRepository repository = new ClasseRepository())
{
IQueryable <Years> years = repository.GetYears();
IQueryable <Users> users = repository.GetUsers();
IQueryable <Establishments> etablissements = repository.GetEtablissements();
Classrooms c = repository.GetClasseById(id);
if (c == null)
{
return(HttpNotFound());
}
model = new ClasseModels
{
mode = 0,
id = c.Id,
title = c.Title,
userId = c.User_Id,
yearId = c.Year_Id,
etablissementId = c.Establishment_Id,
users = getListUsers(users),
years = getListYears(years),
etablissements = getListEtablissements(etablissements)
};
}
return(View("CreateClasse", model));
}
// GET: /GestionDesClasses/ReadClasse/1122
public ActionResult ReadClasse(Guid id)
{
ClasseModels model;
using (ClasseRepository repository = new ClasseRepository())
{
Classrooms c = repository.GetClasseById(id);
//IQueryable<Users> l = repository.GetUserById(id);
IQueryable <Pupils> l = repository.GetPupilsById(id);
IQueryable <Evaluations> e = repository.GetEvaluations(c.Id);
if (c == null)
{
return(HttpNotFound());
}
model = new ClasseModels
{
id = c.Id,
title = c.Title,
userId = c.User_Id,
yearId = c.Year_Id,
etablissementId = c.Establishment_Id,
userName = c.Users.UserName,
yearName = c.Years.Year,
etablissementName = c.Establishments.Name,
pupils = getListEleves(l),
evaluations = getListEvaluations(e)
};
}
return(View(model));
}
public ActionResult DeleteEtablissement(ClasseModels model)
{
using (ClasseRepository repository = new ClasseRepository())
{
repository.DeleteById(model.id);
repository.Save();
}
return(View("Index"));
}
public ActionResult SearchClasses(String query)
{
IList <ClasseModels> models = new List <ClasseModels>();
using (ClasseRepository repository = new ClasseRepository())
{
models = repository.GetClassesByQuery(query).Select(x => new ClasseModels
{
id = x.Id,
title = x.Title,
userId = x.User_Id,
yearId = x.Year_Id,
etablissementId = x.Establishment_Id,
}).ToList();
}
return(PartialView("_classesList", models));
}
public ActionResult EditClasse(ClasseModels model)
{
using (ClasseRepository repository = new ClasseRepository())
{
Classrooms a = repository.GetClasseById(model.id);
a.Title = model.title;
a.User_Id = model.userId;
a.Year_Id = model.yearId;
a.Establishment_Id = model.etablissementId;
if (ModelState.IsValid)
{
repository.Save();
}
return(RedirectToAction("ReadClasses"));
}
}
// GET: /GestionDesClasses/Classes
public ActionResult ReadClasses()
{
IList <ClasseModels> models = new List <ClasseModels>();
using (ClasseRepository repository = new ClasseRepository())
{
IQueryable <Classrooms> a = repository.All();
models = repository.All().Select(x => new ClasseModels
{
id = x.Id,
title = x.Title,
userId = x.User_Id,
yearId = x.Year_Id,
etablissementId = x.Establishment_Id
}).ToList();
}
return(View(models));
}
public static CharactersConfigurationModel ToModel(this CharactersConfigurationEntity CCE)
{
if (CCE != null)
{
ClasseRepository repoCl = new ClasseRepository();
CharactersConfigurationModel CCM = new CharactersConfigurationModel();
CCM.Id = CCE.Id;
CCM.Classe1 = repoCl.GetOne(CCE.ClasseId1).MapTo <ClasseModel>();
CCM.Classe2 = repoCl.GetOne(CCE.ClasseId2).MapTo <ClasseModel>();
CCM.Classe3 = repoCl.GetOne(CCE.ClasseId3).MapTo <ClasseModel>();
CCM.Classe4 = repoCl.GetOne(CCE.ClasseId4).MapTo <ClasseModel>();
CCM.Active = CCE.Active;
return(CCM);
}
else
{
return(null);
}
}
public static SkillModel ToModel(this SkillEntity SE)
{
if (SE != null)
{
ClasseRepository repoCl = new ClasseRepository();
SkillModel SM = new SkillModel();
SM.Id = SE.Id;
SM.NameEN = SE.NameEN;
SM.NameFR = SE.NameFR;
SM.DescriptionEN = SE.DescriptionEN;
SM.DescriptionFR = SE.DescriptionFR;
SM.Location = SE.Location;
SM.Cost = SE.Cost;
SM.ImagePath = SE.ImagePath;
SM.Classe = repoCl.GetOne(SE.ClasseId).MapTo <ClasseModel>();
SM.Active = SE.Active;
return(SM);
}
else
{
return(null);
}
}
public ActionResult CreateClasse(ClasseModels model)
{
if (ModelState.IsValid)
{
using (ClasseRepository repository = new ClasseRepository())
{
Classrooms a = new Classrooms
{
Id = Guid.NewGuid(),
Title = model.title,
User_Id = model.userId,
Year_Id = model.yearId,
Establishment_Id = model.etablissementId,
};
repository.Add(a);
repository.Save();
}
return(RedirectToAction("ReadClasses"));
}
return(View(model));
}
// GET: /GestionDesClasses/DeleteClasse/5
public ActionResult DeleteClasse(Guid id)
{
ClasseModels model;
using (ClasseRepository repository = new ClasseRepository())
{
Classrooms c = repository.GetClasseById(id);
if (c == null)
{
return(HttpNotFound());
}
model = new ClasseModels
{
id = c.Id,
title = c.Title,
userId = c.User_Id,
yearId = c.Year_Id,
etablissementId = c.Establishment_Id,
};
}
return(View("DeleteClasse", model));
}
public ClasseController(DataContext context, ClasseRepository classeRepository)
{
_classeRepository = classeRepository;
}
private void ClasseLista_Load(object sender, EventArgs e)
{
ClasseRepository rep = new ClasseRepository(ConexaoService.GetConnectionString());
dataGridView.DataSource = rep.Lista();
}
