/// <summary> /// Puts info into DB. /// </summary> /// <param name="info">Record information to submit</param> /// <param name="op">Which kind to operation to make. 1:Insert, 2:update, 3:delete</param> /// <returns>Identity ID for just created record.</returns> public int crearTeatro(TeatroDto info, int op) { if (log.IsDebugEnabled) { log.Debug("crearTeatro Starts"); } HandleDatabase hdb = null; SqlTransaction transaction = null; int rslt = 0; try { List<SqlParameter> paramList = new List<SqlParameter>() { new SqlParameter() { ParameterName = "@operacion", Value = op, SqlDbType = SqlDbType.Int }, new SqlParameter() { ParameterName = "@id", Value = info.idTeatro, SqlDbType = SqlDbType.Int }, new SqlParameter() { ParameterName = "@idCine", Value = info.idCine, SqlDbType = SqlDbType.Int }, new SqlParameter() { ParameterName = "@nombreTeatro", Value = info.nombreTeatro.ToString(), SqlDbType = SqlDbType.VarChar }, new SqlParameter() { ParameterName = "@telefono1Teatro", Value = info.telefono1Teatro.ToString(), SqlDbType = SqlDbType.VarChar }, new SqlParameter() { ParameterName = "@telefono2Teatro", Value = info.telefono2Teatro.ToString(), SqlDbType = SqlDbType.VarChar }, new SqlParameter() { ParameterName = "@telefono3Teatro", Value = info.telefono3Teatro.ToString(), SqlDbType = SqlDbType.VarChar }, new SqlParameter() { ParameterName = "@idMunicipioTeatro", Value = info.idMunicipioTeatro, SqlDbType = SqlDbType.Int }, new SqlParameter() { ParameterName = "@idDepartamentoTeatro", Value = info.idDepeartamentoTeatro, SqlDbType = SqlDbType.Int }, new SqlParameter() { ParameterName = "@direccionTeatro", Value = info.direccionTeatro, SqlDbType = SqlDbType.VarChar } }; String sql = "sp_crearActualizarTeatro @operacion, @id, @idCine, @nombreTeatro, @telefono1Teatro, @telefono2Teatro, @telefono3Teatro, @idMunicipioTeatro, @idDepartamentoTeatro, @direccionTeatro"; var i = 1; if (log.IsDebugEnabled) { log.Debug("SQL=[" + sql + "]"); paramList.ForEach(p => { var paramValues = "ParameterName=[" + p.ParameterName + "], Value=[" + p.Value + "], SqlDbType=[" + p.SqlDbType + "]"; log.Debug("Parameter " + i++ + " val=[" + paramValues + "]"); }); } hdb = new HandleDatabase(Settings.Connection); hdb.Open(); transaction = hdb.BeginTransaction("crearCine"); rslt = hdb.ExecuteSelectSQLStmtAsScalar(transaction, sql, paramList.ToArray()); } catch (Exception ex) { if (log.IsFatalEnabled) { log.Fatal("Exception occurred " + ex.Message); log.Fatal("Exception trace=[" + ex.StackTrace + "]"); log.Fatal("Returns -1"); } rslt = -1; } finally { try { if (transaction != null) { transaction.Commit(); } if (hdb != null) { hdb.Close(); } } catch (Exception e) { if (log.IsFatalEnabled) { log.Fatal("Exception occurred " + e.Message); log.Fatal("Exception trace=[" + e.StackTrace + "]"); log.Fatal("Returns -1"); } rslt = -1; } } if (log.IsDebugEnabled) { log.Debug("rslt=[" + rslt + "]"); log.Debug("crearTeatro Ends"); } return rslt; }
/// <summary> /// Puts info into DB. /// </summary> /// <param name="info">Record information to submit</param> /// <param name="op">Which kind to operation to make. 1:Insert, 2:update, 3:delete</param> /// <returns>Identity ID for just created record.</returns> public int createCine(CineDto info, int op) { if (log.IsDebugEnabled) { log.Debug("createCine Starts"); } SqlTransaction transaction = null; HandleDatabase hdb = null; int rslt = 0; try { List<SqlParameter> paramList = new List<SqlParameter>(); paramList.Add(new SqlParameter() { ParameterName = "@operacion", Value = op, SqlDbType = SqlDbType.Int }); paramList.Add(new SqlParameter() { ParameterName = "@id", Value = info.idCine, SqlDbType = SqlDbType.Int }); paramList.Add(new SqlParameter() { ParameterName = "@nombreCine", Value = info.nombreCine.ToString(), SqlDbType = SqlDbType.VarChar }); paramList.Add(new SqlParameter() { ParameterName = "@fechaCreacionCine", Value = info.fechaCreacionCine, SqlDbType = SqlDbType.DateTime }); paramList.Add(new SqlParameter() { ParameterName = "@nit", Value = info.nit, SqlDbType = SqlDbType.VarChar }); String sql = "sp_crearActualizarCine @operacion, @id, @nombreCine, @fechaCreacionCine, @nit"; var i = 1; if (log.IsDebugEnabled) { log.Debug("SQL=[" + sql + "]"); paramList.ForEach(p => { var paramValues = "ParameterName=[" + p.ParameterName + "], Value=[" + p.Value + "], SqlDbType=[" + p.SqlDbType + "]"; log.Debug("Parameter " + i++ + " val=[" + paramValues + "]"); }); } hdb = new HandleDatabase(Settings.Connection); hdb.Open(); transaction = hdb.BeginTransaction("crearCine"); rslt = hdb.ExecuteSelectSQLStmtAsScalar(transaction, sql, paramList.ToArray()); if (log.IsDebugEnabled) { log.Debug("createCine Ends"); } } catch (Exception ex) { if (log.IsFatalEnabled) { log.Fatal("Exception occurred " + ex.Message); log.Fatal("Exception trace=[" + ex.StackTrace + "]"); log.Fatal("Returns 0"); } rslt = 0; } finally { try { if (transaction != null) { transaction.Commit(); } if (hdb != null) { hdb.Close(); } } catch (Exception e) { if (log.IsFatalEnabled) { log.Fatal("Exception occurred " + e.Message); log.Fatal("Exception trace=[" + e.StackTrace + "]"); log.Fatal("Returns 0"); } rslt = 0; } } log.Debug("Rslt=[" + rslt + "]"); if (log.IsDebugEnabled) { log.Debug("createCine Ends"); } return rslt; }
/// <summary> /// Puts info into DB. /// </summary> /// <param name="info">Record information to submit</param> /// <param name="op">Which kind to operation to make. 1:Insert, 2:update, 3:delete</param> /// <returns>Identity ID for just created record.</returns> public int createEntidad(EntidadDto info, int op) { if (log.IsDebugEnabled) { log.Debug("createEntidad Starts"); } HandleDatabase hdb = null; SqlTransaction transaction = null; int rslt = 0; try { List<SqlParameter> paramList = new List<SqlParameter>() { new SqlParameter() { ParameterName = "@operacion", Value = op, SqlDbType = SqlDbType.Int }, new SqlParameter() { ParameterName = "@id", Value = info.idEntidad, SqlDbType = SqlDbType.Int }, new SqlParameter() { ParameterName = "@codigo", Value = info.codEntidad.ToString(), SqlDbType = SqlDbType.VarChar }, new SqlParameter() { ParameterName = "@nombre", Value = info.nombreEntidad, SqlDbType = SqlDbType.VarChar }, new SqlParameter() { ParameterName = "@valor", Value = info.valorEntidad, SqlDbType = SqlDbType.VarChar }, new SqlParameter() { ParameterName = "@descripcion", Value = info.descripcionEntidad, SqlDbType = SqlDbType.VarChar } }; String sql = "sp_crearActualizarEntidad @operacion, @id, @codigo, @nombre, @valor, @descripcion"; var i = 1; if (log.IsDebugEnabled) { log.Debug("SQL=[" + sql + "]"); paramList.ForEach(p => { var paramValues = "ParameterName=[" + p.ParameterName + "], Value=[" + p.Value + "], SqlDbType=[" + p.SqlDbType + "]"; log.Debug("Parameter " + i++ + " val=[" + paramValues + "]"); }); } hdb = new HandleDatabase(Settings.Connection); hdb.Open(); transaction = hdb.BeginTransaction("crearEntidad"); rslt = hdb.ExecuteSelectSQLStmtAsScalar(transaction, sql, paramList.ToArray()); } catch (Exception ex) { if (log.IsFatalEnabled) { log.Fatal("Exception occurred " + ex.Message); log.Fatal("Exception trace=[" + ex.StackTrace + "]"); log.Fatal("Returns -1"); } rslt = -1; } finally { try { if (transaction != null) { transaction.Commit(); } if (hdb != null) { hdb.Close(); } } catch (Exception e) { log.Fatal("Exception occurred " + e.Message); log.Fatal("Exception trace=[" + e.StackTrace + "]"); log.Fatal("Returns -1"); rslt = -1; } } if (log.IsDebugEnabled) { log.Debug("Rslt=[" + rslt + "]"); log.Debug("createEntidad Ends"); } return rslt; }