public List <ePasteleria> listodo() { try { List <ePasteleria> lspasteleria = new List <ePasteleria>(); ePasteleria pasteleria = null; SqlConnection con = db.ConectarDB(); string select = string.Format("SELECT idpasteleria,idcliente,idplato FROM pasteleria"); SqlCommand cmd = new SqlCommand(select, con); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { pasteleria = new ePasteleria(); pasteleria.idpasteleria = (int)reader["idpasteleria"]; pasteleria.dniCliente = (string)reader["idcliente"]; pasteleria.idplatos = (int)reader["idplato"]; lspasteleria.Add(pasteleria); } reader.Close(); return(lspasteleria); } catch (Exception ex) { return(null); } finally { db.DesconectarDB(); } }
public ePasteleria BuscarPorId(int id) { try { ePasteleria pasteleria = null; SqlConnection con = db.ConectarDB(); string select = string.Format("SELECT idpasteleria,idcliente,idplato FROM pasteleria WHERE idpasteleria = {0}", id); SqlCommand cmd = new SqlCommand(select, con); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { pasteleria = new ePasteleria(); pasteleria.idpasteleria = (int)reader["idpasteleria"]; pasteleria.dniCliente = (string)reader["idcliente"]; pasteleria.idplatos = (int)reader["idplato"]; } reader.Close(); return(pasteleria); } catch (Exception ex) { return(null); } finally { db.DesconectarDB(); } }
private void dataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e) { pas = dataGrid.SelectedItem as ePasteleria; if (pas != null) { idpasteleria = pas.idpasteleria; comboBox.SelectedItem = Convert.ToString(pas.dniCliente); comboBox1.Text = Convert.ToString(pas.idplatos); } }
public string ModificarPasteleria(int idpasteleria, int idplato, string idcliente) { ePasteleria pasteleria = new ePasteleria() { dniCliente = idcliente, idplatos = idplato, }; return(datospas.Modificar(pasteleria, idpasteleria)); }
public string RegistrarPasteleria(string idcliente, int idplatos) { ePasteleria pasteleria = new ePasteleria() { dniCliente = idcliente, idplatos = idplatos }; return(datospas.Insertar(pasteleria)); }
public string Modificar(ePasteleria pas, int idpasteleria) { try { SqlConnection conexion = db.ConectarDB(); string update = string.Format("UPDATE pasteleria SET idcliente='{0}', idplato={1} Where idpasteleria={2}", pas.dniCliente, pas.idplatos, idpasteleria); SqlCommand cmd = new SqlCommand(update, conexion); cmd.ExecuteNonQuery(); return("Actualizo Datos"); } catch (Exception ex) { return(ex.Message); } finally { db.DesconectarDB(); } }
public string Insertar(ePasteleria pas) { try { SqlConnection con = db.ConectarDB(); string insert = string.Format("insert into pasteleria(idcliente,idplato)values('{0}',{1})", pas.dniCliente, pas.idplatos); SqlCommand cmd = new SqlCommand(insert, con); cmd.ExecuteNonQuery(); return("Inserto"); } catch (Exception ex) { return(ex.Message); } finally { db.DesconectarDB(); } }