private void AgregarPedido_Click(object sender, EventArgs e)
{
Button oButton = ((Button)sender);
if (btnClick != null)
{
btnClick.Image = (Image)Properties.Resources.ResourceManager.GetObject(btnClick.Tag.ToString());
}
btnClick = oButton;
int IDProduct = Convert.ToInt32(oButton.Name.Split(new char[] { '_' }).Last());
productSelected = oBL.GetRowById(ref _error, IDProduct);
if (_error == null)
{
lblStock.Text = "Stock: " + productSelected.Stock;
lblDescripcion.Text = productSelected.Name;
txtPrecio.Text = productSelected.UnitPrice.ToString();
txtCantidad.Text = Cantidad.ToString();
txtTotal.Text = productSelected.UnitPrice.ToString();
IsDeleted = false;
btnAgregarEliminar.Text = "Agregar";
txtCantidad.Focus();
txtCantidad.SelectAll();
}
}
public static List <aeProduct> GetDataSearch(ref string pResult, string pSearch)
{
SqlConnection oCnnData = daConnection.Connect();
try
{
List <aeProduct> oLista = new List <aeProduct>();
SqlCommand oCmd = new SqlCommand("uspProductSearch", oCnnData);
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.Parameters.Clear();
oCmd.Parameters.AddWithValue("@pSearch", pSearch);
SqlDataReader oRdr;
oRdr = oCmd.ExecuteReader();
while (oRdr.Read())
{
aeProduct oRow = new aeProduct();
oRow.IdProduct = Convert.ToInt16(oRdr["IdProduct"]);
oRow.Name = (oRdr["Name"] == DBNull.Value) ? "" : oRdr["Name"].ToString();
oRow.CodeCategory = (oRdr["CodeCategory"] == DBNull.Value) ? "" : oRdr["CodeCategory"].ToString();
oRow.UnitPrice = oRdr["UnitPrice"] == DBNull.Value ? 0 : Convert.ToDouble(oRdr["UnitPrice"]);
oRow.IdCategory = oRdr["IdCategory"] == DBNull.Value ? 0 : Convert.ToInt16(oRdr["IdCategory"]);
oRow.IdMeasure = oRdr["IdMeasure"] == DBNull.Value ? 0 : Convert.ToInt16(oRdr["IdMeasure"]);
oRow.Stock = oRdr["Stock"] == DBNull.Value ? 0 : Convert.ToDouble(oRdr["Stock"]);
oRow.Estate = (oRdr["Estate"] == DBNull.Value) ? false : Convert.ToInt16(oRdr["Estate"]) == 1 ? true : false;
oRow.RowVersion = (oRdr["RowVersion"] == DBNull.Value) ? "" : oRdr["RowVersion"].ToString();
oLista.Add(oRow);
}
oCnnData.Close();
return(oLista);
//pResult = "El usuario no tienen ningun ROL asignado, consulte con el administrador.";
//pResult = oCmd.Parameters["@pResult"].Value.ToString();
}
catch (Exception ex)
{
pResult = ex.Message;
}
oCnnData.Close();
return(null);
}
