public void ApagarDisciplinaBanco(int id)
{
using (DisciplinaModel disciplinaModel = new DisciplinaModel())
{
disciplinaModel.Delete(id);
}
}
public void UpdateDisciplinaBanco(Disciplina disciplina)
{
using (DisciplinaModel disciplinaModel = new DisciplinaModel())
{
disciplinaModel.Update(disciplina);
}
}
public ActionResult DeleteDisciplinaUpdate(int id)
{
var listaDisciplinas = (List <Disciplina>)Session["ListaDisciplinas"];
var tamanhoLista = listaDisciplinas.Count();
int posicaoLista = id;
int idDisciplina = 0;
for (int i = 0; i < tamanhoLista; i++)
{
var objDisciplina = listaDisciplinas[i];
if (i == posicaoLista)
{
idDisciplina = objDisciplina.DisciplinaId;
break;
}
}
using (DisciplinaModel disciplinaModel = new DisciplinaModel())
{
if (disciplinaModel.VerificaAtribuicao(idDisciplina))
{
ctrlMsg = true;
msg = "You can not remove this subject because it is assigned";
return(RedirectToAction("UpdateDisciplinas"));
}
}
listaDisciplinas.RemoveAt(posicaoLista);
return(RedirectToAction("UpdateDisciplinas"));
}
public List <Disciplina> GetListaDisciplinasBanco(int CursoId)
{
using (DisciplinaModel disciplinaModel = new DisciplinaModel())
{
return(disciplinaModel.ReadDisciplinas(CursoId));
}
}
public DisciplinaModel FindById(int id)
{
var discFound = new DisciplinaModel();
var query = "SELECT * FROM " + tableName + " WHERE IdMateria = " + id;
ContactServer(null, query, discFound, null, 2);
return(discFound.IdMateria == -1 ? null : discFound);
}
public DisciplinaModel AddDisciplina(DisciplinaModel discToAdd)
{
var query = "INSERT INTO " + tableName + " (NomeMateria) " +
"VALUES (@Nome)";
ContactServer(null, query, discToAdd, null, 3);
return(FindById(lastId));
}
public ActionResult Create(Disciplina entity)
{
// toda vez q for acessar o banco
using (DisciplinaModel model = new DisciplinaModel())
{
model.Create(entity);
}
// retornar para view
return(RedirectToAction("Create"));
}
public ActionResult <DisciplinaModel> AddDisciplina(DisciplinaModel discToAdd)
{
var user = _services.AddDisciplina(discToAdd);
if (user == null)
{
return(NotFound());
}
return(user);
}
public ActionResult SalvarDisciplina(DisciplinaModel model)
{
var aplicativo = new DisciplinaAplicativo();
Disciplina disciplina = new Disciplina()
{
Id = model.Id.HasValue ? model.Id.Value : 0,
Nome = model.Nome
};
aplicativo.Salvar(disciplina);
return(RedirectToAction("Index"));
}
public ActionResult Index()
{
// Nao deixar o usuario acessar Disciplinas
// If trocado por [Autorizacao]
//if (Session["usuario"] is Aluno)
// return RedirectToAction("Index", "Home");
using (DisciplinaModel model = new DisciplinaModel())
{
// Recuperando a sessao
Professor p = (Professor)Session["usuario"];
return(View(model.Read(p.Id)));
}
}
public ActionResult Delete(int id)
{
using (DisciplinaModel disciplinaModel = new DisciplinaModel())
{
if (!disciplinaModel.DeleteAll(id))
{
ctrlMsg = true;
msg = "Could not remove this program because it has some assigned subjects";
return(RedirectToAction("Index"));
}
}
using (CursoModel cursoModel = new CursoModel())
{
cursoModel.Delete(id);
return(RedirectToAction("Index"));
}
}
public ActionResult <DisciplinaModel> AlterDisciplina(int id, DisciplinaModel discEditions)
{
if (discEditions == null || discEditions.IdMateria != id)
{
return(BadRequest());
}
var discToEdit = _services.FindById(id);
if (discToEdit == null)
{
return(NotFound());
}
_services.Update(discToEdit, discEditions);
return(_services.FindById(id));
}
public IActionResult SalvarDisciplina([FromForm] DisciplinaModel disciplinaModel)
{
try
{
var disciplinaEntity = _mapper.Map <DisciplinaModel, Disciplina>(disciplinaModel);
disciplinaEntity = _disciplinaService.Insert <DisciplinaValidator>(disciplinaEntity);
}
catch (ArgumentException argEx)
{
ViewBag.Erro = argEx.Message;
return(View("AdicionarDisciplina", disciplinaModel));
}
catch (Exception ex)
{
ViewBag.Erro = ex.Message;
}
return(RedirectToAction("Index"));
}
public ActionResult _AssignmentCurso(int CursoId, int ProfessorId) //passível de alteração (CursoId presente na atribuição)
{
//Carregar a atribuicao do professor também
List <Atribuicao> listaAtribuicao;
List <Atribuicao> listaDisabled;
List <Disciplina> listaDisciplina;
using (AssignmentModel model = new AssignmentModel())
{
listaAtribuicao = model.Read(ProfessorId);
}
using (AssignmentModel model = new AssignmentModel())
{
listaDisabled = model.ReadDisabled(ProfessorId);
}
using (DisciplinaModel model = new DisciplinaModel())
{
listaDisciplina = model.Read(CursoId);
}
ViewBag.ListAtribuicao = listaAtribuicao;
ViewBag.ListDisabled = listaDisabled;
return(PartialView(listaDisciplina));
}
public IActionResult AdicionarDisciplina(DisciplinaModel disciplinaModel = null)
{
return(View(disciplinaModel == null ? new DisciplinaModel() : disciplinaModel));
}
public int Update(DisciplinaModel discToEdit, DisciplinaModel originalDisc)
{
throw new NotImplementedException();
}
public void ContactServer(List <DisciplinaModel> list, string _query, DisciplinaModel model, DisciplinaModel originalModel, int search)
{
using (var dbConnection = new MySqlConnection(_connectionString))
{
using (var cmd = dbConnection.CreateCommand())
{
cmd.CommandText = _query;
cmd.CommandType = System.Data.CommandType.Text;
cmd.Connection = dbConnection;
dbConnection.Open();
if (search == 3)//ADD
{
cmd.Parameters.AddWithValue("@Nome", model.NomeMateria);
cmd.ExecuteNonQuery();
lastId = Convert.ToInt32(cmd.LastInsertedId);
}
else if (search == 4)//DELETE
{
rows = cmd.ExecuteNonQuery();
}
else if (search == 5)//UPDATE
{
if (!model.NomeMateria.Equals(originalModel.NomeMateria))
{
_query += "NomeMateria = @Nome WHERE IdMateria = " + model.IdMateria;
cmd.Parameters.AddWithValue("@Nome", model.NomeMateria);
cmd.CommandText = _query;
rows = cmd.ExecuteNonQuery();
_query = "UPDATE " + tableName + " SET ";
}
}
else
{
using (var reader = cmd.ExecuteReader())
{
if (search == 1)//LIST ALL
{
while (reader.Read())
{
list.Add(new DisciplinaModel
{
IdMateria = reader.GetInt32(reader.GetOrdinal("IdMateria")),
NomeMateria = reader.GetString(reader.GetOrdinal("NomeMateria"))
});
}
}
else if (search == 2)// LIST ONE
{
if (reader.Read())
{
model.IdMateria = reader.GetInt32(reader.GetOrdinal("IdMateria"));
model.NomeMateria = reader.GetString(reader.GetOrdinal("NomeMateria"));
}
else
{
model.IdMateria = -1;
}
}
}
}
}
dbConnection.Close();
}
}
