public List <AVALIACAO> SelecionarAvalicoes(int idAnimal)
{
string select = "select * from AVALIACAO where idAnimal = @idAnimal";
List <AVALIACAO> avaliacoes = new List <AVALIACAO>();
AVALIACAO avaliacao = new AVALIACAO();
try
{
Dictionary <string, object> values = new Dictionary <string, object>
{
{ "@idAnimal", idAnimal }
};
DataTable dt = SelectTableMySQL(select, values);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
avaliacao.IDUSUARIO = Convert.ToInt32(row["idUsuario"].ToString());
avaliacao.IDANIMAL = Convert.ToInt32(row["idAnimal"].ToString());
avaliacoes.Add(avaliacao);
avaliacao = new AVALIACAO();
}
}
return(avaliacoes);
}
catch (Exception)
{
throw;
}
}
public ActionResult DeleteConfirmed(int id)
{
AVALIACAO aVALIACAO = db.AVALIACAO.Find(id);
db.AVALIACAO.Remove(aVALIACAO);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "COD_AVALIACAO,NOME,DESCRICAO,DATA,PESO,COD_PROF,COD_MATERIA,COD_TURMA,PERIODO_LETIVO")] AVALIACAO aVALIACAO)
{
if (ModelState.IsValid)
{
db.Entry(aVALIACAO).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.COD_PROF = new SelectList(db.PROFMATERIATURMA, "COD_PROF", "COD_PROF", aVALIACAO.COD_PROF);
return(View(aVALIACAO));
}
// GET: AVALIACAO/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AVALIACAO aVALIACAO = db.AVALIACAO.Find(id);
if (aVALIACAO == null)
{
return(HttpNotFound());
}
return(View(aVALIACAO));
}
public void DesavaliarAnimal(AVALIACAO avaliacao)
{
if (avaliacao.IDANIMAL == 0)
{
throw new Exception("Informe o id do Animal");
}
if (avaliacao.IDUSUARIO == 0)
{
throw new Exception("Informe o id do Usuario");
}
avaliacao_db.RemoverAvaliacao(avaliacao);
}
// GET: AVALIACAO/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AVALIACAO aVALIACAO = db.AVALIACAO.Find(id);
if (aVALIACAO == null)
{
return(HttpNotFound());
}
ViewBag.COD_PROF = new SelectList(db.PROFMATERIATURMA, "COD_PROF", "COD_PROF", aVALIACAO.COD_PROF);
return(View(aVALIACAO));
}
public IActionResult DesavaliarAnimal(AVALIACAO avaliacao)
{
try
{
avaliacao_bll = new AVALIACAO_BLL();
avaliacao_bll.DesavaliarAnimal(avaliacao);
return(new ObjectResult(avaliacao));
}
catch (Exception)
{
throw;
}
}
public ActionResult Create(AvaliacaoViewModel obj, Guid idProfissional, int ID_ESPECIALIDADE, short vlNota)
{
try
{
Guid idCliente = Guid.Parse(User.Identity.GetUserId());
var objAv = new AVALIACAO(idProfissional, ID_ESPECIALIDADE, idCliente, vlNota, obj.COMENTARIO);
ctx.Avaliacao.Add(objAv);
ctx.SaveChanges();
return(RedirectToAction("Details", "Profissional", new { id = idProfissional, idEspecialidade = ID_ESPECIALIDADE }));
}
catch
{
return(View(obj));
}
}
public void RemoverAvaliacao(AVALIACAO avaliacao)
{
string delete = "delete from AVALIACAO where idUsuario = @idUsuario and idAnimal = @idAnimal;";
try
{
Dictionary <string, object> values = new Dictionary <string, object>
{
{ "@idUsuario", avaliacao.IDUSUARIO },
{ "@idAnimal", avaliacao.IDANIMAL }
};
QueryTableMySQL(delete, values);
}
catch
{
throw;
}
}
public void InserirAvaliacao(AVALIACAO avaliacao)
{
string insert = "insert into AVALIACAO(idUsuario, idAnimal) values(@idUsuario, @idAnimal);";
try
{
Dictionary <string, object> values = new Dictionary <string, object>
{
{ "@idUsuario", avaliacao.IDUSUARIO },
{ "@idAnimal", avaliacao.IDANIMAL }
};
QueryTableMySQL(insert, values);
}
catch
{
throw;
}
}
public HttpResponseMessage Post(AVALIACAO obj)
{
try
{
Validate(obj);
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
ctx.Avaliacao.Add(obj);
ctx.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.TratarMensagem()));
}
}
public HttpResponseMessage Put(Guid idUsuario, int idEspecialidade, Guid idCliente, AVALIACAO obj)
{
try
{
var item = ctx.Avaliacao.FirstOrDefault(w => w.ID_USUARIO == idUsuario & w.ID_ESPECIALIDADE == idEspecialidade & w.ID_CLIENTE == idCliente);
item.AtualizaDados(obj.NOTA, obj.COMENTARIO);
ctx.Entry(item).State = EntityState.Modified;
Validate(item);
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
ctx.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.TratarMensagem()));
}
}
