/// <summary>
/// Trae los datos del prestamo que sera eliminado
/// </summary>
/// <param name="codigo">Codigo del prestamo a eliminar</param>
private void getDatosPrestamos(string codigo)
{
System.Data.Odbc.OdbcDataReader dr = null;
Prestamo objPrestamo = new Prestamo();
string sqlselect = "SELECT codigo, valor, porcentaje, total, fecha_inicio, fecha_final, cuotas, valor_cuota, cedula_cliente, saldo";
sqlselect += " FROM tprestamo WHERE codigo = '" + codigo + "'";
dr = objPrestamo.getObjDatareader(sqlselect);
if (dr.HasRows)
{
TXTvalor.Text = dr.GetString(1);
TXTporcent.Text = dr.GetString(2);
TXTtotal.Text = dr.GetString(3);
TXTnumcuotas.Text = dr.GetString(6);
TXTvalorcuota.Text = dr.GetString(7);
TXTsaldo.Text = dr.GetString(9);
LBLcodigo.Text = dr.GetString(0);
TXTfechaini.Text = dr.GetDateTime(4).ToShortDateString();
TXTfechafin.Text = dr.GetDateTime(5).ToShortDateString();
}
else
{
this.ReestablecerPrestamo();
}
}
/// <summary>
/// Devuelve el nombre del usuario actualmente conectado dependiendo de la identificacion
/// </summary>
/// <param name="identificacion">Identificacion del usuario (normalmente es la cedula)</param>
/// <returns></returns>
public string getNombreUsuario(string identificacion)
{
string sql = "SELECT nombre FROM tlogin WHERE usuario = '" + identificacion + "'";
string res = null;
System.Data.Odbc.OdbcDataReader dr = conex.getDataSelect_SQL(sql, conex.getConexion());
if (dr.HasRows)
{
dr.Read();
res = dr.GetString(0).ToUpper();
}
return(res);
}
// <summary>
/// recompute indexes for selected table
/// to speed up queries
/// </summary>
/// <returns></returns>
public static void UpdateIndexes(string tableType, DbConnect dbConnect)
{
ProtCidSettings.progressInfo.ResetCurrentProgressInfo();
DbQuery dbQuery = new DbQuery();
try
{
System.Data.Odbc.OdbcCommand updateIndexCommand = dbConnect.CreateCommand();
// retrieve user-defined indexes
string showIndexStr = @"select RDB$INDEX_NAME, RDB$RELATION_NAME from RDB$INDICES WHERE RDB$SYSTEM_FLAG = 0;";
//string showIndexStr = @"select RDB$INDEX_NAME from RDB$INDICES;";
updateIndexCommand.CommandText = showIndexStr;
System.Data.Odbc.OdbcDataReader indexReader = updateIndexCommand.ExecuteReader();
// ArrayList indexList = new ArrayList ();
Dictionary <string, List <string> > relationIndexHash = new Dictionary <string, List <string> > ();
string indexName = "";
string relationName = "";
if (indexReader.HasRows)
{
while (indexReader.Read())
{
relationName = indexReader.GetString(1).Trim().ToUpper();
if (relationName.IndexOf(tableType.ToUpper()) > -1)
{
indexName = indexReader.GetString(0).Trim().ToUpper();
if (relationIndexHash.ContainsKey(relationName))
{
relationIndexHash[relationName].Add(indexName);
}
else
{
List <string> relationIndexList = new List <string> ();
relationIndexList.Add(indexName);
relationIndexHash.Add(relationName, relationIndexList);
}
}
}
indexReader.Close();
}
foreach (string relationTable in relationIndexHash.Keys)
{
foreach (string index in relationIndexHash[relationTable])
{
// rebuild this index for cryst and interface
if (indexName.ToString().ToUpper().IndexOf("RDB$PRIMARY") == -1)
{
string inactiveIndexStr = string.Format("ALTER INDEX {0} INACTIVE;", index);
updateIndexCommand.CommandText = inactiveIndexStr;
updateIndexCommand.ExecuteNonQuery();
string activeIndexStr = string.Format("ALTER INDEX {0} ACTIVE;", index);
updateIndexCommand.CommandText = activeIndexStr;
updateIndexCommand.ExecuteNonQuery();
}
// recompute selectivity of this index
string updateSelectivityStr = string.Format("SET STATISTICS INDEX {0};", index);
updateIndexCommand.CommandText = updateSelectivityStr;
updateIndexCommand.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
// Displays the Error Message in the progress label.
ProtCidSettings.progressInfo.progStrQueue.Enqueue("Update Indexes Errors: " + ex.Message);
}
}