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")); }