/// <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;
}