public int Registrar_Categoria(categoriaEntitis categoria)
{
try
{
using (dbventasEntity context = new dbventasEntity())
{
var connection = context.Database.Connection as SqlConnection;
using (connection)
{
connection.Open();
string Qry = "[dbo].[SP_SET_CATEGORIA]";
SqlCommand cmd = new SqlCommand(Qry, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@idCat", categoria.idcategoria));
cmd.Parameters.Add(new SqlParameter("@nom", categoria.nombre));
cmd.Parameters.Add(new SqlParameter("@Desc", categoria.descripcion));
cmd.ExecuteNonQuery();
return(1);
}
}
}
catch (Exception)
{
return(0);
}
}
public DataTable BuscarCategoria(categoriaEntitis categoria)
{
using (dbventasEntity context = new dbventasEntity())
{
var connection = context.Database.Connection as SqlConnection;
using (connection)
{
connection.Open();
string Qry = "[dbo].[SP_GET_CATEGORIA_BUSCAR]";
SqlCommand cmd = new SqlCommand(Qry, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@nombre", categoria.nombre);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
}
}
public void Registrar_Categoria(categoriaEntitis categoria)
{
_metodos.Registrar_Categoria(categoria);
}
public LogicaCategoria()
{
this._categoria = new categoriaEntitis();
}
