public TipoIngrediente FindById(int?id)
{
TipoIngrediente tpingrediente = null;
try
{
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["BD_Pizza"].ToString()))
{
con.Open();
var cmd = new SqlCommand("select*from TipoIngrediente where CTipoIngrediente='" + id + "'", con);
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
tpingrediente = new TipoIngrediente();
tpingrediente.CTipoIngrediente = Convert.ToInt32(dr["CTipoIngrediente"]);
tpingrediente.NTipoIngrediente = dr["NTipoIngrediente"].ToString();
}
}
con.Close();
}
}
catch (Exception)
{
throw;
}
return(tpingrediente);
}
public bool Update(Ingrediente t)
{
TipoIngrediente tpingrediente = tpingredienteRepository.FindById(t.CTipoIngrediente.CTipoIngrediente);
t.CTipoIngrediente = tpingrediente;
return(ingredienteRepository.Update(t));
}
public List <TipoIngrediente> FindAll()
{
var tipos = new List <TipoIngrediente>();
try
{
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["BD_Pizza"].ToString()))
{
con.Open();
var cmd = new SqlCommand("select*from TipoIngrediente", con);
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var tpingrediente = new TipoIngrediente();
tpingrediente.CTipoIngrediente = Convert.ToInt32(dr["CTipoIngrediente"]);
tpingrediente.NTipoIngrediente = dr["NTipoIngrediente"].ToString();
tipos.Add(tpingrediente);
}
}
con.Close();
}
}
catch (Exception)
{
throw;
}
return(tipos);
}
public bool Insert(Ingrediente t)
{
TipoIngrediente tpingrediente = tpingredienteRepository.FindById(t.CTipoIngrediente.CTipoIngrediente);
t.CTipoIngrediente = tpingrediente;
return(ingredienteRepository.Insert(t));
}
public Ingrediente FindById(int?id)
{
Ingrediente ingrediente = null;
try
{
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["BD_Pizza"].ToString()))
{
con.Open();
var cmd = new SqlCommand("select ig.CIngrediente, ig.NIngrediente, ig.QUnidadMedidaIngrediente, ig.NUnidadMedidaIngrediente, tp.NTipoIngrediente from Ingrediente ig, TipoIngrediente tp where ig.CTipoIngrediente=tp.CTipoIngrediente and ig.CIngrediente='" + id + "'", con);
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
ingrediente = new Ingrediente();
var tipo = new TipoIngrediente();
ingrediente.CIngrediente = Convert.ToInt32(dr["CIngrediente"]);
ingrediente.NIngrediente = dr["NIngrediente"].ToString();
ingrediente.QUnidadMedidaIngrediente = Convert.ToInt32(dr["QUnidadMedidaIngrediente"]);
ingrediente.NUnidadMedidaIngrediente = dr["NUnidadMedidaIngrediente"].ToString();
tipo.NTipoIngrediente = dr["NTipoIngrediente"].ToString();
ingrediente.CTipoIngrediente = tipo;
}
}
con.Close();
}
}
catch (Exception)
{
throw;
}
return(ingrediente);
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(HttpNotFound());
}
TipoIngrediente tpingrediente = tpingredienteService.FindById(id);
return(View(tpingrediente));
}
public ActionResult Create(TipoIngrediente tpingrediente)
{
bool rpta = tpingredienteService.Insert(tpingrediente);
if (rpta)
{
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult Edit(TipoIngrediente tpingrediente)
{
if (!ModelState.IsValid)
{
return(View());
}
bool rpta = tpingredienteService.Update(tpingrediente);
if (rpta)
{
return(RedirectToAction("Index"));
}
return(View());
}
public bool Insert(TipoIngrediente t)
{
bool rpta = false;
try
{
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["BD_Pizza"].ToString()))
{
con.Open();
var cmd = new SqlCommand("insert into TipoIngrediente values(@nombre)", con);
cmd.Parameters.AddWithValue("@nombre", t.NTipoIngrediente);
cmd.ExecuteNonQuery();
con.Close();
rpta = true;
}
}
catch (Exception)
{
throw;
}
return(rpta);
}
public bool Update(TipoIngrediente t)
{
return(tpingredienteRepository.Update(t));
}
public bool Insert(TipoIngrediente t)
{
return(tpingredienteRepository.Insert(t));
}
