public static void SaveException(ControlErroresModel aControlErroresModel) { try { using (var connection = Util.ConnectionFactory.conexion()) { //connection.Open(); //SqlTransaction sqlTran = connection.BeginTransaction(); //SqlCommand command = connection.CreateCommand(); //command.Transaction = sqlTran; //command.Parameters.AddWithValue("@Usuario", aControlErroresModel.Usuario); //command.Parameters.AddWithValue("@Fecha", aControlErroresModel.Fecha); //command.Parameters.AddWithValue("@Componente", aControlErroresModel.Componente); //command.Parameters.AddWithValue("@Descripcion", aControlErroresModel.Descripcion == null ? (object)DBNull.Value : aControlErroresModel.Descripcion); //command.CommandType = CommandType.StoredProcedure; //command.CommandText = "ControlErroresModelInsert"; //// Commit the transaction. //sqlTran.Commit(); //connection.Close(); //connection.Dispose(); } } catch (Exception) { } }
/// <summary> /// Selects the Single object of ControlErroresModel table. /// </summary> public ControlErroresModel GetControlErroresModel(int aId) { ControlErroresModel ControlErroresModel = null; try { using (var connection = Util.ConnectionFactory.conexion()) { connection.Open(); SqlCommand command = connection.CreateCommand(); command.Parameters.AddWithValue("@Id", aId); command.CommandType = CommandType.StoredProcedure; command.CommandText = "ControlErroresModelSelect"; SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { int Id = (int)(reader["Id"]); string Usuario = (string)(reader["Usuario"]); DateTime Fecha = (DateTime)(reader["Fecha"]); string Componente = (string)(reader["Componente"]); byte[] Descripcion = (byte[])(reader["Descripcion"]); ControlErroresModel = new ControlErroresModel { Id = Id, Usuario = Usuario, Fecha = Fecha, Componente = Componente, Descripcion = Descripcion, }; } } } return(ControlErroresModel); } catch (Exception) { return(null); } }
/// <summary> /// Updates a record to the ControlErroresModel table. /// returns True if value saved successfully else false /// Throw exception with message value EXISTS if the data is duplicate /// </summary> public bool Update(ControlErroresModel aControlErroresModel) { try { using (var connection = Util.ConnectionFactory.conexion()) { connection.Open(); SqlTransaction sqlTran = connection.BeginTransaction(); SqlCommand command = connection.CreateCommand(); command.Transaction = sqlTran; command.Parameters.AddWithValue("@Id", aControlErroresModel.Id); command.Parameters.AddWithValue("@Usuario", aControlErroresModel.Usuario); command.Parameters.AddWithValue("@Fecha", aControlErroresModel.Fecha); command.Parameters.AddWithValue("@Componente", aControlErroresModel.Componente); command.Parameters.AddWithValue("@Descripcion", aControlErroresModel.Descripcion == null ? (object)DBNull.Value : aControlErroresModel.Descripcion); command.CommandType = CommandType.StoredProcedure; command.CommandText = "ControlErroresModelUpdate"; int afectados = command.ExecuteNonQuery(); // Commit the transaction. sqlTran.Commit(); connection.Close(); connection.Dispose(); if (afectados > 0) { return(true); } else { return(false); } } } catch (Exception) { return(false); } }