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