public async Task <DTOSabores> Atualizar(DTOSabores sabores)
{
if (!_sabores.Buscar(p => p.Id == sabores.Id).Result.Any())
{
Notificar("Sabor não localizado");
return(null);
}
var obj = new Sabores
{
Ativo = sabores.Ativo,
Descricao = sabores.Descricao,
TempoPreparo = sabores.TempoPreparo,
Valor = sabores.Valor,
Id = sabores.Id
};
var t = await _sabores.Atualizar(obj);
return(new DTOSabores
{
Ativo = t.Ativo,
Id = t.Id,
TempoPreparo = t.TempoPreparo,
Descricao = t.Descricao,
Valor = t.Valor,
});
}
public async Task <ActionResult <List <Sabores> > > Put(int id, [FromBody] Sabores model, [FromServices] ContextoAcai context)
{
if (model.Id != id)
{
return(NotFound());
}
if (!ModelState.IsValid)
{
return(NotFound(new { mesage = "categoria não encontrada" }));
}
try
{
context.Entry <Sabores>(model).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
await context.SaveChangesAsync();
return(Ok(model));
}
catch (DbUpdateConcurrencyException)
{
return(BadRequest(new { message = "O Registo Já Está Atualizado" }));
}
catch (Exception)
{
return(BadRequest(new { message = "Não Foi Possivel atualizar o Sabor" }));
}
}
public void TesteSabor()
{
Recordset rs = ADOContext.MyExecute("SELECT id_sabor_id,ativo,valor_adicional,nome,recheio,categoria_id FROM sabores ");
var myClass = new Sabores().BindClass(ref rs);
Assert.IsNotNull(myClass.id_sabor_id);
}
public ActionResult DeleteConfirmed(int id)
{
Sabores sabores = db.Sabores.Find(id);
db.Sabores.Remove(sabores);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id_Sabor,Sabor")] Sabores sabores)
{
if (ModelState.IsValid)
{
db.Entry(sabores).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sabores));
}
public ActionResult Create([Bind(Include = "Id_Sabor,Sabor")] Sabores sabores)
{
if (ModelState.IsValid)
{
db.Sabores.Add(sabores);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sabores));
}
public Sabores Record(Sabores objeto)
{
if (string.IsNullOrEmpty(objeto.Name))
{
throw new Exception("Nome não pode estar em branco");
}
return(dao.Record(objeto));
}
public JsonResult Post([FromBody] Sabores objeto)
{
try
{
return(Json(serviceSabores.Record(objeto)));
}
catch (Exception ex)
{
throw;
}
}
public JsonResult Post([FromBody] Sabores objeto)
{
try
{
return(Json(serviceSabores.Record(objeto)));
}
catch (Exception ex)
{
return(Json(new { Erro = ex.Message + " " + ex.InnerException }));
}
}
public JsonResult Delete([FromBody] Sabores objeto)
{
try
{
return(Json(serviceSabores.Delete(objeto.Id)));
}
catch (Exception ex)
{
return(Json(new { Erro = ex.Message + " " + ex.InnerException }));
}
}
public Sabores Record(Sabores objeto)
{
if (string.IsNullOrEmpty(objeto.Name))
{
throw new Exception("Nome não pode estar em branco");
}
if (Search(objeto.Name).Count > 0)
{
throw new Exception("Nome já cadastrado");
}
return(dao.Record(objeto));
}
public Sabores Record(Sabores objeto)
{
if (objeto.Id == 0)
{
db.SABORES.Add(objeto);
}
else
{
db.SABORES.Update(objeto);
}
db.SaveChanges();
return(objeto);
}
public string Delete(long id)
{
Sabores objeto = SearchId(id);
if (objeto != null)
{
return(dao.Delete(objeto));
}
else
{
return("Cliente não encontrado");
}
}
public List <Sabores> Delete(long id)
{
Sabores objeto = SearchId(id);
if (objeto != null)
{
dao.Delete(objeto);
return(ListaTodos());
}
else
{
throw new Exception("Erro ao deleter. Id já deletado");
}
}
// GET: Sabores/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Sabores sabores = db.Sabores.Find(id);
if (sabores == null)
{
return(HttpNotFound());
}
return(View(sabores));
}
public async Task <ActionResult <List <Sabores> > > Post([FromBody] Sabores model, [FromServices] ContextoAcai context)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
context.Sabores.Add(model);
await context.SaveChangesAsync();
return(Ok(model));
}
catch (Exception)
{
return(BadRequest(new { message = "Não deu certo na hora de instanciar o banco" }));
}
}
public async Task <DTOSabores> Adicionar(DTOSabores sabores)
{
if (_sabores.Buscar(p => p.Descricao == sabores.Descricao).Result.Any())
{
Notificar("Este sabor já foi cadastrado.");
return(null);
}
var obj = new Sabores
{
Ativo = sabores.Ativo,
Descricao = sabores.Descricao,
TempoPreparo = sabores.TempoPreparo,
Valor = sabores.Valor
};
var add = await _sabores.Adicionar(obj);
sabores.Id = add.Id;
return(sabores);
}
public bool GuardarSabor(Sabores sabor, string operacion)
{
SqlTransaction sqlTransaction = null;
SqlConnection cnn = new SqlConnection(this.ConnectionString);
try
{
cnn.Open();
sqlTransaction = cnn.BeginTransaction();
SqlDataAdapter sda = new SqlDataAdapter("dbo.Demo_Sabores", cnn);
sda.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure;
sda.SelectCommand.Transaction = sqlTransaction;
sda.SelectCommand.Parameters.AddWithValue("@Operacion", operacion);
sda.SelectCommand.Parameters.AddWithValue("@CodigoSabor", sabor.sabor);
sda.SelectCommand.Parameters.AddWithValue("@Nombre", sabor.nombre);
sda.SelectCommand.Parameters.AddWithValue("@Abrev", sabor.abreviatura);
sda.SelectCommand.Parameters.AddWithValue("@Status", sabor.status);
sda.SelectCommand.Parameters.Add(new SqlParameter("@Msg", SqlDbType.VarChar, 500, ParameterDirection.InputOutput, false, 0, 0, "", DataRowVersion.Current, ""));
DataTable dt = new DataTable();
sda.Fill(dt);
if (!string.IsNullOrEmpty(sda.SelectCommand.Parameters["@Msg"].Value.ToString()))
{
throw new Exception(sda.SelectCommand.Parameters["@Msg"].Value.ToString());
}
sqlTransaction.Commit();
return(true);
}
catch (Exception ex)
{
sqlTransaction.Rollback();
throw new Exception(ex.Message);
}
finally
{
if (cnn.State != ConnectionState.Closed)
{
cnn.Close();
}
}
}
public Sabores TraerSabor(string codigo)
{
Sabores sabores = new Sabores();
SqlDataAdapter sda = new SqlDataAdapter("dbo.Demo_Sabores", this.ConnectionString);
sda.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure;
sda.SelectCommand.Parameters.AddWithValue("@Operacion", "R");
sda.SelectCommand.Parameters.AddWithValue("@CodigoSabor", codigo);
DataTable dt = new DataTable();
sda.Fill(dt);
sabores = dt.AsEnumerable().Select(a =>
new Sabores
{
sabor = a["sabor"].ToString(),
nombre = a["nombre"].ToString(),
abreviatura = a["abreviatura"].ToString(),
status = a["status"].ToString()
}).SingleOrDefault();
return(sabores);
}
public string Delete(Sabores objeto)
{
db.SABORES.Remove(objeto);
db.SaveChanges();
return("SABORES excluído com sucesso");
}
