//Recibe el nombre de la tabla sacada de Conexion.Tabla, y un diccionario con el par //("nombre de columna en BD", dato a insertar) //retorna true si se pudo realizar, false si fallo public int Insertar(string tabla, Dictionary <string, object> data) { try { string comandoString = string.Copy(comandoInsert) + tabla + " ("; data.Keys.ToList().ForEach(k => comandoString += k + ", "); comandoString = comandoString.Substring(0, comandoString.Length - 2) + ") VALUES ("; data.Keys.ToList().ForEach(k => comandoString += "@" + k + ", "); comandoString = comandoString.Substring(0, comandoString.Length - 2) + "); SELECT SCOPE_IDENTITY();"; PinkieLogger.logInsert(comandoString, data); using (SqlConnection sqlConnection = new SqlConnection(conectionString)) { sqlConnection.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = sqlConnection; command.CommandType = CommandType.Text; command.CommandText = comandoString; foreach (KeyValuePair <string, object> entry in data) { command.Parameters.AddWithValue("@" + entry.Key, entry.Value); } return(Convert.ToInt32(command.ExecuteScalar())); } } } catch (SqlException ex) { PinkieLogger.logExcepcion(ex); return(-1); } }
//Recibe el id de la fila, nombre de la tabla sacada de Conexion.Tabla, y //un diccionario con el par ("nombre de columna en BD", dato a insertar //retorna true si se pudo realizar, false si fallo public bool Modificar(int pk, string tabla, Dictionary <string, object> data) { try { string comandoString = string.Copy(comandoUpdate) + tabla + " SET "; foreach (KeyValuePair <string, object> entry in data) { comandoString += entry.Key + " = @" + entry.Key + ", "; } comandoString = comandoString.Substring(0, comandoString.Length - 2) + " WHERE id = @id"; PinkieLogger.logUpdate(comandoString, data); using (SqlConnection sqlConnection = new SqlConnection(conectionString)) { sqlConnection.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = sqlConnection; command.CommandType = CommandType.Text; command.CommandText = comandoString; command.Parameters.AddWithValue("@id", pk); foreach (KeyValuePair <string, object> entry in data) { command.Parameters.AddWithValue("@" + entry.Key, entry.Value); } command.ExecuteNonQuery(); } } } catch (SqlException ex) { PinkieLogger.logExcepcion(ex); return(false); } return(true); }
public bool PagarReserva(int codigo, string tabla) { try { string comandoString = string.Copy(comandoUpdate) + tabla + " SET pagado = 1 WHERE codigo = @id"; using (SqlConnection sqlConnection = new SqlConnection(conectionString)) { sqlConnection.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = sqlConnection; command.CommandType = CommandType.Text; command.CommandText = comandoString; command.Parameters.AddWithValue("@id", codigo); command.ExecuteNonQuery(); } } } catch (SqlException ex) { PinkieLogger.logExcepcion(ex); return(false); } return(true); }