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