public void insertarBodegaCentral(BodegaCentral cli) { this.configConex(); this.cnn._esSelect = true; this.cnn._sentenciaSQL = "insert into " + this.cnn._nombreTabla + " values(" + cli._ID_BodegaCentral + "," + cli._ingrediente + "," + cli._cantidad + ")"; this.cnn.conectar(); this.cnn.cerrarConexion(); }
public void modificarBodegaCentral(BodegaCentral cli) { this.configConex(); this.cnn._sentenciaSQL = "update " + cnn._nombreTabla + " set ID_BodegaCentral=" + cli._ID_BodegaCentral + "," + "Ingrediente=" + cli._ingrediente + "," + "Cantidad=" + cli._cantidad + " where ID_BodegaCentral=" + cli._ID_BodegaCentral; this.cnn._esSelect = false; this.cnn.conectar(); this.cnn.cerrarConexion(); }
public System.Collections.ArrayList getBodegaCentral() { System.Collections.ArrayList lista = new System.Collections.ArrayList(); this.configConex(); this.cnn._sentenciaSQL = "Select * from " + cnn._nombreTabla; this.cnn._esSelect = true; this.cnn.conectar(); foreach (System.Data.DataRow dr in this.cnn._dbDataSet.Tables[this.cnn._nombreTabla].Rows) { BodegaCentral ca = new BodegaCentral(); ca._ID_BodegaCentral = int.Parse(dr["ID_BodegaCentral"].ToString()); ca._ingrediente = int.Parse(dr["Ingrediente"].ToString()); ca._cantidad = int.Parse(dr["Cantidad"].ToString()); lista.Add(ca); } this.cnn.cerrarConexion(); return(lista); }
public BodegaCentral buscarBodegaCentral(int idCliente) { BodegaCentral cli = new BodegaCentral(); this.configConex(); this.cnn._sentenciaSQL = "Select * from " + cnn._nombreTabla + " where ID_BodegaCentral = " + idCliente; this.cnn._esSelect = true; this.cnn.conectar(); System.Data.DataTable dt = new System.Data.DataTable(); dt = cnn._dbDataSet.Tables[0]; try { cli._ID_BodegaCentral = int.Parse(dt.Rows[0][0].ToString()); cli._ingrediente = int.Parse(dt.Rows[0][1].ToString()); cli._cantidad = int.Parse(dt.Rows[0][2].ToString()); } catch (Exception e) { cli._ID_BodegaCentral = 0; } this.cnn.cerrarConexion(); return(cli); }