public string AgregarModelo(T_C_Modelo modelo)
{
try
{
Connection = new SqlConnection(ConnectionString);
using (Command = new System.Data.SqlClient.SqlCommand("T_C_ModeloInsert", Connection))
{
Command.CommandType = System.Data.CommandType.StoredProcedure;
Command.Parameters.AddWithValue("@Descripcion", modelo.Descripcion);
Command.Parameters.AddWithValue("@Año", modelo.Año);
Command.Parameters.AddWithValue("@Id_Marca", modelo.Id_Marca);
Connection.Open();
Command.ExecuteNonQuery();
}
return "Registro grabado satisfactoriamente.";
}
catch (Exception ex)
{
return ex.Message;
}
finally
{
Connection.Close();
}
}
private void btnRegistrar_Click(object sender, RoutedEventArgs e)
{
T_C_Modelo modelo = new T_C_Modelo();
modelo.Id_Marca = (cmbMarca.SelectedItem as T_C_Marca).Id_Marca;
modelo.Descripcion = txtDescripcion.Text;
modelo.Año = int.Parse(udAño.Value.ToString());
MessageBox.Show(modeloLogic.AgregarModelo(modelo));
gvModelo.ItemsSource = modeloLogic.ListarTodos();
Limpia();
SoloRegistra();
}
public string EliminarModelo(T_C_Modelo modelo)
{
return modeloAccess.EliminarModelo(modelo);
}
public string ActualizarModelo(T_C_Modelo modelo)
{
return modeloAccess.ActualizarModelo(modelo);
}
public string AgregarModelo(T_C_Modelo modelo)
{
return modeloAccess.AgregarModelo(modelo);
}
public string EliminarModelo(T_C_Modelo modelo)
{
try
{
Connection = new SqlConnection(ConnectionString);
using (Command = new System.Data.SqlClient.SqlCommand("T_C_ModeloDelete", Connection))
{
Command.CommandType = System.Data.CommandType.StoredProcedure;
Command.Parameters.AddWithValue("@Id_Modelo", modelo.Id_Modelo);
Connection.Open();
Command.ExecuteNonQuery();
}
return "Registro eliminado satisfactoriamente.";
}
catch (Exception ex)
{
return ex.Message;
}
finally
{
Connection.Close();
}
}
public List<T_C_Modelo> SeleccionarTodosModelo()
{
try
{
Connection = new SqlConnection(ConnectionString);
List<T_C_Modelo> modelos;
using (Command = new System.Data.SqlClient.SqlCommand("T_C_ModeloSelectAll", Connection))
{
Command.CommandType = System.Data.CommandType.StoredProcedure;
Connection.Open();
modelos = new List<T_C_Modelo>();
SqlDataReader reader = Command.ExecuteReader();
while (reader.Read())
{
T_C_Modelo modelo = new T_C_Modelo();
modelo.Id_Modelo=Convert.ToInt32(reader.GetValue(reader.GetOrdinal("Id_Modelo")).ToString());
modelo.Id_Marca = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("Id_Marca")).ToString());
modelo.Descripcion = reader.GetValue(reader.GetOrdinal("Descripcion")).ToString();
modelo.Año = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("Año")).ToString());
modelo.Id_Estado = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("Id_Estado")).ToString());
modelo.Estado = estadoAccess.Seleccionar(modelo.Id_Estado);
modelo.Marca = marcaAccess.SeleccionarMarca(modelo.Id_Marca);
modelos.Add(modelo);
}
}
return modelos;
}
catch (Exception ex)
{
return null;
}
finally
{
Connection.Close();
}
}
