public tblPerfis CreateActivityProfile(tblPerfis ActivityProfile)
{
_db.tblPerfis.Add(ActivityProfile);
_db.SaveChanges();
return(ActivityProfile);
}
public tblPerfis CreateTrainingProfile(tblPerfis TrainingProfile)
{
_db.tblPerfis.Add(TrainingProfile);
_db.SaveChanges();
return(TrainingProfile);
}
public tblPerfis UpdateActivityProfile(tblPerfis ActivityProfile)
{
var trainingToUpdate = _db.tblPerfis.Find(ActivityProfile.IdPerfis);
trainingToUpdate.Nome = ActivityProfile.Nome;
_db.Entry(trainingToUpdate).State = EntityState.Modified;
_db.SaveChanges();
return(trainingToUpdate);
}
public bool checkIfTrainingProfileAlreadyExits(tblPerfis TrainingProfile)
{
var query = from f in _db.tblPerfis
where f.Nome == TrainingProfile.Nome
orderby f.Nome ascending
select f;
if (query.Count() == 1 && query.FirstOrDefault().IdPerfis != TrainingProfile.IdPerfis)
{
return(true);
}
return(false);
}
public tblPerfis UpdateTrainingProfile(tblPerfis TrainingProfile)
{
var trainingProfileToUpdate = _db.tblPerfis.Find(TrainingProfile.IdPerfis);
trainingProfileToUpdate.Nome = TrainingProfile.Nome;
trainingProfileToUpdate.tblPerfilAtividadeXPerfilAtItem = TrainingProfile.tblPerfilAtividadeXPerfilAtItem;
trainingProfileToUpdate.tblPerfilAtividadeXPerfilAtItem = TrainingProfile.tblPerfilAtividadeXPerfilAtItem;
trainingProfileToUpdate.tblPerfilTreinamentoxPerfilItem = TrainingProfile.tblPerfilTreinamentoxPerfilItem;
_db.Entry(trainingProfileToUpdate).State = EntityState.Modified;
_db.SaveChanges();
return(trainingProfileToUpdate);
}
public ActionResult Edit(tblPerfis activityProfile, int id)
{
activityProfile.IdPerfis = id;
var exits = _activityProfile.checkIfActivityProfileAlreadyExits(activityProfile);
if (ModelState.IsValid)
{
if (!exits)
{
_activityProfile.UpdateActivityProfile(activityProfile);
return(RedirectToAction("Index"));
}
}
if (exits)
{
ModelState.AddModelError("Nome", "Perfil de Atividade já existe");
}
return(View(activityProfile));
}
public ActionResult Edit(tblPerfis trainingProfile, int id)
{
trainingProfile.IdPerfis = id;
var exits = _trainingProfile.checkIfTrainingProfileAlreadyExits(trainingProfile);
if (ModelState.IsValid)
{
if (!exits)
{
_trainingProfile.UpdateTrainingProfile(trainingProfile);
return(RedirectToAction("Index"));
}
}
if (exits)
{
ModelState.AddModelError("Nome", "Perfil de Treinamento já existe");
}
return(View(trainingProfile));
}
public ActionResult Create(tblPerfis trainingProfile)
{
var username = "";
try
{
username = AuthorizationHelper.GetSystem().Usuario.ChaveAmericas;
}
catch
{
username = "";
}
var exits = _trainingProfile.checkIfTrainingProfileAlreadyExits(trainingProfile);
trainingProfile.UsuarioCriacao = username;
trainingProfile.DataCriacao = DateTime.Now;
trainingProfile.Tipo = "T";
if (ModelState.IsValid)
{
if (!exits)
{
_trainingProfile.CreateTrainingProfile(trainingProfile);
return(RedirectToAction("Index"));
}
}
if (exits)
{
ModelState.AddModelError("Nome", "Perfil de Treinamento já existe");
}
return(View("Create"));
}
