public OrderBol Get(int id)
{
MySqlDataReader reader = null;
MySqlConnection myConnection = new MySqlConnection();
myConnection.ConnectionString = @"Server=127.0.0.1;Port=49489;Database=lean_tech_backend_test;Uid=azure;Pwd=6#vWHD_$;";
MySqlCommand sqlCmd = new MySqlCommand();
sqlCmd.CommandText = "SELECT * FROM orders_bols where id_order_bol = " + id.ToString();
sqlCmd.CommandType = CommandType.Text;
sqlCmd.Connection = myConnection;
myConnection.Open();
reader = sqlCmd.ExecuteReader();
OrderBol obj = null;
while (reader.Read())
{
obj = new OrderBol();
obj.id = Convert.ToInt32(reader.GetValue(0));
obj.id_order = Convert.ToInt32(reader.GetValue(1));
obj.id_bol = Convert.ToInt32(reader.GetValue(2));
}
myConnection.Close();
return(obj);
}
public void Post(OrderBol obj)
{
MySqlConnection myConnection = new MySqlConnection();
myConnection.ConnectionString = @"Server=127.0.0.1;Port=49489;Database=lean_tech_backend_test;Uid=azure;Pwd=6#vWHD_$;";
MySqlCommand sqlCmd = new MySqlCommand();
sqlCmd.CommandType = CommandType.Text;
sqlCmd.CommandText = "INSERT INTO orders_bols (id_type, name_type) Values (@id_type, @name_type)";
sqlCmd.Connection = myConnection;
sqlCmd.Parameters.AddWithValue("@id_type", obj.id);
//sqlCmd.Parameters.AddWithValue("@name_type", obj.name);
myConnection.Open();
int rowInserted = sqlCmd.ExecuteNonQuery();
myConnection.Close();
}
