private void LoadComboBoxes()
{
try
{
var dti = ConnectionDB.ExecuteQuery("SELECT iduser FROM appuser " +
$"WHERE username = '******'");
var dri = dti.Rows[0];
int auxidu = Convert.ToInt16(dri[0].ToString());
var direcciones = ConnectionDB.ExecuteQuery("SELECT idaddress,address FROM address " +
$"WHERE iduser = {auxidu}");
var direccionesCombo = new List <string>();
var negocios = ConnectionDB.ExecuteQuery("SELECT idbusiness,name FROM business");
var negocosCombo = new List <string>();
foreach (DataRow dr in direcciones.Rows)
{
direccionesCombo.Add(dr[0].ToString() + " " + dr[1].ToString());
}
foreach (DataRow dr in negocios.Rows)
{
negocosCombo.Add(dr[0].ToString() + " " + dr[1].ToString());
}
cmbDirecciones.DataSource = direccionesCombo;
cmbNegocios.DataSource = negocosCombo;
string auxcadena = cmbNegocios.SelectedItem.ToString();
int auxlim = LimiteFinal(auxcadena);
int auxid = 0;
if (auxlim > 0)
{
auxid = Convert.ToInt16(auxcadena.Substring(0, auxlim));
}
else
{
auxid = Convert.ToInt16($"{auxcadena[0]}");
}
var producto = ConnectionDB.ExecuteQuery("SELECT idproduct,name FROM product " +
$"WHERE idbusiness = {auxid}");
var productoCombo = new List <string>();
foreach (DataRow dr in producto.Rows)
{
productoCombo.Add(dr[0].ToString() + " " + dr[1].ToString());
}
cmbProductos.DataSource = productoCombo;
}
catch (Exception ex)
{
MessageBox.Show("Ha ocurrido un erro al cargar las listas!");
}
}
private void LoadHistorial()
{
var dti = ConnectionDB.ExecuteQuery("SELECT iduser FROM appuser " +
$"WHERE username = '******'");
var dri = dti.Rows[0];
int auxid = Convert.ToInt16(dri[0].ToString());
var dt = ConnectionDB.ExecuteQuery("SELECT idaddress,address FROM address " +
$"WHERE iduser = {auxid}");
dgvDirecciones.DataSource = dt;
var dt2 = ConnectionDB.ExecuteQuery("SELECT app.idorder,apu.fullname,adr.address," +
"pro.name,bus.name,app.createdate " +
"FROM APPORDER app, PRODUCT pro, APPUSER apu, ADDRESS adr, BUSINESS bus " +
"WHERE app.idaddress = adr.idaddress AND adr.iduser = apu.iduser " +
$"AND apu.iduser = {auxid} AND app.idproduct = pro.idproduct AND pro.idbusiness = bus.idbusiness");
dgvOrdenes.DataSource = dt2;
}
private void LoadComboBoxes()
{
var dti = ConnectionDB.ExecuteQuery("SELECT iduser FROM appuser " +
$"WHERE username = '******'");
var dri = dti.Rows[0];
int auxidu = Convert.ToInt16(dri[0].ToString());
var ordenes = ConnectionDB.ExecuteQuery("SELECT app.idorder,adr.address," +
"pro.name,bus.name,app.createdate " +
"FROM APPORDER app, PRODUCT pro, APPUSER apu, ADDRESS adr, BUSINESS bus " +
$"WHERE app.idaddress = adr.idaddress AND adr.iduser = apu.iduser AND apu.iduser = {auxidu}" +
"AND app.idproduct = pro.idproduct AND pro.idbusiness = bus.idbusiness");
var ordenesCombo = new List <string>();
foreach (DataRow dr in ordenes.Rows)
{
ordenesCombo.Add(dr[0].ToString() + " " + dr[1].ToString() + " " +
dr[2].ToString() + " " + dr[3].ToString() + " " + dr[4].ToString());
}
cmbOrdenes.DataSource = ordenesCombo;
}
public uscAnadirDireccion()
{
InitializeComponent();
username = ControlDeUsuario.DevolverUserName();
}