private void btnRegistrar_Click(object sender, RoutedEventArgs e) { T_C_Tabla temp = new T_C_Tabla(); temp.Nombre_Tabla = txtNombre.Text; temp.Descripcion_Tabla = txtDescripción.Text; MessageBox.Show(tablaLogic.AgregarTabla(temp)); gvTablas.ItemsSource = tablaLogic.ListarTablas(); }
public string EliminarTabla(T_C_Tabla tabla) { try { using (Command = new System.Data.SqlClient.SqlCommand("T_C_TablaDelete", Connection)) { Command.CommandType = System.Data.CommandType.StoredProcedure; Command.Parameters.AddWithValue("@Id_Tabla", tabla.Id_Tabla); Connection.Open(); Command.ExecuteNonQuery(); } return "Registro eliminado satisfactoriamente."; } catch (Exception ex) { return ex.Message; } finally { Connection.Close(); } }
public string AgregarTabla(T_C_Tabla tabla) { try { using (Command = new System.Data.SqlClient.SqlCommand("T_C_TablaInsert", Connection)) { Command.CommandType = System.Data.CommandType.StoredProcedure; Command.Parameters.AddWithValue("@Nombre_Tabla", tabla.Nombre_Tabla); Command.Parameters.AddWithValue("@Descripcion_Tabla", tabla.Descripcion_Tabla); Connection.Open(); Command.ExecuteNonQuery(); } return "Registro grabado satisfactoriamente."; } catch (Exception ex) { return ex.Message; } finally { Connection.Close(); } }
public T_C_Tabla SeleccionarTabla(int idTabla) { try { Connection = new SqlConnection(ConnectionString); T_C_Tabla tabla = new T_C_Tabla(); using (Command = new System.Data.SqlClient.SqlCommand("T_C_TablaSelect", Connection)) { Command.Parameters.AddWithValue("@IdTabla", idTabla); Command.CommandType = System.Data.CommandType.StoredProcedure; Connection.Open(); SqlDataReader reader = Command.ExecuteReader(); while (reader.Read()) { tabla.Id_Tabla = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("Id_Tabla")).ToString()); tabla.Nombre_Tabla = reader.GetValue(reader.GetOrdinal("Nombre_Tabla")).ToString(); tabla.Descripcion_Tabla = reader.GetValue(reader.GetOrdinal("Descripcion_Tabla")).ToString(); } } return tabla; } catch (Exception ex) { return null; } finally { Connection.Close(); } }
public List<T_C_Tabla> SeleccionarTodosTabla() { try { Connection = new SqlConnection(ConnectionString); List<T_C_Tabla> tablas; using (Command = new System.Data.SqlClient.SqlCommand("T_C_TablaSelectAll", Connection)) { Command.CommandType = System.Data.CommandType.StoredProcedure; Connection.Open(); tablas = new List<T_C_Tabla>(); SqlDataReader reader = Command.ExecuteReader(); while (reader.Read()) { T_C_Tabla tabla = new T_C_Tabla(); tabla.Id_Tabla = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("Id_Tabla")).ToString()); tabla.Nombre_Tabla = reader.GetValue(reader.GetOrdinal("Nombre_Tabla")).ToString(); tabla.Descripcion_Tabla = reader.GetValue(reader.GetOrdinal("Descripcion_Tabla")).ToString(); tablas.Add(tabla); } } return tablas; } catch (Exception ex) { return null; } finally { Connection.Close(); } }