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); }