// 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 async Task <bool> Guardar(ClasseModels Models)
{
if (Models.ID == 0)
{
await this.biblioteContext.ClasseModels.AddAsync(Models);
}
else
{
this.biblioteContext.ClasseModels.Update(Models);
}
return(await Salvar());
}
private List <ClasseModels> getListClasses(IQueryable <Classrooms> classrooms)
{
List <ClasseModels> list = new List <ClasseModels>();
foreach (var u in classrooms)
{
ClasseModels a = new ClasseModels
{
id = u.Id,
title = u.Title,
userId = u.User_Id,
yearId = u.Year_Id,
};
list.Add(a);
}
return(list);
}
private List <ClasseModels> getListClasses(IQueryable <Classrooms> classes)
{
List <ClasseModels> classrooms = new List <ClasseModels>();
foreach (var c in classes)
{
ClasseModels classe = new ClasseModels
{
id = c.Id,
etablissementId = c.Establishment_Id,
title = c.Title,
userId = c.User_Id,
yearId = c.Year_Id
};
classrooms.Add(classe);
}
return(classrooms);
}
private List <ClasseModels> getListClasses(IQueryable <Classrooms> classrooms)
{
List <ClasseModels> ac = new List <ClasseModels>();
foreach (var aca in classrooms)
{
ClasseModels c = new ClasseModels
{
id = aca.Id,
title = aca.Title,
userId = aca.User_Id,
yearId = aca.Year_Id,
etablissementId = aca.Establishment_Id,
};
ac.Add(c);
}
return(ac);
}
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"));
}
}
public frmClasseAdd(ClasseModels classeModels, IClasseModels classeModelsRepository)
{
InitializeComponent();
this.classeModels = classeModelsRepository;
this.Load += delegate { LoaderFormsXML(); };
btnClose.Click += delegate { SaveFormsXML(); };
IDTextEdit.EditValueChanged += IDTextEdit_TextChanged;
windowsUIButtonPanel1.ButtonClick += WindowsUIButtonPanel1_ButtonClick;;
if (classeModels != null)
{
IDTextEdit.EditValue = classeModels.ID;
UserNameTextEdit.EditValue = classeModels.Referencia;
txtIdade1.EditValue = classeModels.IdadeInicia;
txtIdade2.Value = classeModels.IdadeFinaliza;
UserNameTextEdit.Focus();
}
}
private async void GuardarDados()
{
if (Validacao())
{
var codigo = string.IsNullOrWhiteSpace(IDTextEdit.Text) || IDTextEdit.Text.Equals("0");
var models = new ClasseModels
{
ID = codigo == true ? 0 : (int)IDTextEdit.EditValue,
Referencia = (string)UserNameTextEdit.EditValue,
IdadeInicia = (decimal)txtIdade1.EditValue,
IdadeFinaliza = (decimal)txtIdade2.EditValue,
};
var result = await classeModels.Guardar(models);
if (result)
{
XtraMessageBox.Show("Inserido com Exito", "Inserção", MessageBoxButtons.OK, MessageBoxIcon.Information);
NovoDado();
}
}
}
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 async Task <bool> Update(ClasseModels Models)
{
this.biblioteContext.ClasseModels.Update(Models);
return(await Salvar());
}
public async Task <bool> Delete(ClasseModels Models)
{
biblioteContext.ClasseModels.Remove(Models);
return(await Salvar());
}
