public DataTable getAllCategories()
{
string query = "Select * from categorias";
cmd.CommandText = query;
dt = function.queryCmd(cmd);
return(dt);
}
public string create()
{
string message;
string query = @"INSERT INTO productos values(@nombre, @categoria_id, @precio, @stock)";
cmd.Parameters.Clear();
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@nombre", this.getNombre());
cmd.Parameters.AddWithValue("@categoria_id", this.getCategoria_id());
cmd.Parameters.AddWithValue("@precio", this.getPrecio());
cmd.Parameters.AddWithValue("@stock", this.getStock());
try
{
function.queryCmd(cmd);
message = "SUCCESS";
}
catch
{
message = "ERROR";
}
return(message);
}
public DataTable getUserById(int num, string nombre)
{
string busqueda = @"Select * from Usuarios where numero_empleado = @num and nombre = @nombre";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = busqueda;
cmd.Parameters.AddWithValue("@num", num);
cmd.Parameters.AddWithValue("@nombre", nombre);
DataTable result = new DataTable();
result = function.queryCmd(cmd);
return(result);
}
public int getId(string nombre)
{
Helpers.dbConection function = new Helpers.dbConection();
int id;
string query = @"select id from categorias where nombre = @catNombre";
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@catNombre", nombre);
dt = function.queryCmd(cmd);
id = Int32.Parse(dt.Rows[0]["id"].ToString());
return((int)id);
}
