public void Connect()
{
myConnection = new OdbcConnection(dbInfo);
myConnection.Open();
myQuery = myConnection.CreateCommand();
Console.Write("DB connect");
}
public Result Connect(string connectionString)
{
try
{
dbConn = new OdbcConnection(connectionString);
dbConn.Open();
//command = dbConn.CreateCommand();
exception = null;
return Result.TRUE;
}
catch(Exception ex)
{
exception = ex;
return Result.EXCEPTION;
}
}
/// <summary>
/// The Windows PowerShell engine calls this method when the New-Drive
/// cmdlet is run. This provider creates a connection to the database
/// file and sets the Connection property in the PSDriveInfo.
/// </summary>
/// <param name="drive">
/// Information describing the drive to create.
/// </param>
/// <returns>An object that describes the new drive.</returns>
protected override PSDriveInfo NewDrive(PSDriveInfo drive)
{
// Check to see if the supplied drive object is null.
if (drive == null)
{
WriteError(new ErrorRecord(
new ArgumentNullException("drive"),
"NullDrive",
ErrorCategory.InvalidArgument,
null));
return null;
}
// Check to see if the drive root is not null or empty
// and if it iss an existing file.
if (String.IsNullOrEmpty(drive.Root) || (File.Exists(drive.Root) == false))
{
WriteError(new ErrorRecord(
new ArgumentException("drive.Root"),
"NoRoot",
ErrorCategory.InvalidArgument,
drive));
return null;
}
// Create the new drive and create an ODBC connection
// to the new drive.
var accessDBPSDriveInfo = new AccessDBPSDriveInfo(drive);
var builder = new OdbcConnectionStringBuilder();
builder.Driver = "Microsoft Access Driver (*.mdb)";
builder.Add("DBQ", drive.Root);
var conn = new OdbcConnection(builder.ConnectionString);
conn.Open();
accessDBPSDriveInfo.Connection = conn;
return accessDBPSDriveInfo;
}
private void Thread_Start()
{
bool connected = false;
OdbcConnection connection = null;
OdbcCommand command = null;
OdbcTransaction transact = null;
DateTime start = DateTime.Now;
bool shouldWriteException = true;
while (true)
{
m_Sync.WaitOne();
while (m_Queue.Count > 0)
{
try
{
object obj = m_Queue.Dequeue();
if (obj == null)
{
if (connected)
{
if (transact != null)
{
try{ transact.Commit(); }
catch (Exception commitException)
{
log.Error("MyRunUO: Exception caught when committing transaction",
commitException);
try
{
transact.Rollback();
log.Info("MyRunUO: Transaction has been rolled back");
}
catch (Exception rollbackException)
{
log.Error("MyRunUO: Exception caught when rolling back transaction",
rollbackException);
}
}
}
try{ connection.Close(); }
catch {}
try{ connection.Dispose(); }
catch {}
try{ command.Dispose(); }
catch {}
try{ m_Sync.Close(); }
catch {}
log.InfoFormat(m_CompletionString,
(DateTime.Now - start).TotalSeconds);
m_HasCompleted = true;
return;
}
else
{
try
{
connected = true;
connection = new OdbcConnection(m_ConnectionString);
connection.Open();
command = connection.CreateCommand();
if (Config.UseTransactions)
{
transact = connection.BeginTransaction();
command.Transaction = transact;
}
}
catch (Exception e)
{
try{ if (transact != null)
{
transact.Rollback();
}
}
catch {}
try{ if (connection != null)
{
connection.Close();
}
}
catch {}
try{ if (connection != null)
{
connection.Dispose();
}
}
catch {}
try{ if (command != null)
{
command.Dispose();
}
}
catch {}
try{ m_Sync.Close(); }
catch {}
log.Error("MyRunUO: Unable to connect to the database", e);
m_HasCompleted = true;
return;
}
}
}
else if (obj is string)
{
command.CommandText = (string)obj;
command.ExecuteNonQuery();
}
else
{
string[] parms = (string[])obj;
command.CommandText = parms[0];
if (command.ExecuteScalar() == null)
{
command.CommandText = parms[1];
command.ExecuteNonQuery();
}
}
}
catch (Exception e)
{
if (shouldWriteException)
{
log.Error("MyRunUO: Exception caught in database thread", e);
shouldWriteException = false;
}
}
}
lock (m_Queue.SyncRoot)
{
if (m_Queue.Count == 0)
{
m_Sync.Reset();
}
}
}
}
public OdbcDatabaseConnection(string serverName, string user, string pass, string databaseName)
: base(serverName, user, pass, databaseName)
{
_dbConnection = new OdbcConnection(string.Format("DSN={0}; UID={1}; PWD={2}", serverName, user, pass));
}
public DatabaseChunkPart Process(IDatabaseEngine sourceEngine, string sourceSchemaName, List <QueryDefinition> sourceQueryDefinitions, OdbcConnection sourceConnection)
{
try
{
Console.WriteLine("DatabaseChunkBuilder");
var part = new DatabaseChunkPart(_chunkId, () => new PersonBuilder(), "0", 0);
var timer = new Stopwatch();
timer.Start();
var result = part.Load(sourceEngine, sourceSchemaName, sourceQueryDefinitions, sourceConnection, "");
if (result.Value != null)
{
//Logger.Write(_chunkId, LogMessageTypes.Info, result.Key);
throw result.Value;
}
part.Build();
return(part);
}
catch (Exception e)
{
throw;
}
}
protected void saveVente_Click(object sender, EventArgs e)
{
Connexion c = new Connexion(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
msg.Text = "";
bool mandatPlusVente = true; //Si la personne qui apporte le mandat est la meme que celle qui effectue la vente.
int honoraires = int.Parse(TextBoxHonoraires.Text);
Membre member = (Membre)Session["Membre"];
if (member == null)
{
Response.Redirect("sessionExpire.aspx");
}
//Enregistrement de la vente
double ratioMandataire = double.Parse(ratioNegoMandat.Text) / 100;
double ratioVendeur = (70 - double.Parse(ratioNegoMandat.Text)) / 100;
string[] date = TextBoxDateCompromis.Text.Split('/');
string dateCompromisEN = "null";
if (date.Length == 3)
{
dateCompromisEN = "#" + date[1] + "/" + date[0] + "/" + date[2] + "#";
}
date = TextBoxDateSignature.Text.Split('/');
string dateSignatureEN = "null";
if (date.Length == 3)
{
dateSignatureEN = "#" + date[1] + "/" + date[0] + "/" + date[2] + "#";
}
string requete = "INSERT INTO Ventes(`id_nego`, `id_acquereur`, `ref_bien`, `prix_vente`, `commission`, `sequestre`, `nom_notaire`, `prenom_notaire`, `adresse_notaire`, `cp_notaire`, `ville_notaire`, `tel_notaire`, `mail_notaire`, `taux_mandat`, `taux_vente`, `date_compromis`, `date_signature`) VALUES "
+ "("
+ member.IDCLIENT + "," + DropDownListAcq.SelectedValue + ",'" + Request.QueryString["ref"] + "',"
+ TextBoxPrix.Text + "," + TextBoxHonoraires.Text + "," + TextBoxSequestre.Text + ","
+ "'" + textnotnom.Text + "','" + textnotprenom.Text + "','" + textnotadresse.Text + "','" + textnotcp.Text + "','" + textnotville.Text + "','" + textnottel.Text + "','" + textnotmail.Text + "'"
+ "," + ratioMandataire.ToString().Replace(',', '.') + "," + ratioVendeur.ToString().Replace(',', '.')
+ "," + dateCompromisEN
+ "," + dateSignatureEN
+ ")";
c.Open();
c.exeRequetteOpen(requete);
c.Close();
//recupération de l'idNegoAcq
c.Open();
//int idNegoAcq = (int)c.exeRequetteOpen("SELECT idclient FROM Acquereurs WHERE id_acq = " + DropDownListAcq.SelectedValue).Tables[0].Rows[0]["idclient"];
int idNegoAcq = (int)c.exeRequetteOpen("SELECT idclient FROM Acquereurs WHERE id_acq = " + DropDownListAcq.SelectedValue).Tables[0].Rows[0]["idclient"];
c.Close();
labelTest.Text = idNegoAcq.ToString();
//recupératino de ID de la vente
string requet = "SELECT Ventes.ID FROM Ventes WHERE (Ventes.ref_bien)='" + Request.QueryString["ref"] + "' ORDER BY Ventes.ID DESC";
OdbcConnection co = new OdbcConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
OdbcCommand requett = new OdbcCommand(requet, co);
co.Open();
OdbcDataReader read = requett.ExecuteReader();
read.Read();
int idvente = int.Parse(read["ID"].ToString());
co.Close();
//Recupération de idNegoVente
string req = "SELECT Biens.idclient FROM Biens WHERE (((Biens.ref)='" + Request.QueryString["ref"] + "'))";
OdbcConnection connect = new OdbcConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
OdbcCommand requette = new OdbcCommand(req, connect);
connect.Open();
OdbcDataReader reader = requette.ExecuteReader();
reader.Read();
int idNegoVente = int.Parse(reader["idclient"].ToString());
connect.Close();
//Test si c'est le même négo
if (idNegoAcq != idNegoVente)
{
mandatPlusVente = false;
}
//Enregistrement des honoraires
enregistrerHonoraire(mandatPlusVente, idvente, honoraires, idNegoAcq, idNegoVente);
enregistrerFichiers(idvente.ToString());
Response.Redirect("./mesVentes.aspx?action=ajout");
//msg.Text ="Vente enregistrée.<br/><br/>";
}
public Database()
{
//Conn = new System.Data.Odbc.OdbcConnection("DSN=Phoenix;UID=fnmiuse1;PWD=fnmiuse1;");
Conn = new System.Data.Odbc.OdbcConnection("DSN=Phoenix_32;UID=fnmiuse1;PWD=fnmiuse1;");
Conn.ConnectionTimeout = 300;
}
public static ArrayList GetSSIMEdScheduleODBC(string _beginDate,
string _endDate, string _filter)
{
string _date = string.Empty;
int _account = 1001;
string _time = string.Empty;
string _provider = string.Empty;
string _chartNumber = string.Empty;
string _firstName = string.Empty;
string _lastName = string.Empty;
string _phone = string.Empty;
string _procedureCode = string.Empty;
string _location = string.Empty;
ArrayList items = new ArrayList();
using (OdbcConnection cn = new OdbcConnection(Database.SsimedConnection))
{
cn.Open();
using (OdbcCommand cm = cn.CreateCommand())
{
cm.CommandText = "SELECT A.DayDate_Date,A.account,A.TrackType,A.DayPhys,A.DayLoc,"
+ " A.Daytime,A.PFirst,A.PName,A.DayLoc,"
+ " B.Phone"
+ " FROM TDayAppt A, TPatMst B "
+ " where DayDate_Date BETWEEN '" + _beginDate + "' and '" + _endDate + "'"
+ " and A.account = B.account"
+ " and A.TrackType IN " + _filter
+ " AND CANCELNOSHOW = 'A'";
using (OdbcDataReader dr = cm.ExecuteReader())
{
while (dr.Read())
{
try
{
_date = dr.GetDateTime(0).ToShortDateString().Trim();
}
catch
{
_date = string.Empty;
}
try
{
_time = ConvertSSIMEDTime(double.Parse(dr["Daytime"].ToString().Trim()));
}
catch
{
_time = string.Empty;
}
try
{
_provider = GetProviderNameSSIMEDODBC(dr["DayPhys"].ToString().Trim());
}
catch
{
_provider = string.Empty;
}
try
{
_chartNumber = dr.GetString(1).Trim();
}
catch
{
_chartNumber = _account.ToString();
_account++;
}
try
{
_firstName = dr["PFirst"].ToString();
}
catch
{
_firstName = string.Empty;
}
try
{
_lastName = dr["PName"].ToString();
}
catch
{
_lastName = string.Empty;
}
try
{
_phone = dr["Phone"].ToString().Trim()
.Replace("(", "").Replace(")", "")
.Replace("-", "").Replace(" ", "");
}
catch
{
_phone = string.Empty;
}
try
{
_procedureCode = dr["TrackType"].ToString();
//_procedureCode = GetAppointmentReasonODBC(dr["TrackType"].ToString());
}
catch
{
_procedureCode = string.Empty;
}
try
{
_location = dr["DayLoc"].ToString();
}
catch
{
_location = string.Empty;
}
items.Add(_date + "~"
+ _time + "~"
+ _provider + "~"
+ _chartNumber + "~"
+ _firstName + "~"
+ _lastName + "~"
+ _phone + "~"
+ _location + "~"
+ _procedureCode + "~"
);
}
return items;
}
}
}
}
/**
* @brief Parameter Constructor
* Constructor that initialises the connection to the database and calls SetUser() function.
*
* @param int x
* @return
* @pre
* @post
*/
public DatabaseInterface(int x)
{
con = new OdbcConnection("Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=..\\KinesisArcade.mdb");
con.Open();
setUser();
}
/// <summary>
/// 更新 DBF 数据文件
/// </summary>
/// <param name="dt">需要插入的数据</param>
/// <param name="fileName">原始 DBF文件+路径</param>
/// <returns>-1为未找到原始DBF文件；-2为插入异常；1为插入成功</returns>
public int UpdateDBF(DataTable dt, string fileName)
{
int rtn = 0;
OdbcConnection ole_conn = new OdbcConnection();
string connStr = @"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + fileName + ";Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO";
try
{
ole_conn.ConnectionString = connStr;
// Log.WriteErrorLog("执行打开");
ole_conn.Open();
//Log.WriteErrorLog("打开");
if (File.Exists(fileName))
{
//已经存在则删除原有数据
OdbcCommand cmd1 = new OdbcCommand("DELETE FROM " + fileName, ole_conn);
rtn = cmd1.ExecuteNonQuery();
//Log.WriteErrorLog("开始导入数据");
//导入数据
string tname = fileName;
string colNames = "";
for (int i = 0; i < dt.Columns.Count; i++)
{
colNames += dt.Columns[i].ColumnName + ",";
}
colNames = colNames.TrimEnd(',');
string cmd = "";
string colValues;
string cmdmode = string.Format("insert into {0} ({1}) values({{0}});", tname, colNames);
// Log.WriteErrorLog("执行循环");
for (int i = 0; i < dt.Rows.Count; i++)
{
colValues = "";
for (int j = 0; j < dt.Columns.Count; j++)
{
if (dt.Rows[i][j].GetType() == typeof(DBNull))
{
colValues += "NULL,";
continue;
}
if (dt.Columns[j].DataType == typeof(string))
{
colValues += string.Format("'{0}',", dt.Rows[i][j]);
}
else if (dt.Columns[j].DataType == typeof(int) || dt.Columns[j].DataType == typeof(float) || dt.Columns[j].DataType == typeof(double) || dt.Columns[j].DataType == typeof(Decimal))
{
colValues += string.Format("{0},", dt.Rows[i][j]);
}
else if (dt.Columns[j].DataType == typeof(DateTime))
{
colValues += string.Format("cast('{0}' as datetime),", dt.Rows[i][j]);
}
else if (dt.Columns[j].DataType == typeof(bool))
{
colValues += string.Format("{0},", dt.Rows[i][j].ToString());
}
else
{
colValues += string.Format("{0},", dt.Rows[i][j]);
}
}
cmd = string.Format(cmdmode, colValues.TrimEnd(','));
OdbcCommand cmd2 = new OdbcCommand(cmd, ole_conn);
rtn = cmd2.ExecuteNonQuery();
// Log.WriteErrorLog("执行结束");
}
}
else
{
Log.WriteErrorLog("DBF 文件不存在", string.Format("UpdateDBF(DataTable dt, string fileName), dt:{0}, fileName:{1}", dt, fileName), "");
rtn = -1;
}
}
catch (System.Exception ex)
{
//Log.WriteErrorLog("异常");
rtn = -2;
Log.WriteErrorLog(ex.Message, string.Format("UpdateDBF(DataTable dt, string fileName), dt:{0}, fileName:{1}", dt, fileName), "");
#if DEBUG
throw ex;
#endif
}
if (ole_conn.State == ConnectionState.Open)
{
ole_conn.Close();
}
ole_conn.Dispose();
return(rtn);
}
public static List <Movimiento> TraerMovimientosPorIdExpediente(int idExpediente)
{
OdbcConnection conexion = new OdbcConnection(NegocioBase.getConnectionString());
OdbcDataAdapter dataAdapter = new OdbcDataAdapter("", conexion);
OdbcParameter parametro = new OdbcParameter();
dataAdapter.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure;
dataAdapter.SelectCommand.CommandText = "call sp_TraerMovimientosPorIdExpediente(?)";
parametro.ParameterName = "_idExpediente";
parametro.Value = idExpediente;
parametro.OdbcType = OdbcType.Int;
dataAdapter.SelectCommand.Parameters.Add(parametro);
List <Movimiento> listaMovimientos = new List <Movimiento>();
try
{
conexion.Open();
OdbcDataReader dr;
dr = dataAdapter.SelectCommand.ExecuteReader();
while (dr.Read())
{
Movimiento tmp = new Movimiento();
tmp.idExpediente = dr.GetInt32(0);
tmp.idMovimiento = dr.GetByte(1);
tmp.idTipoMovimiento = dr.GetByte(2);
tmp.fechaMovimiento = dr.GetDate(3);
tmp.idPersona = dr.GetByte(4);
if (!dr.IsDBNull(5))
{
tmp.comentario = dr.GetString(5);
}
else
{
tmp.comentario = "";
}
tmp.realizado = dr.GetByte(6);
listaMovimientos.Add(tmp);
}
dr.Close();
return(listaMovimientos);
}
catch
{
throw;
}
finally
{
if (conexion.State == System.Data.ConnectionState.Open)
{
conexion.Close();
}
}
}
public static void Eliminar(Movimiento movimiento, DetalleMovimiento detalleMovimiento, ExpedienteMVL expedienteMVL)
{
OdbcConnection conexion = new OdbcConnection(NegocioBase.getConnectionString());
OdbcParameter parametro = new OdbcParameter();
OdbcTransaction transaccion;
OdbcCommand comando = new OdbcCommand();
try
{
comando.Connection = conexion;
comando.CommandType = CommandType.StoredProcedure;
comando.CommandText = "call SP_BorrarDetalleMovimiento(?,?)";
comando.Parameters.AddWithValue("_idExpediente", detalleMovimiento.idExpediente);
comando.Parameters.AddWithValue("_idMovimiento", detalleMovimiento.idMovimiento);
conexion.Open();
transaccion = conexion.BeginTransaction();
comando.Transaction = transaccion;
comando.ExecuteNonQuery();
if (expedienteMVL.accion == ExpedienteMVL.eAccion.Eliminar)
{
comando.Parameters.Clear();
comando.CommandText = "call SP_BorrarExpedienteMVL(?,?)";
comando.Parameters.AddWithValue("_idExpediente", expedienteMVL.idExpediente);
comando.Parameters.AddWithValue("_idMovimientoSolicitud", expedienteMVL.idMovimiento);
comando.ExecuteNonQuery();
}
if (expedienteMVL.accion == ExpedienteMVL.eAccion.Modificar)
{
comando.Parameters.Clear();
comando.CommandText = "call SP_ModificarExpedienteMVL(?,?,?,?,?,?,?)";
comando.Parameters.AddWithValue("_idExpediente", expedienteMVL.idExpediente);
comando.Parameters.AddWithValue("_idMovimientoSolicitud", expedienteMVL.idMovimiento);
comando.Parameters.AddWithValue("_idMovimientoRecepcion", expedienteMVL.idMovimientoRecepcion);
comando.Parameters.AddWithValue("_idMovimientoDevolucion", expedienteMVL.idMovimientoDevolucion);
comando.Parameters.AddWithValue("_codigoExpedienteMVL", expedienteMVL.codigoExpedienteMVL);
comando.Parameters.AddWithValue("_numeroExpedienteMVL", expedienteMVL.numeroExpedienteMVL);
comando.Parameters.AddWithValue("_anioExpediente", expedienteMVL.anioExpediente);
comando.ExecuteNonQuery();
}
comando.Parameters.Clear();
comando.CommandText = "call SP_BorrarMovimiento(?,?)";
comando.Parameters.AddWithValue("_idExpediente", movimiento.idExpediente);
comando.Parameters.AddWithValue("_idMovimiento", movimiento.idMovimiento);
comando.ExecuteNonQuery();
transaccion.Commit();
conexion.Close();
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conexion.State == ConnectionState.Open)
{
conexion.Close();
}
}
}
public static void Modificar(Movimiento movimiento, DetalleMovimiento detalleMovimiento, ExpedienteMVL expedienteMVL, Expediente expediente)
{
OdbcConnection conexion = new OdbcConnection(NegocioBase.getConnectionString());
OdbcParameter parametro = new OdbcParameter();
OdbcTransaction transaccion;
OdbcCommand comando = new OdbcCommand();
try
{
comando.Connection = conexion;
comando.CommandType = CommandType.StoredProcedure;
comando.CommandText = "call SP_BorrarDetalleMovimiento(?,?)";
comando.Parameters.AddWithValue("_idExpediente", detalleMovimiento.idExpediente);
comando.Parameters.AddWithValue("_idMovimiento", detalleMovimiento.idMovimiento);
conexion.Open();
transaccion = conexion.BeginTransaction();
comando.Transaction = transaccion;
comando.ExecuteNonQuery();
comando.Parameters.Clear();
comando.CommandText = "call SP_BorrarExpedienteMVL(?,?)";
comando.Parameters.AddWithValue("_idExpediente", expedienteMVL.idExpediente);
comando.Parameters.AddWithValue("_idMovimientoSolicitud", expedienteMVL.idMovimiento);
comando.ExecuteNonQuery();
comando.Parameters.Clear();
comando.CommandText = "call SP_BorrarMovimiento(?,?)";
comando.Parameters.AddWithValue("_idExpediente", movimiento.idExpediente);
comando.Parameters.AddWithValue("_idMovimiento", movimiento.idMovimiento);
comando.ExecuteNonQuery();
comando.Parameters.Clear();
comando.CommandText = "call SP_InsertarMovimientos(?,?,?,?,?,?,?)";
comando.Parameters.AddWithValue("_idExpediente", movimiento.idExpediente);
comando.Parameters.AddWithValue("_idMovimiento", movimiento.idMovimiento);
comando.Parameters.AddWithValue("_idTipoMovimiento", movimiento.idTipoMovimiento);
comando.Parameters.AddWithValue("_fechaMovimiento", movimiento.fechaMovimiento);
comando.Parameters.AddWithValue("_idPersona", movimiento.idPersona);
comando.Parameters.AddWithValue("_comentario", movimiento.comentario);
comando.Parameters.AddWithValue("_realizado", movimiento.realizado);
comando.ExecuteNonQuery();
if (detalleMovimiento.idExpediente != 0)
{
comando.Parameters.Clear();
comando.CommandText = "call SP_InsertarDetalleMovimientos(?,?,?,?,?)";
comando.Parameters.AddWithValue("_idExpediente", detalleMovimiento.idExpediente);
comando.Parameters.AddWithValue("_idMovimiento", detalleMovimiento.idMovimiento);
comando.Parameters.AddWithValue("_nombreArchivo", detalleMovimiento.nombreArchivo);
comando.Parameters.AddWithValue("_numeroResolucion", detalleMovimiento.numeroResolucion);
comando.Parameters.AddWithValue("_idDependencia", detalleMovimiento.idDependencia);
comando.ExecuteNonQuery();
}
if (expedienteMVL.idExpediente != 0)
{
comando.Parameters.Clear();
comando.CommandText = "call SP_InsertarExpedienteMVL(?,?,?,?,?,?,?)";
comando.Parameters.AddWithValue("_idExpediente", expedienteMVL.idExpediente);
comando.Parameters.AddWithValue("_idMovimientoSolicitud", expedienteMVL.idMovimiento);
comando.Parameters.AddWithValue("_idMovimientoRecepcion", expedienteMVL.idMovimientoRecepcion);
comando.Parameters.AddWithValue("_idMovimientoDevolucion", expedienteMVL.idMovimientoDevolucion);
comando.Parameters.AddWithValue("_codigoExpedienteMVL", expedienteMVL.codigoExpedienteMVL);
comando.Parameters.AddWithValue("_numeroExpedienteMVL", expedienteMVL.numeroExpedienteMVL);
comando.Parameters.AddWithValue("_anioExpediente", expedienteMVL.anioExpediente);
comando.ExecuteNonQuery();
}
// Agregado Nico
if (expediente.informante.idPersona != 0)
{
comando.Parameters.Clear();
comando.CommandText = "call SP_actualizarInformante(?,?)";
comando.Parameters.AddWithValue("_idExpediente", expediente.idExpediente);
comando.Parameters.AddWithValue("_idInformante", expediente.informante.idPersona);
comando.ExecuteNonQuery();
}
if (expediente.fin.idFin != 0 || expediente.fechaArchivo.CompareTo(System.DateTime.MinValue) != 0)
{
comando.Parameters.Clear();
comando.CommandText = "call SP_actualizarExpedienteArchivoFin(?,?,?)";
comando.Parameters.AddWithValue("_idExpediente", expediente.idExpediente);
comando.Parameters.AddWithValue("_idFin", expediente.fin.idFin);
comando.Parameters.AddWithValue("_fechaArchivo", expediente.fechaArchivo);
comando.ExecuteNonQuery();
}
//
transaccion.Commit();
conexion.Close();
}
catch (Exception ex)
{
throw ex;
}
}
// be able to open and swith database connections
public void Open(Database database)
{
// open db when designating with another arguments
if (this.database != database)
{
this.database = database;
switch (database)
{
case Database.CMSDAT:
user = "******"; //user = "******";
password = "******"; //password = "******";
connectionString = "Driver={iSeries Access ODBC Driver};Name=cms1;System=10.0.0.35;Uid=" + user + ";Pwd=" + password + ";";
dbName = "cmsdat";
break;
case Database.PRODTEST:
user = "******"; //user = "******";
password = "******"; //password = "******";
connectionString = "Driver={iSeries Access ODBC Driver};Name=cms1;System=10.0.0.35;Uid=" + user + ";Pwd=" + password + ";";
dbName = "prodtest";
break;
case Database.DECADE_MARKHAM:
user = "******";
password = "******";
connectionString = "Driver={SQL Server};Server=10.0.0.6;Uid=" + user + ";Pwd=" + password + ";";
dbName = "dbo";
break;
case Database.DECADE_MICHIGAN:
user = "******";
password = "******";
connectionString = "Driver={SQL Server};Server=192.168.1.7;Uid=" + user + ";Pwd=" + password + ";";
dbName = "dbo";
break;
case Database.DECADE_TEXAS:
user = "******";
password = "******";
connectionString = "Driver={SQL Server};Server=192.168.12.7;Uid=" + user + ";Pwd=" + password + ";";
dbName = "dbo";
break;
case Database.DECADE_COLOMBIA:
user = "******";
password = "******";
connectionString = "Driver={SQL Server};Server=192.168.101.7;Uid=" + user + ";Pwd=" + password + ";";
dbName = "dbo";
break;
case Database.DECADE_BRAZIL:
user = "******";
password = "******";
connectionString = "Driver={SQL Server};Server=192.168.16.7;Uid=" + user + ";Pwd=" + password + ";";
dbName = "dbo";
break;
default:
throw new Exception("Unhandled database!");
}
if (null == connection)
{
connection = new OdbcConnection(connectionString);
}
else
{
connection.Close();
connection.ConnectionString = connectionString;
}
//connection.ConnectionTimeout = int.MaxValue;
connection.Open();
if (null == command)
{
command = new OdbcCommand();
}
command.Connection = connection;
command.CommandTimeout = 0;
}
}
/// <summary>
/// ODBCRecordsetClass Constructor: initialize internal variables,
/// the connection is initialized using the connection string, and
/// the query uses the sqlSelectString.
/// </summary>
/// <param name="connString"></param>
/// <param name="sqlSelectString"></param>
public ODBCRecordsetClass(String connString, String sqlSelectString)
{
this.dbConnection = new OdbcConnection(connString);
this.SqlQuery = sqlSelectString;
this.operationFinished = false;
this.dbAdapter = CreateAdapter(SqlQuery, dbConnection);
this.dbDataSet = new DataSet();
this.dbTable = new DataTable();
this.dbTable = dbDataSet.Tables.Add("Table");
this.dbAdapter.Fill(this.dbTable);
CheckUpdateCommandsFromMetaData();
this.operationFinished = true;
this.newRow = false;
this.foundRecordsCounter = 0;
this.OnAfterQuery();
classFields = new FieldsClass(this);
SetInitialPosition();
}
private void Form1_Load(object sender, EventArgs e)
{
/*dataGridView1.Columns.Add("PK_Api_codigo", "codigo");
* dataGridView1.Columns.Add("api_descripcion", "name");
* dataGridView1.Columns.Add("FK_Codigo_modulo", "mod");
* dataGridView1.Columns.Add("status", "sta");
*
* dataGridView1.Rows.Add("1", "Ramos", "1", "1");
* dataGridView1.Rows.Add("2", "Ramoas", "2", "1");
* dataGridView1.Rows.Add("3", "Ramosb", "1", "1");
* dataGridView1.Rows.Add("4", "Ramosc", "2", "1");*/
DataSet ds = new DataSet();
try
{
using (var conn = new OdbcConnection("dsn=colchoneria"))
{
conn.Open();
{
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "SELECT * FROM tbl_aplicacion";
OdbcDataAdapter m_datos = new OdbcDataAdapter(cmd);
ds = new DataSet();
m_datos.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
}
}
conn.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
DataTable Dt = new DataTable();
Dt = (DataTable)dataGridView1.DataSource; // Se crea un datatable que contenga los datos del data grid
DLL__Reporteador.Visualizador vp = new Visualizador();
Prueba pp = new Prueba();
//vp.generarReporte(Dt, pp);
AdministradorDeReportes frm = new AdministradorDeReportes();
frm.getDatosNecesariosParaReportes2(Dt, pp);
/*MySqlConnection conexion = new MySqlConnection("Server=localhost; User Id=root; Password='******'; Database=nombre_de_la_BD");
*
* ------------------------------------------------- ----
*
* Luego en el evento Load del Form carga los datos al DataGridView:
*
* MySqlDataAdapter da = new MySqlDataAdapter("select * from CLIENTE", conexion);
* DataSet ds = new DataSet();
* da.Fill(ds);
* dataGridView1.DataSource = ds.Tables[0];*/
}
public static string GetAppointmentReasonODBC(string _appointmentCode)
{
using (OdbcConnection cn = new OdbcConnection(Database.SsimedConnection))
{
cn.Open();
using (OdbcCommand cm = cn.CreateCommand())
{
cm.CommandText = "SELECT DESCRIPTION FROM TTypeAppt where TYPECODE = '" + _appointmentCode + "'";
using (OdbcDataReader dr = cm.ExecuteReader())
{
dr.Read();
return dr.GetString(0).Trim();
}
}
}
}
static void Main(string[] args)
{
string destPath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "LocalDriveToNetDrive.ini");
if (File.Exists(destPath))
{
string[] lines = File.ReadAllLines(destPath);
foreach (string line in lines)
{
if (line.Contains("netFoler:"))
{
netFoler = line.Replace("netFoler:", "");
}
if (line.Contains("connStrSms:"))
{
connStrSms = line.Replace("connStrSms:", "");
}
if (line.Contains("frequency:"))
{
frequency = line.Replace("frequency:", "");
}
}
}
else
{
File.WriteAllText(destPath, "netFoler:" + netFoler + Environment.NewLine + "connStrSms:" + connStrSms + Environment.NewLine + "frequency:" + frequency + Environment.NewLine);
}
OdbcConnection connSms = new OdbcConnection(connStrSms);
connSms.Open();
while (true)
{
try
{
if (connSms.State == System.Data.ConnectionState.Closed)
{
connSms.Open();
}
string sql = "select system_value from system where system_code = 'FILEFOLDER'";
OdbcCommand commSms = new OdbcCommand(sql, connSms);
OdbcDataReader dbrd = commSms.ExecuteReader();
string filefolder = "";
if (dbrd.HasRows && dbrd.Read())
{
filefolder = dbrd[0].ToString();
}
Directory.CreateDirectory(filefolder);
Directory.CreateDirectory(netFoler);
foreach (string dirPath in Directory.GetDirectories(filefolder, "*", SearchOption.AllDirectories))
{
Directory.CreateDirectory(dirPath.Replace(filefolder, netFoler));
}
foreach (string newPath in Directory.GetFiles(filefolder, "*.*", SearchOption.AllDirectories))
{
File.Copy(newPath, newPath.Replace(filefolder, netFoler), true);
}
System.IO.DirectoryInfo di = new DirectoryInfo(filefolder);
foreach (FileInfo file in di.GetFiles())
{
file.Delete();
}
foreach (DirectoryInfo dir in di.GetDirectories())
{
dir.Delete(true);
}
di.Attributes &= ~FileAttributes.ReadOnly;
Thread.Sleep(int.Parse(frequency) * 1000);
}
catch (Exception e)
{
string logPath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "LocalDriveToNetDrive.Error.log");
File.AppendAllText(logPath, System.DateTime.Now + ": " + e + Environment.NewLine);
Thread.Sleep(int.Parse(frequency) * 1000);
}
}
}
//Execute query on appropriate database based on the configured data source
private DataSet ExecuteQuery(string query)
{
DataSet ds = new DataSet();
status.Code = RequestStatus.StatusCode.InProgress;
string server = Settings.GetAsString("Server", "");
string port = Settings.GetAsString("Port", "");
string userId = Settings.GetAsString("UserID", "");
string password = Settings.GetAsString("Password", "");
string database = Settings.GetAsString("Database", "");
string dataSourceName = Settings.GetAsString("DataSourceName", "");
string connectionTimeout = Settings.GetAsString("ConnectionTimeout", "15");
string commandTimeout = Settings.GetAsString("CommandTimeout", "120");
log.Debug("Connection timeout: " + connectionTimeout + ", Command timeout: " + commandTimeout);
log.Debug("Executing Query: " + query);
if (!Settings.ContainsKey("DataProvider"))
{
throw new Exception(CommonMessages.Exception_MissingDataProviderType);
}
string connectionString = string.Empty;
switch ((Lpp.Dns.DataMart.Model.Settings.SQLProvider)Enum.Parse(typeof(Lpp.Dns.DataMart.Model.Settings.SQLProvider), Settings.GetAsString("DataProvider", ""), true))
{
case Lpp.Dns.DataMart.Model.Settings.SQLProvider.ODBC:
if (string.IsNullOrEmpty(dataSourceName))
{
throw new Exception(CommonMessages.Exception_MissingODBCDatasourceName);
}
using (OdbcConnection connection = new OdbcConnection(string.Format("DSN={0}", dataSourceName)))
try
{
OdbcDataAdapter da = new OdbcDataAdapter(query, connection);
da.Fill(ds);
}
finally
{
connection.Close();
}
break;
case Lpp.Dns.DataMart.Model.Settings.SQLProvider.SQLServer:
if (string.IsNullOrEmpty(server))
{
throw new Exception(CommonMessages.Exception_MissingDatabaseServer);
}
if (string.IsNullOrEmpty(database))
{
throw new Exception(CommonMessages.Exception_MissingDatabaseName);
}
if (!string.IsNullOrEmpty(userId) && string.IsNullOrEmpty(password))
{
throw new Exception(CommonMessages.Exception_MissingDatabasePassword);
}
if (port != null && port != string.Empty)
{
server += ", " + port;
}
connectionString = userId != null && userId != string.Empty ? String.Format("server={0};User ID={1};Password={2};Database={3}; Connection Timeout={4}", server, userId, password, database, connectionTimeout) :
String.Format("server={0};integrated security=True;Database={1}; Connection Timeout={2}", server, database, connectionTimeout);
using (System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection(connectionString))
{
try
{
connection.Open();
System.Data.SqlClient.SqlCommand command = new System.Data.SqlClient.SqlCommand(query, connection);
command.CommandTimeout = int.Parse(commandTimeout);
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(command);
da.Fill(ds);
}
finally
{
connection.Close();
}
}
break;
default:
throw new Exception(CommonMessages.Exception_InvalidDataProviderType);
}
status.Code = RequestStatus.StatusCode.Complete;
status.Message = "";
return(ds);
}
//
// MembershipProvider.FindUsersByEmail
//
public override MembershipUserCollection FindUsersByEmail(string emailToMatch, int pageIndex, int pageSize, out int totalRecords)
{
OdbcConnection conn = new OdbcConnection(connectionString);
OdbcCommand cmd = new OdbcCommand("SELECT Count(*) FROM Users " +
"WHERE Email LIKE ? AND ApplicationName = ?", conn);
cmd.Parameters.Add("@EmailSearch", OdbcType.VarChar, 255).Value = emailToMatch;
cmd.Parameters.Add("@ApplicationName", OdbcType.VarChar, 255).Value = ApplicationName;
MembershipUserCollection users = new MembershipUserCollection();
OdbcDataReader reader = null;
totalRecords = 0;
try {
conn.Open();
totalRecords = (int)cmd.ExecuteScalar();
if (totalRecords <= 0)
{
return(users);
}
cmd.CommandText = "SELECT PKID, Username, Email, PasswordQuestion," +
" Comment, IsApproved, IsLockedOut, CreationDate, LastLoginDate," +
" LastActivityDate, LastPasswordChangedDate, LastLockedOutDate " +
" FROM Users " +
" WHERE Email LIKE ? AND ApplicationName = ? " +
" ORDER BY Username Asc";
reader = cmd.ExecuteReader();
int counter = 0;
int startIndex = pageSize * pageIndex;
int endIndex = startIndex + pageSize - 1;
while (reader.Read())
{
if (counter >= startIndex)
{
MembershipUser u = GetUserFromReader(reader);
users.Add(u);
}
if (counter >= endIndex)
{
cmd.Cancel();
}
counter++;
}
}
catch (OdbcException e) {
if (WriteExceptionsToEventLog)
{
WriteToEventLog(e, "FindUsersByEmail");
throw new ProviderException(exceptionMessage);
}
else
{
throw e;
}
}
finally {
if (reader != null)
{
reader.Close();
}
conn.Close();
}
return(users);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["ref"] == null)
{
Response.Redirect("./moncomptetableaudebord_bis.aspx");
}
Membre member = (Membre)Session["Membre"];
if (member != null && (member.STATUT != "nego" || member.STATUT != "ultranego"))
{
}
else
{
Response.Redirect("./moncomptetableaudebord_bis.aspx");
}
isAdmin = (member.STATUT == "ultranego");
Connexion c = new Connexion(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
c.Open();
try
{
bien = c.exeRequetteOpen("SELECT * FROM Biens WHERE ref='" + Request.QueryString["ref"] + "'").Tables[0].Rows[0];
}
catch
{
Response.Redirect("./moncomptetableaudebord_bis.aspx");
c.Close();
}
if (!IsPostBack)
{
int idNego = (int)bien["idclient"];
int honoraire = (int)bien["honoraires"];
int prix = (int)bien["prix de vente"];
((Label)Page.Master.FindControl("titrebandeau")).Text = "Proposer vente";
//refBien.Text = Request.QueryString["ref"];
TextBoxHonoraires.Text = honoraire.ToString();
TextBoxPrix.Text = prix.ToString();
TextBoxSequestre.Text = ((int)(int.Parse(TextBoxPrix.Text) * 5 / 100)).ToString();
string codeiso = Code_iso("negomandat");
DataRow negoMandat = c.exeRequetteOpen("SELECT Clients.* FROM Clients,Biens WHERE Biens.idclient = Clients.idclient AND Biens.ref = '" + Request.QueryString["ref"] + "'").Tables[0].Rows[0];
nego.Text = negoMandat["prenom_client"].ToString() + " " + negoMandat["nom_client"].ToString().ToUpper();
negoadresse.Text = "<img height='20px' src='../img_site/drapeau/" + codeiso + ".png'/>" + "<div class='tooltip'><span>" + "<img height='50px' src='../img_site/drapeau/" + codeiso + ".png'/></span></div>" + " " + "<a href='https://www.google.fr/maps/place/" + negoMandat["adresse_client"] + " " + negoMandat["ville_client"].ToString() + "' target='_blank'><img style='cursor:pointer' src='../img_site/flat_round/monde.png' height='20px'/></a>" + " " + negoMandat["adresse_client"].ToString() + "<br/>" + " " + negoMandat["postal_client"].ToString() + ", " + negoMandat["ville_client"].ToString();
negoTel.Text = negoMandat["tel_client"].ToString();
negoMail.Text = "<a href='mailto:" + negoMandat["id_client"] + "'>" + negoMandat["id_client"] + "</a>";
string temp = DropDownListAcq.SelectedValue;
string temp2 = DropDownListNotaire.SelectedValue;
string req;
string req2;
if (member.STATUT == "ultranego")
{
req = "SELECT id_acq,nom,prenom,tel,mail,code_postal,ville,idclient,adresse,pays FROM Acquereurs WHERE actif='actif' ORDER BY Nom ASC";
req2 = "SELECT id_notaire,nom,prenom,adresse,code_postal,ville,mail,telephone,pays,fax FROM Notaires ORDER BY Nom ASC";
}
else
{
req = "SELECT id_acq,nom,prenom,tel,mail,code_postal,ville,idclient,adresse,pays FROM Acquereurs WHERE actif='actif' AND idclient = " + member.IDCLIENT + " ORDER BY Nom ASC";
req2 = "SELECT Notaires.id_notaire,nom,prenom,adresse,code_postal,ville,mail,telephone,pays,fax FROM Notaires INNER JOIN lien_clients_notaires ON lien_clients_notaires.id_notaire=Notaires.id_notaire WHERE lien_clients_notaires.id_client = " + member.IDCLIENT + " ORDER BY Nom ASC";
}
DataRowCollection listeAcquereur = c.exeRequetteOpen(req).Tables[0].Rows;
foreach (DataRow acq in listeAcquereur)
{
string nomnegoacq = null, prenomnegoacq = null;
string idacq = acq["id_acq"].ToString();
req = "SELECT Clients.nom_client, Clients.prenom_client FROM Acquereurs INNER JOIN Clients ON Acquereurs.idclient = Clients.idclient WHERE ((Acquereurs.id_acq)=" + idacq + ")";
OdbcConnection connect = new OdbcConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
OdbcCommand requet = new OdbcCommand(req, connect);
connect.Open();
OdbcDataReader read = requet.ExecuteReader();
while (read.Read())
{
nomnegoacq = read["nom_client"].ToString().ToUpper();
prenomnegoacq = read["prenom_client"].ToString();
}
connect.Close();
ListItem x = new ListItem(acq["nom"].ToString().ToUpper() + " " + acq["prenom"].ToString() + " (" + acq["ville"].ToString() + " - " + acq["code_postal"].ToString() + ") | négo associé: " + nomnegoacq + " " + prenomnegoacq);
x.Attributes["tel"] = acq["tel"].ToString();
x.Attributes["mail"] = acq["mail"].ToString();
x.Attributes["idclient"] = acq["idclient"].ToString();
x.Attributes["nom"] = acq["nom"].ToString().ToUpper();
x.Attributes["prenom"] = acq["prenom"].ToString();
x.Attributes["adresse"] = acq["adresse"].ToString();
x.Attributes["ville"] = acq["ville"].ToString();
x.Attributes["code_postal"] = acq["code_postal"].ToString();
x.Attributes["pays"] = acq["pays"].ToString().ToUpper();
x.Value = acq["id_acq"].ToString();
req = "SELECT Pays.codeiso FROM Pays WHERE ((Pays.Titre_Pays)='" + acq["pays"].ToString() + "')";
OdbcConnection connection = new OdbcConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
OdbcCommand requette = new OdbcCommand(req, connection);
connection.Open();
OdbcDataReader reader = requette.ExecuteReader();
reader.Read();
x.Attributes["codeiso"] = reader["codeiso"].ToString();
connection.Close();
DropDownListAcq.Items.Add(x);
}
if (Request.QueryString["acq"] != null)
{
DropDownListAcq.SelectedValue = Request.QueryString["acq"];
nomacquereur.Text = DropDownListAcq.SelectedItem.Attributes["nom"] + " " + DropDownListAcq.SelectedItem.Attributes["prenom"];
}
InformationNegoAcquereur();
DataRowCollection listeNotaire = c.exeRequetteOpen(req2).Tables[0].Rows;
foreach (DataRow not in listeNotaire)
{
ListItem y = new ListItem(not["nom"].ToString().ToUpper() + ", " + not["prenom"].ToString() + " (" + not["ville"].ToString() + " - " + not["code_postal"].ToString() + ")", not["id_notaire"].ToString());
y.Attributes["nom"] = not["nom"].ToString().ToUpper();
y.Attributes["prenom"] = not["prenom"].ToString();
y.Attributes["adresse"] = not["adresse"].ToString();
y.Attributes["code_postal"] = not["code_postal"].ToString();
y.Attributes["ville"] = not["ville"].ToString();
y.Attributes["mail"] = not["mail"].ToString();
y.Attributes["telephone"] = not["telephone"].ToString();
y.Attributes["pays"] = not["pays"].ToString().ToUpper();
y.Attributes["fax"] = not["fax"].ToString();
y.Attributes["id_notaire"] = not["id_notaire"].ToString();
if (not["pays"].ToString() != "")
{
req = "SELECT Pays.codeiso FROM Pays WHERE ((Pays.Titre_Pays)='" + not["pays"].ToString() + "')";
//
OdbcConnection connection = new OdbcConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
OdbcCommand requette = new OdbcCommand(req, connection);
connection.Open();
OdbcDataReader reader = requette.ExecuteReader();
reader.Read();
y.Attributes["codeiso"] = reader["codeiso"].ToString();
connection.Close();
}
DropDownListNotaire.Items.Add(y);
}
DropDownListNotaire.SelectedValue = temp2;
if (Request.QueryString["id"] != null) //Consultation d'une fiche vente
{
System.Data.DataSet ds2 = c.exeRequetteOpen("Select * from Environnement");
String racine_site = (String)ds2.Tables[0].Rows[0]["Chemin_racine_site"];
string filePathActe = racine_site + "Ventes\\" + Request.QueryString["id"] + "_acte.pdf";
string filePathPromesse = racine_site + "Ventes\\" + Request.QueryString["id"] + "_promesse.pdf";
if (System.IO.File.Exists(filePathPromesse))
{
oldPromesse.Text = "<span id='newPromesse'><a href='../Ventes/" + Request.QueryString["id"] + "_promesse.pdf' target='_blank'>Voir Fichier</a></span>";
filePromesse.Attributes["style"] += ";width: 140px;color:white;";
}
if (System.IO.File.Exists(filePathActe))
{
oldActe.Text = "<span id='newActe'><a href='../Ventes/" + Request.QueryString["id"] + "_acte.pdf' target='_blank'>Voir Fichier</a></span>";
fileActe.Attributes["style"] += ";width: 140px;color:white;";
}
string val = "";
if (Request.QueryString["id"] != null)
{
val = Request.QueryString["id"];
}
else
if (Request.QueryString["acq"] != null)
{
val = Request.QueryString["acq"];
}
DataRow vente = c.exeRequetteOpen("SELECT * FROM Ventes WHERE ID =" + val).Tables[0].Rows[0];
bool venteValidee = (bool)vente["valider_signature"];
DropDownListAcq.SelectedValue = vente["id_acquereur"].ToString();
ratioNegoMandat.Text = ((double)vente["taux_mandat"] * 100).ToString();
ratioNegoVente.Text = ((double)vente["taux_vente"] * 100).ToString();
TextBoxPrix.Text = vente["prix_vente"].ToString();
TextBoxSequestre.Text = vente["sequestre"].ToString();
TextBoxHonoraires.Text = vente["commission"].ToString();
// il faudrait plutot recuperer les infos du notaire dans la table notaire ..
notaireNom.Text = vente["nom_notaire"].ToString();
notairePrenom.Text = vente["prenom_notaire"].ToString();
notaireAdresse.Text = vente["adresse_notaire"].ToString();
notaireCPetville.Text = vente["cp_notaire"].ToString() + ", " + vente["ville_notaire"].ToString();
notaireTel.Text = vente["tel_notaire"].ToString();
notaireMail.Text = vente["mail_notaire"].ToString();
TextBoxDateCompromis.Text = vente["date_compromis"].ToString().Split(' ')[0];
TextBoxDateSignature.Text = vente["date_signature"].ToString().Split(' ')[0];
int idNegoMandataire = (int)vente["id_nego"];
int idNegoVente = (int)c.exeRequetteOpen("SELECT idclient FROM Acquereurs WHERE id_acq = " + vente["id_acquereur"].ToString()).Tables[0].Rows[0]["idclient"];
saveVente.Visible = false;
if ((!venteValidee && member.IDCLIENT == idNegoMandataire) || (!venteValidee && member.IDCLIENT == idNegoVente) || member.STATUT == "ultranego")
{
updateVente.Visible = true;
}
else
{
edit = false;
if (venteValidee)
{
msg.Text = "Vente validée, aucune modification possible.<br/>";
}
}
}
c.Close();
remplirTableauBien(Request.QueryString["ref"]);
}
}
void UpdateFailureCount(string username, string failureType)
{
OdbcConnection conn = new OdbcConnection(connectionString);
OdbcCommand cmd = new OdbcCommand("SELECT FailedPasswordAttemptCount, " +
" FailedPasswordAttemptWindowStart, " +
" FailedPasswordAnswerAttemptCount, " +
" FailedPasswordAnswerAttemptWindowStart " +
" FROM Users " +
" WHERE Username = ? AND ApplicationName = ?", conn);
cmd.Parameters.Add("@Username", OdbcType.VarChar, 255).Value = username;
cmd.Parameters.Add("@ApplicationName", OdbcType.VarChar, 255).Value = ApplicationName;
OdbcDataReader reader = null;
DateTime windowStart = new DateTime();
int failureCount = 0;
try {
conn.Open();
reader = cmd.ExecuteReader(CommandBehavior.SingleRow);
if (reader.HasRows)
{
reader.Read();
if (failureType == "password")
{
failureCount = reader.GetInt32(0);
windowStart = reader.GetDateTime(1);
}
if (failureType == "passwordAnswer")
{
failureCount = reader.GetInt32(2);
windowStart = reader.GetDateTime(3);
}
}
reader.Close();
DateTime windowEnd = windowStart.AddMinutes(PasswordAttemptWindow);
if (failureCount == 0 || DateTime.Now > windowEnd)
{
// First password failure or outside of PasswordAttemptWindow.
// Start a new password failure count from 1 and a new window starting now.
if (failureType == "password")
{
cmd.CommandText = "UPDATE Users " +
" SET FailedPasswordAttemptCount = ?, " +
" FailedPasswordAttemptWindowStart = ? " +
" WHERE Username = ? AND ApplicationName = ?";
}
if (failureType == "passwordAnswer")
{
cmd.CommandText = "UPDATE Users " +
" SET FailedPasswordAnswerAttemptCount = ?, " +
" FailedPasswordAnswerAttemptWindowStart = ? " +
" WHERE Username = ? AND ApplicationName = ?";
}
cmd.Parameters.Clear();
cmd.Parameters.Add("@Count", OdbcType.Int).Value = 1;
cmd.Parameters.Add("@WindowStart", OdbcType.DateTime).Value = DateTime.Now;
cmd.Parameters.Add("@Username", OdbcType.VarChar, 255).Value = username;
cmd.Parameters.Add("@ApplicationName", OdbcType.VarChar, 255).Value = ApplicationName;
if (cmd.ExecuteNonQuery() < 0)
{
throw new ProviderException("Unable to update failure count and window start.");
}
}
else
{
if (failureCount++ >= MaxInvalidPasswordAttempts)
{
// Password attempts have exceeded the failure threshold. Lock out
// the user.
cmd.CommandText = "UPDATE Users " +
" SET IsLockedOut = ?, LastLockedOutDate = ? " +
" WHERE Username = ? AND ApplicationName = ?";
cmd.Parameters.Clear();
cmd.Parameters.Add("@IsLockedOut", OdbcType.Bit).Value = true;
cmd.Parameters.Add("@LastLockedOutDate", OdbcType.DateTime).Value = DateTime.Now;
cmd.Parameters.Add("@Username", OdbcType.VarChar, 255).Value = username;
cmd.Parameters.Add("@ApplicationName", OdbcType.VarChar, 255).Value = ApplicationName;
if (cmd.ExecuteNonQuery() < 0)
{
throw new ProviderException("Unable to lock out user.");
}
}
else
{
// Password attempts have not exceeded the failure threshold. Update
// the failure counts. Leave the window the same.
if (failureType == "password")
{
cmd.CommandText = "UPDATE Users " +
" SET FailedPasswordAttemptCount = ?" +
" WHERE Username = ? AND ApplicationName = ?";
}
if (failureType == "passwordAnswer")
{
cmd.CommandText = "UPDATE Users " +
" SET FailedPasswordAnswerAttemptCount = ?" +
" WHERE Username = ? AND ApplicationName = ?";
}
cmd.Parameters.Clear();
cmd.Parameters.Add("@Count", OdbcType.Int).Value = failureCount;
cmd.Parameters.Add("@Username", OdbcType.VarChar, 255).Value = username;
cmd.Parameters.Add("@ApplicationName", OdbcType.VarChar, 255).Value = ApplicationName;
if (cmd.ExecuteNonQuery() < 0)
{
throw new ProviderException("Unable to update failure count.");
}
}
}
}
catch (OdbcException e) {
if (WriteExceptionsToEventLog)
{
WriteToEventLog(e, "UpdateFailureCount");
throw new ProviderException(exceptionMessage);
}
else
{
throw e;
}
}
finally {
if (reader != null)
{
reader.Close();
}
conn.Close();
}
}
public ArrayList SelectAry(string Sql)
{
OdbcConnection Conn = getConnection();
OdbcCommand cmd;
OdbcDataReader DaRd;
int i = 0;
int col = 0;
string str;
ArrStr = new ArrayList();
TotCnt = 0;
ActCnt = 0;
RtnCnt = 0;
try
{
cmd = new OdbcCommand(Sql, Conn);
cmd.CommandTimeout = 6000;
DaRd = cmd.ExecuteReader();
col = DaRd.FieldCount;
string cnm = "";
for (i = 0; i < col; i++)
{
cnm += DaRd.GetName(i) + ",";
}
while (DaRd.Read())
{
TotCnt++;
if (TotCnt >= FstCnt)
{
ActCnt++;
if ((SelCnt != 0) && (ActCnt > SelCnt))
{
break;
}
str = "";
try
{
for (i = 0; i < col; i++)
{
if (DaRd.GetValue(i) == null)
{
str += "^";
}
else
{
str += DaRd.GetValue(i).ToString().Replace("^", "") + "^";
}
}
ArrStr.Add(str);
}
catch (Exception) { }
}
}
DaRd.Close();
cmd.Cancel();
}
catch (Exception)
{
ArrStr = new ArrayList();
}
Conn.Close();
DaRd = null;
cmd = null;
Conn = null;
return(ArrStr);
}
//
// MembershipProvider.GetPassword
//
public override string GetPassword(string username, string answer)
{
if (!EnablePasswordRetrieval)
{
throw new ProviderException("Password Retrieval Not Enabled.");
}
if (PasswordFormat == MembershipPasswordFormat.Hashed)
{
throw new ProviderException("Cannot retrieve Hashed passwords.");
}
OdbcConnection conn = new OdbcConnection(connectionString);
OdbcCommand cmd = new OdbcCommand("SELECT Password, PasswordAnswer, IsLockedOut FROM Users " +
" WHERE Username = ? AND ApplicationName = ?", conn);
cmd.Parameters.Add("@Username", OdbcType.VarChar, 255).Value = username;
cmd.Parameters.Add("@ApplicationName", OdbcType.VarChar, 255).Value = ApplicationName;
string password = "";
string passwordAnswer = "";
OdbcDataReader reader = null;
try {
conn.Open();
reader = cmd.ExecuteReader(CommandBehavior.SingleRow);
if (reader.HasRows)
{
reader.Read();
if (reader.GetBoolean(2))
{
throw new MembershipPasswordException("The supplied user is locked out.");
}
password = reader.GetString(0);
passwordAnswer = reader.GetString(1);
}
else
{
throw new MembershipPasswordException("The supplied user name is not found.");
}
}
catch (OdbcException e) {
if (WriteExceptionsToEventLog)
{
WriteToEventLog(e, "GetPassword");
throw new ProviderException(exceptionMessage);
}
else
{
throw e;
}
}
finally {
if (reader != null)
{
reader.Close();
}
conn.Close();
}
if (RequiresQuestionAndAnswer && !CheckPassword(answer, passwordAnswer))
{
UpdateFailureCount(username, "passwordAnswer");
throw new MembershipPasswordException("Incorrect password answer.");
}
if (PasswordFormat == MembershipPasswordFormat.Encrypted)
{
password = UnEncodePassword(password);
}
return(password);
}
//insertar
public static string InsertarProducto(ProductoModel producto)
{
OdbcConnection conn = Conexion.obtenerConexion();
try
{
byte[] Imagen = Convert.FromBase64String(producto.Imagen);
string ruta = @"C:\inetpub\wwwroot\Produx\Imagenes";
if (!Directory.Exists(ruta))
{
Directory.CreateDirectory(ruta);
}
File.WriteAllBytes(ruta + @"\" + producto.Descripcion + ".jpg", Imagen);
OdbcCommand command = new OdbcCommand();
string Sql = "{call [dbo].[sp_Insertar_Producto](?,?,?,?,?,?,?,?)}";
command.CommandType = CommandType.StoredProcedure;
command.CommandText = Sql;
command.Connection = conn;
command.Parameters.Add("@Id_Producto", OdbcType.VarChar);
command.Parameters["@Id_Producto"].Value = producto.Codigo;
command.Parameters.Add("@Descripcion", OdbcType.VarChar);
command.Parameters["@Descripcion"].Value = producto.Descripcion;
command.Parameters.Add("@Precio", OdbcType.Decimal);
command.Parameters["@Precio"].Value = producto.Precio;
command.Parameters.Add("@Cant_Inventario", OdbcType.Int);
command.Parameters["@Cant_Inventario"].Value = producto.CantidadInventario;//Usuario Logueado
command.Parameters.Add("@Observaciones", OdbcType.VarChar);
command.Parameters["@Observaciones"].Value = producto.Observaciones;
command.Parameters.Add("@Imagen", OdbcType.VarChar);
command.Parameters["@Imagen"].Value = @"/" + producto.Descripcion + ".jpg";
command.Parameters.Add("@Estado", OdbcType.Int);
command.Parameters["@Estado"].Value = producto.Estado;
command.Parameters.Add("@Usuario_Creacion", OdbcType.VarChar);
command.Parameters["@Usuario_Creacion"].Value = producto.Usuario_Creacion;
command.ExecuteNonQuery();
command.Dispose();
return("true");
}
catch (Exception ax)
{
//if (!EventLog.SourceExists("MySource"))
//{
// EventLog.CreateEventSource("MySource", "MyNewLog");
//}
//// Create an EventLog instance and assign its source.
//EventLog myLog = new EventLog();
//myLog.Source = "MySource";
//myLog.WriteEntry(ax.Message);
return(ax.Message); // "false";
}
finally
{
conn.Close();
conn.Dispose();
}
}
private void submitButton_Click(object sender, EventArgs e)
{
// go to status page with job, partNo and customer
if (partNoLabel.Text.Trim().Length == 0)
{
return;
}
// calculate the type of form to create after
if (question3YesRadioButton.Checked || question4YesRadioButton.Checked ||
question5YesRadioButton.Checked || question6YesRadioButton.Checked ||
question7YesRadioButton.Checked)
{
type = "Contract Review";
}
else
{
if (question1NewRadioButton.Checked)
{
type = "Quick Release";
}
else if (question1ActiveRadioButton.Checked || question1CompleteRadioButton.Checked)
{
type = "Nothing";
}
}
if (this.Modal)
{
// TO_DO: Submit query info
using (OdbcConnection conn = new OdbcConnection(Globals.odbc_connection_string))
{
conn.Open();
string query =
"INSERT INTO [ATI_Workflow].[dbo].[Honda_PO_Review]\n" +
"([Job]\n" +
",[Workflow_ID]\n" +
",[Initiated_By]\n" +
",[Date]\n" +
",[PO_No]\n" +
",[PO_Qty]\n" +
",[PO_Rev]\n" +
",[PO_Rev_Date]\n" +
",[Description_Of_Change]\n" +
",[Question1_Response]\n" +
",[Question2_Response]\n" +
",[Question3_Response]\n" +
",[Question4_Response]\n" +
",[Question5_Response]\n" +
",[Question6_Response]\n" +
",[Question7_Response]\n" +
",[Question8_Response]\n" +
",[Part_Number]\n" +
",[Drawing_Rev]\n" +
",[Applicable_CID_Numbers])\n" +
"VALUES\n" +
"('" + jobNo + "',\n" +
"'" + workflow_id + "',\n" +
"'" + Globals.userName + "',\n" +
"'" + dateTextBox.Text + "',\n" +
"'" + poNoTextBox.Text + "',\n" +
"'" + poQtyTextBox.Text + "',\n" +
"'" + revTextBox.Text + "',\n" +
"'" + revDateTextBox.Text + "',\n" +
"'" + descriptionOfChangeTextBox.Text + "',\n" +
(question1NewRadioButton.Checked ? "'New'" : (question1ActiveRadioButton.Checked ? "'Active'" : (question1CompleteRadioButton.Checked ? "'Complete'" : "NULL"))) + ",\n" +
(question2YesRadioButton.Checked ? "1" : (question2NoRadioButton.Checked ? "0" : "NULL")) + ",\n" +
(question3YesRadioButton.Checked ? "'Yes'" : (question3NoRadioButton.Checked ? "'No'" : (question3NARadioButton.Checked ? "'N/A'" : "NULL"))) + ",\n" +
(question4YesRadioButton.Checked ? "1" : (question4NoRadioButton.Checked ? "0" : "NULL")) + ",\n" +
(question5YesRadioButton.Checked ? "1" : (question5NoRadioButton.Checked ? "0" : "NULL")) + ",\n" +
(question6YesRadioButton.Checked ? "1" : (question6NoRadioButton.Checked ? "0" : "NULL")) + ",\n" +
(question7YesRadioButton.Checked ? "'Yes'" : (question7NoRadioButton.Checked ? "'No'" : (question7NARadioButton.Checked ? "'N/A'" : "NULL"))) + ",\n" +
(question8YesRadioButton.Checked ? "1" : (question8NoRadioButton.Checked ? "0" : "NULL")) + ",\n" +
"'" + partNoLabel.Text + "',\n" +
"'" + drawingRevTextBox.TextAlign + "',\n" +
"'" + applicableCIDNosTextBox.Text + "');";
OdbcCommand com = new OdbcCommand(query, conn);
int rows = com.ExecuteNonQuery();
}
this.Close();
}
else
{
// load status page
this.Hide();
Form statusForm = new StatusPage(jobNo, partNoLabel.Text.Trim(), "HONDA AERO", type);
statusForm.FormClosed += (s, args) => this.Close();
statusForm.Show();
}
}
// Selects the most recent
// See also https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_totimestamp
public IMCANSSection03 GetClientIMCANSSection03ByEpisodeNumber(string facility, string patientId, double episodeNumber)
{
string commandString = @"SELECT TOP (1) a.BE_Depression,
a.BE_Anxiety,
a.BE_Eating,
a.TR_Adjustment_Trauma,
a.BE_Regulatory,
a.BE_Thrive,
a.BE_Atypical,
a.BE_Oppositional,
a.BE_Inpulsivity,
a.BE_Anger,
a.BE_Substance_use,
a.BE_Psychosis,
a.BE_Conduct,
a.BE_Interpersonal,
a.Mania,
a.Somatization,
a.TR_Emotional,
a.TR_intrusion,
a.TR_Hyperarousal,
a.BE_Attachment,
a.TR_Grief,
a.TR_Numbing,
a.TR_Dissociation,
a.TR_Avoidance,
a.L_Family,
a.L_Living,
a.L_residential_stability,
a.L_Social,
a.L_Recreation,
a.L_Developmental,
a.L_Communication,
a.L_Medical,
a.L_Medication,
a.C_Transportation,
a.L_Sleep,
a.L_Motor,
a.L_Sensory,
a.L_Curiosity,
a.L_Feeding,
a.L_School,
a.L_Judgment,
a.L_Legal,
a.L_Sexual,
a.L_Job,
a.L_Parental,
a.L_Independent_Living,
a.L_Intimate,
a.L_Daily_Living,
a.L_Routiens,
a.L_Functinal,
a.l_Loneliness,
a.D_Cognitive,
a.D_Developmental,
a.D_Selfcare,
a.D_Autism,
a.D_Sensory,
a.D_Motor,
a.D_Regulatory,
a.S_Behavior,
a.S_Achievement,
a.S_Attendance,
a.S_Relationships,
a.S_Preschool,
a.V_Career,
a.V_Job,
a.V_Attendance,
a.V_Performance,
a.V_Relations,
a.V_Skills,
a.P_Knowledge,
a.P_Supervision,
a.P_Involvement,
a.P_Organization,
a.P_Marital,
a.DL_Meal,
a.DL_Shopping,
a.DL_housework,
a.DL_Money,
a.DL_Communication,
a.DL_Housing,
a.P_Supporting,
-- For Testing and Validation
a.FACILITY,
a.PATID,
a.EPISODE_NUMBER,
a.GI_Type, a.GI_Type_Value,
a.Data_Entry_Date,
a.Data_Entry_Time
FROM SYSTEM.AP_CWS_CAN_Comp_Assess1 a
WHERE a.FACILITY=?
AND a.PATID=?
AND a.EPISODE_NUMBER=?
ORDER BY a.Data_Entry_Date DESC,
TO_TIMESTAMP(a.Data_Entry_Time,'HH:MI:SS.FF') DESC";
IMCANSSection03 imCans = new IMCANSSection03();
using (OdbcConnection connection = new OdbcConnection(_connectionStringCollection.CWS))
{
OdbcCommand command = new OdbcCommand(commandString, connection);
command.Parameters.Add(new OdbcParameter("FACILITY", facility));
command.Parameters.Add(new OdbcParameter("PATID", patientId));
command.Parameters.Add(new OdbcParameter("EPISODENUMBER", episodeNumber));
try
{
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
imCans.Section03a.Depression = IMCANSGetRating(GetStringValue(reader, "BE_Depression"));
imCans.Section03a.Anxiety = IMCANSGetRating(GetStringValue(reader, "BE_Anxiety"));
imCans.Section03a.EatingDisturbance = IMCANSGetRating(GetStringValue(reader, "BE_Eating"));
imCans.Section03a.AdjustmentToTrauma = IMCANSGetRating(GetStringValue(reader, "TR_Adjustment_Trauma"));
imCans.Section03a.Regulatory = IMCANSGetRating(GetStringValue(reader, "BE_Regulatory"));
imCans.Section03a.FailureToThrive = IMCANSGetRating(GetStringValue(reader, "BE_Thrive"));
imCans.Section03a.AtypicalRepetitiveBehaviors = IMCANSGetRating(GetStringValue(reader, "BE_Atypical"));
imCans.Section03a.Oppositional = IMCANSGetRating(GetStringValue(reader, "BE_Oppositional"));
imCans.Section03a.ImpulsivityHyperactivity = IMCANSGetRating(GetStringValue(reader, "BE_Inpulsivity"));
imCans.Section03a.AngerControlFrustrationTolerance = IMCANSGetRating(GetStringValue(reader, "BE_Anger"));
imCans.Section03a.SubstanceUse = IMCANSGetRating(GetStringValue(reader, "BE_Substance_use"));
imCans.Section03a.Psychosis = IMCANSGetRating(GetStringValue(reader, "BE_Psychosis"));
imCans.Section03a.ConductAntisocialBehavior = IMCANSGetRating(GetStringValue(reader, "BE_Conduct"));
imCans.Section03a.InterpersonalProblems = IMCANSGetRating(GetStringValue(reader, "BE_Interpersonal"));
imCans.Section03a.Mania = IMCANSGetRating(GetStringValue(reader, "Mania"));
imCans.Section03a.Somatization = IMCANSGetRating(GetStringValue(reader, "Somatization"));
imCans.Section03a.TssmEmotionalPhysicalDysregulation = IMCANSGetRating(GetStringValue(reader, "TR_Emotional"));
imCans.Section03a.TssmIntrusionReexperiencing = IMCANSGetRating(GetStringValue(reader, "TR_intrusion"));
imCans.Section03a.TssmHyperarousal = IMCANSGetRating(GetStringValue(reader, "TR_Hyperarousal"));
imCans.Section03a.TssmAttachmentDifficulties = IMCANSGetRating(GetStringValue(reader, "BE_Attachment"));
imCans.Section03a.TssmTraumaticGriefSeparation = IMCANSGetRating(GetStringValue(reader, "TR_Grief"));
imCans.Section03a.TssmNumbing = IMCANSGetRating(GetStringValue(reader, "TR_Numbing"));
imCans.Section03a.TssmDissociation = IMCANSGetRating(GetStringValue(reader, "TR_Dissociation"));
imCans.Section03a.TssmAvoidance = IMCANSGetRating(GetStringValue(reader, "TR_Avoidance"));
imCans.Section03b.FamilyFunctioning = IMCANSGetRating(GetStringValue(reader, "L_Family"));
imCans.Section03b.LivingSituation = IMCANSGetRating(GetStringValue(reader, "L_Living"));
imCans.Section03b.ResidentialStability = IMCANSGetRating(GetStringValue(reader, "L_residential_stability"));
imCans.Section03b.SocialFunctioning = IMCANSGetRating(GetStringValue(reader, "L_Social"));
imCans.Section03b.RecreationPlay = IMCANSGetRating(GetStringValue(reader, "L_Recreation"));
imCans.Section03b.DevelopmentalIntellectual = IMCANSGetRating(GetStringValue(reader, "L_Developmental"));
imCans.Section03b.Communication = IMCANSGetRating(GetStringValue(reader, "L_Communication"));
imCans.Section03b.MedicalPhysical = IMCANSGetRating(GetStringValue(reader, "L_Medical"));
imCans.Section03b.MedicationCompliance = IMCANSGetRating(GetStringValue(reader, "L_Medication"));
imCans.Section03b.Transportation = IMCANSGetRating(GetStringValue(reader, "C_Transportation"));
imCans.Section03b.Sleep = IMCANSGetRating(GetStringValue(reader, "L_Sleep"));
imCans.Section03b.Motor = IMCANSGetRating(GetStringValue(reader, "L_Motor"));
imCans.Section03b.Sensory = IMCANSGetRating(GetStringValue(reader, "L_Sensory"));
imCans.Section03b.PersistenceCuriosityAdaptibility = IMCANSGetRating(GetStringValue(reader, "L_Curiosity"));
imCans.Section03b.Elimination = IMCANSGetRating(GetStringValue(reader, "L_Feeding"));
imCans.Section03b.SchoolPreschoolDaycare = IMCANSGetRating(GetStringValue(reader, "L_School"));
imCans.Section03b.DecisionMaking = IMCANSGetRating(GetStringValue(reader, "L_Judgment"));
imCans.Section03b.Legal = IMCANSGetRating(GetStringValue(reader, "L_Legal"));
imCans.Section03b.SexualDevelopment = IMCANSGetRating(GetStringValue(reader, "L_Sexual"));
imCans.Section03b.JobFunctioningEmployment = IMCANSGetRating(GetStringValue(reader, "L_Job"));
imCans.Section03b.ParentalCaregiveringRole = IMCANSGetRating(GetStringValue(reader, "L_Parental"));
imCans.Section03b.IndependentLivingSkills = IMCANSGetRating(GetStringValue(reader, "L_Independent_Living"));
imCans.Section03b.IntimateRelationships = IMCANSGetRating(GetStringValue(reader, "L_Intimate"));
imCans.Section03b.BasicActivitiesOfDailyLiving = IMCANSGetRating(GetStringValue(reader, "L_Daily_Living"));
imCans.Section03b.Routines = IMCANSGetRating(GetStringValue(reader, "L_Routiens"));
imCans.Section03b.FunctionalCommunication = IMCANSGetRating(GetStringValue(reader, "L_Functinal"));
imCans.Section03b.Loneliness = IMCANSGetRating(GetStringValue(reader, "l_Loneliness"));
imCans.Section03b.DdCognitive = IMCANSGetRating(GetStringValue(reader, "D_Cognitive"));
imCans.Section03b.DdDevelopmental = IMCANSGetRating(GetStringValue(reader, "D_Developmental"));
imCans.Section03b.DdSelfCareDailyLivingSkills = IMCANSGetRating(GetStringValue(reader, "D_Selfcare"));
imCans.Section03b.DdAutismSpectrum = IMCANSGetRating(GetStringValue(reader, "D_Autism"));
imCans.Section03b.DdSensory = IMCANSGetRating(GetStringValue(reader, "D_Sensory"));
imCans.Section03b.DdMotor = IMCANSGetRating(GetStringValue(reader, "D_Motor"));
imCans.Section03b.DdRegulatory = IMCANSGetRating(GetStringValue(reader, "D_Regulatory"));
imCans.Section03b.SpdcBehavior = IMCANSGetRating(GetStringValue(reader, "S_Behavior"));
imCans.Section03b.SpdcAchievement = IMCANSGetRating(GetStringValue(reader, "S_Achievement"));
imCans.Section03b.SpdcAttendance = IMCANSGetRating(GetStringValue(reader, "S_Attendance"));
imCans.Section03b.SpdcRelationshipsWithTeachers = IMCANSGetRating(GetStringValue(reader, "S_Relationships"));
imCans.Section03b.SpdcPreschoolDaycareQuality = IMCANSGetRating(GetStringValue(reader, "S_Preschool"));
imCans.Section03b.VcCareerAspirations = IMCANSGetRating(GetStringValue(reader, "V_Career"));
imCans.Section03b.VcJobTime = IMCANSGetRating(GetStringValue(reader, "V_Job"));
imCans.Section03b.VcJobAttendance = IMCANSGetRating(GetStringValue(reader, "V_Attendance"));
imCans.Section03b.VcJobPerformance = IMCANSGetRating(GetStringValue(reader, "V_Performance"));
imCans.Section03b.VcJobRelations = IMCANSGetRating(GetStringValue(reader, "V_Relations"));
imCans.Section03b.VcJobSkills = IMCANSGetRating(GetStringValue(reader, "V_Skills"));
imCans.Section03b.PcKnowledgeOfNeeds = IMCANSGetRating(GetStringValue(reader, "P_Knowledge"));
imCans.Section03b.PcSupervision = IMCANSGetRating(GetStringValue(reader, "P_Supervision"));
imCans.Section03b.PcInvolvementWithCare = IMCANSGetRating(GetStringValue(reader, "P_Involvement"));
imCans.Section03b.PcOrganization = IMCANSGetRating(GetStringValue(reader, "P_Organization"));
imCans.Section03b.PcMaritalPartnerViolenceInTheHome = IMCANSGetRating(GetStringValue(reader, "P_Marital"));
imCans.Section03b.IadlMealPreparation = IMCANSGetRating(GetStringValue(reader, "DL_Meal"));
imCans.Section03b.IadlShopping = IMCANSGetRating(GetStringValue(reader, "DL_Shopping"));
imCans.Section03b.IadlHousework = IMCANSGetRating(GetStringValue(reader, "DL_housework"));
imCans.Section03b.IadlMoneyManagement = IMCANSGetRating(GetStringValue(reader, "DL_Money"));
imCans.Section03b.IadlCommunicationDeviceUse = IMCANSGetRating(GetStringValue(reader, "DL_Communication"));
imCans.Section03b.IadlHousingSafety = IMCANSGetRating(GetStringValue(reader, "DL_Housing"));
imCans.SupportingInformation = GetStringValue(reader, "P_Supporting");
}
}
}
}
catch (OdbcException ex)
{
logger.Error(ex, "GetClientIMCANSSection03ByEpisodeNumber: Could not connect to ODBC data source. See error message. Data Source: {systemDsn}. Error: {errorMessage}", _connectionStringCollection.PM, ex.Message);
throw;
}
catch (Exception ex)
{
logger.Error(ex, "GetClientIMCANSSection03ByEpisodeNumber: An unexpected error occurred. Error Type: {errorType}. Error: {errorMessage}", ex.GetType(), ex.Message);
throw;
}
}
return(imCans);
}
private void PopulateDataFromDB()
{
// check if this contract review exists on DB
// load if so
using (OdbcConnection conn = new OdbcConnection(Globals.odbc_connection_string))
{
conn.Open();
string query =
"SELECT [Job]\n" +
",[Workflow_ID]\n" +
",[Initiated_By]\n" +
",[Date]\n" +
",[PO_No]\n" +
",[PO_Qty]\n" +
",[PO_Rev]\n" +
",[PO_Rev_Date]\n" +
",[Description_Of_Change]\n" +
",[Question1_Response]\n" +
",[Question2_Response]\n" +
",[Question3_Response]\n" +
",[Question4_Response]\n" +
",[Question5_Response]\n" +
",[Question6_Response]\n" +
",[Question7_Response]\n" +
",[Question8_Response]\n" +
",[Part_Number]\n" +
",[Drawing_Rev]\n" +
",[Applicable_CID_Numbers]\n" +
"FROM[ATI_Workflow].[dbo].[Honda_PO_Review]\n" +
"WHERE Job = '" + jobNo + "' AND Workflow_ID = '" + workflow_id + "';";
OdbcCommand com = new OdbcCommand(query, conn);
OdbcDataReader reader = com.ExecuteReader();
// if row exists populate DB
if (reader.Read())
{
initiatedByTextBox.Text = reader.IsDBNull(2) ? "" : reader.GetString(2);
dateTextBox.Text = reader.IsDBNull(3) ? "" : reader.GetString(3);
poNoTextBox.Text = reader.IsDBNull(4) ? "" : reader.GetString(4);
poQtyTextBox.Text = reader.IsDBNull(5) ? "" : reader.GetString(5);
revTextBox.Text = reader.IsDBNull(6) ? "" : reader.GetString(6);
revDateTextBox.Text = reader.IsDBNull(7) ? "" : reader.GetString(7);
descriptionOfChangeTextBox.Text = reader.IsDBNull(8) ? "" : reader.GetString(8);
if (!reader.IsDBNull(9))
{
if (reader.GetString(9).Equals("New"))
{
question1NewRadioButton.Checked = true;
question1ActiveRadioButton.Checked = false;
question1CompleteRadioButton.Checked = false;
}
else if (reader.GetString(9).Equals("Active"))
{
question1NewRadioButton.Checked = false;
question1ActiveRadioButton.Checked = true;
question1CompleteRadioButton.Checked = false;
}
else
{
question1NewRadioButton.Checked = false;
question1ActiveRadioButton.Checked = false;
question1CompleteRadioButton.Checked = true;
}
}
if (!reader.IsDBNull(10))
{
if (reader.GetBoolean(10))
{
question2YesRadioButton.Checked = true;
question2NoRadioButton.Checked = false;
}
else
{
question2YesRadioButton.Checked = false;
question2NoRadioButton.Checked = true;
}
}
if (!reader.IsDBNull(11))
{
if (reader.GetString(11).Equals("Yes"))
{
question3YesRadioButton.Checked = true;
question3NoRadioButton.Checked = false;
question3NARadioButton.Checked = false;
}
else if (reader.GetString(11).Equals("No"))
{
question3YesRadioButton.Checked = false;
question3NoRadioButton.Checked = true;
question3NARadioButton.Checked = false;
}
else
{
question3YesRadioButton.Checked = false;
question3NoRadioButton.Checked = false;
question3NARadioButton.Checked = true;
}
}
if (!reader.IsDBNull(12))
{
if (reader.GetBoolean(12))
{
question4YesRadioButton.Checked = true;
question4NoRadioButton.Checked = false;
}
else
{
question4YesRadioButton.Checked = false;
question4NoRadioButton.Checked = true;
}
}
if (!reader.IsDBNull(13))
{
if (reader.GetBoolean(13))
{
question5YesRadioButton.Checked = true;
question5NoRadioButton.Checked = false;
}
else
{
question5YesRadioButton.Checked = false;
question5NoRadioButton.Checked = true;
}
}
if (!reader.IsDBNull(14))
{
if (reader.GetBoolean(14))
{
question6YesRadioButton.Checked = true;
question6NoRadioButton.Checked = false;
}
else
{
question6YesRadioButton.Checked = false;
question6NoRadioButton.Checked = true;
}
}
if (!reader.IsDBNull(15))
{
if (reader.GetString(15).Equals("Yes"))
{
question7YesRadioButton.Checked = true;
question7NoRadioButton.Checked = false;
question7NARadioButton.Checked = false;
}
else if (reader.GetString(15).Equals("No"))
{
question7YesRadioButton.Checked = false;
question7NoRadioButton.Checked = true;
question7NARadioButton.Checked = false;
}
else
{
question7YesRadioButton.Checked = false;
question7NoRadioButton.Checked = false;
question7NARadioButton.Checked = true;
}
}
if (!reader.IsDBNull(15))
{
if (reader.GetBoolean(15))
{
question8YesRadioButton.Checked = true;
question8NoRadioButton.Checked = false;
}
else
{
question8YesRadioButton.Checked = false;
question8NoRadioButton.Checked = true;
}
}
partNoLabel.Text = reader.IsDBNull(16) ? "" : reader.GetString(16);
drawingRevTextBox.Text = reader.IsDBNull(17) ? "" : reader.GetString(17);
applicableCIDNosTextBox.Text = reader.IsDBNull(18) ? "" : reader.GetString(18);
}
}
}
public static void Connect()
{
myConnection = new OdbcConnection(dbInfo);
myConnection.Open();
myQuery = myConnection.CreateCommand();
}
public void conexion()
{
con = new OdbcConnection("Driver={MySQL ODBC 5.2w Driver};server=localhost;uid=root;password=1234;database=practica;port=3306");
con.Open();
}
/// <summary>
/// ODBCRecordsetClass Constructor: initialize internal variables,
/// the connection is initialized using the connection string.
/// </summary>
/// <param name="connString"></param>
public ODBCRecordsetClass(String connString)
{
dbConnection = new OdbcConnection(connString);
dbAdapter = new OdbcDataAdapter();
dbDataSet = new DataSet();
newRow = false;
foundRecordsCounter = 0;
classFields = new FieldsClass(this);
SetInitialPosition();
}
/// <summary>
/// 通过文件，sql ,取出Table.
/// </summary>
/// <param name="filePath"></param>
/// <param name="sql"></param>
/// <returns></returns>
public static DataTable GetTableByExt(string filePath, string sql)
{
DataTable Tb = new DataTable("Tb");
Tb.Rows.Clear();
string typ = System.IO.Path.GetExtension(filePath).ToLower();
string strConn;
switch (typ.ToLower())
{
case ".xls":
if (sql == null)
{
sql = "SELECT * FROM [" + GenerFirstTableName(filePath) + "]";
}
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" + filePath + ";Extended Properties=Excel 8.0";
System.Data.OleDb.OleDbConnection conn = new OleDbConnection(strConn);
OleDbDataAdapter ada = new OleDbDataAdapter(sql, conn);
try
{
conn.Open();
ada.Fill(Tb);
Tb.TableName = Path.GetFileNameWithoutExtension(filePath);
}
catch (System.Exception ex)
{
conn.Close();
throw ex; //(ex.Message);
}
conn.Close();
break;
case ".xlsx":
if (sql == null)
{
sql = "SELECT * FROM [" + GenerFirstTableName(filePath) + "]";
}
try
{
strConn = "Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES\"";
System.Data.OleDb.OleDbConnection conn121 = new OleDbConnection(strConn);
OleDbDataAdapter ada91 = new OleDbDataAdapter(sql, conn121);
conn121.Open();
ada91.Fill(Tb);
Tb.TableName = Path.GetFileNameWithoutExtension(filePath);
conn121.Close();
ada91.Dispose();
}
catch (System.Exception ex1)
{
try
{
strConn = "Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\"";
System.Data.OleDb.OleDbConnection conn1215 = new OleDbConnection(strConn);
OleDbDataAdapter ada919 = new OleDbDataAdapter(sql, conn1215);
ada919.Fill(Tb);
Tb.TableName = Path.GetFileNameWithoutExtension(filePath);
ada919.Dispose();
conn1215.Close();
}
catch
{
}
throw ex1; //(ex.Message);
}
break;
case ".dbf":
strConn = "Driver={Microsoft dBASE Driver (*.DBF)};DBQ=" + System.IO.Path.GetDirectoryName(filePath) + "\\"; //+FilePath;//
OdbcConnection conn1 = new OdbcConnection(strConn);
OdbcDataAdapter ada1 = new OdbcDataAdapter(sql, conn1);
conn1.Open();
try
{
ada1.Fill(Tb);
}
catch //(System.Exception ex)
{
try
{
int sel = ada1.SelectCommand.CommandText.ToLower().IndexOf("select") + 6;
int from = ada1.SelectCommand.CommandText.ToLower().IndexOf("from");
ada1.SelectCommand.CommandText = ada1.SelectCommand.CommandText.Remove(sel, from - sel);
ada1.SelectCommand.CommandText = ada1.SelectCommand.CommandText.Insert(sel, " top 10 * ");
ada1.Fill(Tb);
Tb.TableName = "error";
}
catch (System.Exception ex)
{
conn1.Close();
throw new Exception("读取DBF数据失败！" + ex.Message + " SQL:" + sql);
}
}
conn1.Close();
break;
default:
break;
}
return(Tb);
}
private void Enter_Query(object sender, RoutedEventArgs e)
{
selectSQL = "Select * From book ";
int where = 0;
if (BookID.Text != "")
{
if (where == 0)
{
selectSQL += "WHERE bno = '" + BookID.Text + "'";
}
else
{
selectSQL += " AND bno = '" + BookID.Text + "'";
}
where++;
}
if (Category.Text != "")
{
if (where == 0)
{
selectSQL += "WHERE category = '" + Category.Text + "'";
}
else
{
selectSQL += " AND category = '" + Category.Text + "'";
}
where++;
}
if (BookName.Text != "")
{
if (where == 0)
{
selectSQL += "WHERE title = '" + BookName.Text + "'";
}
else
{
selectSQL += " AND title = '" + BookName.Text + "'";
}
where++;
}
if (Publish.Text != "")
{
if (where == 0)
{
selectSQL += "WHERE press = '" + Publish.Text + "'";
}
else
{
selectSQL += " AND press = '" + Publish.Text + "'";
}
where++;
}
if (BookWriter.Text != "")
{
if (where == 0)
{
selectSQL += "WHERE author = '" + BookWriter.Text + "'";
}
else
{
selectSQL += " AND author = '" + BookWriter.Text + "'";
}
where++;
}
if (BookYearL.Text != "" && BookYearR.Text != "")
{
if (where == 0)
{
selectSQL += "WHERE year between " + BookYearL.Text + " AND " + BookYearR.Text;
}
else
{
selectSQL += " AND year between " + BookYearL.Text + " AND " + BookYearR.Text;
}
where++;
}
if (BookPricel.Text != "" && BookPricer.Text != "")
{
if (where == 0)
{
selectSQL += "WHERE price between " + BookPricel.Text + " AND " + BookPricer.Text;
}
else
{
selectSQL += " AND price between " + BookPricel.Text + " AND " + BookPricer.Text;
}
where++;
}
using (OdbcConnection connection = new OdbcConnection(connectionString))
{
OdbcDataReader reader = null;
OdbcCommand command = new OdbcCommand(selectSQL, connection);
// Open the connection and execute the select command.
try
{
connection.Open();
reader = command.ExecuteReader();
DataTable datatable = new DataTable();
datatable.Load(reader);
if (datatable.Rows.Count > 0 && datatable != null)
{
QueryGrid.ItemsSource = datatable.AsDataView();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
// The connection is automatically closed when the
// code exits the using block.
}
}
private void ExecuteSql(string sql)
{
switch (DbType)
{
case Type.SqlServer:
using (var connection = new SqlConnection(ConnectionString))
using (var command = new SqlCommand(sql, connection))
{
ConvertToCsv(connection, command);
}
break;
case Type.Access:
using (var connection = new OleDbConnection(ConnectionString))
using (var command = new OleDbCommand(sql, connection))
{
ConvertToCsv(connection, command);
}
break;
case Type.Oracle:
using (var connection = new OracleConnection(ConnectionString))
using (var command = new OracleCommand(sql, connection))
{
ConvertToCsv(connection, command);
}
break;
case Type.MySql:
using (var connection = new MySqlConnection(ConnectionString))
using (var command = new MySqlCommand(sql, connection))
{
ConvertToCsv(connection, command);
}
break;
case Type.Sqlite:
using (var connection = new SQLiteConnection(ConnectionString))
using (var command = new SQLiteCommand(sql, connection))
{
ConvertToCsv(connection, command);
}
break;
case Type.PostGreSql:
using (var connection = new NpgsqlConnection(ConnectionString))
using (var command = new NpgsqlCommand(sql, connection))
{
ConvertToCsv(connection, command);
}
break;
case Type.Teradata:
using (var connection = new TdConnection(ConnectionString))
using (var command = new TdCommand(sql, connection))
{
ConvertToCsv(connection, command);
}
break;
case Type.Odbc:
using (var connection = new OdbcConnection(ConnectionString))
using (var command = new OdbcCommand(sql, connection))
{
ConvertToCsv(connection, command);
}
break;
}
}
public static string GetProviderNameSSIMEDODBC(string _providerCode)
{
using (OdbcConnection cn = new OdbcConnection(Database.SsimedConnection))
{
cn.Open();
using (OdbcCommand cm = cn.CreateCommand())
{
cm.CommandText = "SELECT LstName FROM TProvider where ProvCode = '" + _providerCode + "'";
using (OdbcDataReader dr = cm.ExecuteReader())
{
dr.Read();
return dr.GetString(0).Trim();
}
}
}
}
//GET APPS PERFIL
private void getAppsPerfil2(int code)
{
CadenaDeConexion cdc = new CadenaDeConexion();
int refCode = 0;
try
{
using (var conn = new OdbcConnection("dsn=colchoneria"))
{
OdbcDataReader dr;
conn.Open();
{
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "SELECT * FROM TBL_perfil_detalle WHERE perf_cod_encabezado = '" + code + "'";
dr = cmd.ExecuteReader();
while (dr.Read())
{
//HERE
ArrayList row = new ArrayList();
row.Add(dr["api_codigo"].ToString());
refCode = Convert.ToInt32(dr["api_codigo"].ToString());
row.Add(dt.getAppName(refCode));
if (Convert.ToBoolean(dr["ingresar"]))
{
row.Add(true);
}
else
{
row.Add(false);
}
if (Convert.ToBoolean(dr["editar"]))
{
row.Add(true);
}
else
{
row.Add(false);
}
if (Convert.ToBoolean(dr["guardar"]))
{
row.Add(true);
}
else
{
row.Add(false);
}
if (Convert.ToBoolean(dr["borrar"]))
{
row.Add(true);
}
else
{
row.Add(false);
}
/* if (Convert.ToBoolean(dr["buscar"]))
* {
* row.Add(true);
* }
* else
* {
* row.Add(false);
* }*/
if (Convert.ToBoolean(dr["consultar"]))
{
row.Add(true);
}
else
{
row.Add(false);
}
/*if (Convert.ToBoolean(dr["imprimir"]))
* {
* row.Add(true);
* }
* else
* {
* row.Add(false);
* }*/
//CAMBIOS
dataGridView5.Rows.Add(row.ToArray());
//dataGridView1.Rows.Add(row.ToArray());
}
dr.Close();
conn.Close();
}
}
}
}
catch (Exception ex)
{
}
}
//public int AffectedRows { get { return affectedRows; } }
public Database()
{
exception = null;
dbConn = null;
//command = null;
}
public static void Write(DataSet dserrors, string ilibfil, OdbcConnection IseriesConn, string pgmname, string logpath)
{ // write errors to Iseries pass in data set dserrors
Console.WriteLine("Writting IseriesErrors ");
try
{
DataTable dtErrors = dserrors.Tables["ErrRow"];
// ?clear error file on iseries PDERxPF
Logger oLogger = new Logger();
// note csDComp matches the PGMNAM below
string strDelete = "Delete from " + ilibfil + " where PGMNM= " + pgmname;
OdbcCommand cmdDeleteMSG = new OdbcCommand(strDelete, IseriesConn);
String strcmdInsert = "insert into " + ilibfil +
" (" +
" PGMNM, " + // 1
" MESSAG, " +
" MSGDAT, " +
" PRLEAS, " +
" PRTKYY, " + //5
" PRTKMM, " + //6
" PRTKDD, " +
" PRTANK," +
"DIFDAY," +
"YMDCHG," + //10
"BOPD," +
"MCFD," +
"RUNTKT," +
"BATT," +
"PUID" + //15
")" +
" values( " +
"?," +
"?," +
"?," +
"?," +
"?," + //5
"?," +
"?," +
"?," +
"?," +
"?," + //10
"?," +
"?," +
"?," +
"?," +
"?" + //15
")";
OdbcCommand insx = new OdbcCommand(strcmdInsert, IseriesConn);
var Error = from Errorrow in dtErrors.AsEnumerable()
select new // layout of file PDERxPF
{
pgm = Errorrow["PGMNM"].ToString(),
Comments = Errorrow["MESSAG"].ToString(),
Date = (decimal)Errorrow["DATMSG"],
AuxID = Errorrow["PRLEAS"].ToString(),
yr = (decimal)Errorrow["PRTKYY"],
mo = (decimal)Errorrow["PRTKMM"],
da = (decimal)Errorrow["PRTKDD"],
Tank = Errorrow["PRTANK"].ToString(),
Tickt = Errorrow["PRTCKT"].ToString()
};
int GaugeNumsCount = 0;
foreach (var ErrRow in Error)
{ // iseries insert into PDER4PF
GaugeNumsCount = GaugeNumsCount + 1;
int intYear = (int)ErrRow.yr;
int intMonth = (int)ErrRow.mo;
int intDay = (int)ErrRow.da;
// build data for insert
insx.Parameters.Clear();
insx.Parameters.AddWithValue("PGMNAM", ErrRow.pgm);// pgmname);//1
int len = ErrRow.Comments.Length;
if (len > 34)
{
len = 34;
}
string errmsg = "ERR-" + ErrRow.Comments.Substring(0, len);
if ((errmsg.Length > 1))
{
insx.Parameters.AddWithValue("MESSAG", errmsg);
}
else
{
insx.Parameters.AddWithValue("MESSAG", " "); //2
}
insx.Parameters.AddWithValue("MSGDAT", ErrRow.Date);
insx.Parameters.AddWithValue("PRLEAS", ErrRow.AuxID);
insx.Parameters.AddWithValue("PRTKYY", intYear);
insx.Parameters.AddWithValue("PRTKMM", intMonth); //6
insx.Parameters.AddWithValue("PRTKDD", intDay);
insx.Parameters.AddWithValue("PRTANK", ErrRow.Tank);
insx.Parameters.AddWithValue("DIFDAY", 0.0M);
insx.Parameters.AddWithValue("YMDCHG", DateIBM.YYYYMMDD(intYear, intMonth, intDay));//10
insx.Parameters.AddWithValue("BOPD", 0.0M);
insx.Parameters.AddWithValue("MCFD", 0.0M);
insx.Parameters.AddWithValue("RUNTKT", ErrRow.Tickt);
insx.Parameters.AddWithValue("OILADJ", 0.0m);//not in error table
insx.Parameters.AddWithValue("BATT", " ");
insx.Parameters.AddWithValue("PUID", " ");
string tnk = ErrRow.Tank;
try
{ // insert errors are logged but do not stop process
insx.ExecuteNonQuery();
}
catch (Exception Ex)
{
oLogger.logErrorToLog("ERROR Write to Iseries ErrRow:" +
ErrRow + "." + Ex.Message, pgmname, logpath);
}
}
}
catch (Exception Ex)
{
throw (Ex);
}
}
internal IInnerConnection CreateInnerConnection (ConnectionOptions options, bool enlist)
{
Debug.WriteLineIf (CLI.FnTrace.Enabled, "VirtuosoConnection.CreateInnerConnection()");
IInnerConnection conn;
#if UNMANAGED_ODBC
if (options.UseOdbc)
conn = new OdbcConnection ();
else
#endif
conn = new TcpConnection ();
conn.OuterConnectionWeakRef = new WeakReference (this);
conn.Open (options);
#if MTS
if (enlist && options.Enlist && ContextUtil.IsInTransaction)
EnlistInnerConnection (conn);
#endif
return conn;
}
public Traveller(int tabletDeviceNumber, TableStatus tableStatus)
{
TabletDeviceNumber = tabletDeviceNumber;
BoardNumber = tableStatus.ResultData.BoardNumber;
NumberNorth = tableStatus.RoundData.NumberNorth;
using (OdbcConnection connection = new OdbcConnection(AppData.DBConnectionString))
{
connection.Open();
string SQLString;
OdbcCommand cmd = null;
OdbcDataReader reader = null;
try
{
if (AppData.IsIndividual)
{
SQLString = $"SELECT PairNS, PairEW, South, West, [NS/EW], Contract, LeadCard, Result FROM ReceivedData WHERE Section={tableStatus.SectionID} AND Board={BoardNumber}";
}
else
{
SQLString = $"SELECT PairNS, PairEW, [NS/EW], Contract, LeadCard, Result FROM ReceivedData WHERE Section={tableStatus.SectionID} AND Board={BoardNumber}";
}
cmd = new OdbcCommand(SQLString, connection);
ODBCRetryHelper.ODBCRetry(() =>
{
reader = cmd.ExecuteReader();
while (reader.Read())
{
Result result = null;
if (AppData.IsIndividual)
{
result = new Result()
{
BoardNumber = BoardNumber,
NumberNorth = reader.GetInt32(0),
NumberEast = reader.GetInt32(1),
NumberSouth = reader.GetInt32(2),
NumberWest = reader.GetInt32(3),
DeclarerNSEW = reader.GetString(4),
Contract = reader.GetString(5),
LeadCard = reader.GetString(6),
TricksTakenSymbol = reader.GetString(7)
};
}
else
{
result = new Result()
{
BoardNumber = BoardNumber,
NumberNorth = reader.GetInt32(0),
NumberEast = reader.GetInt32(1),
DeclarerNSEW = reader.GetString(2),
Contract = reader.GetString(3),
LeadCard = reader.GetString(4),
TricksTakenSymbol = reader.GetString(5)
};
}
if (result.Contract.Length > 2) // Testing for unplayed boards and corrupt ReceivedData table
{
result.CalculateScore();
Add(result);
if (result.NumberNorth == NumberNorth) // Get score for current result for calculating percentages
{
currentScore = result.Score;
}
}
}
});
}
finally
{
reader.Close();
cmd.Dispose();
}
};
// Sort traveller and calculate percentage for current result
Sort((x, y) => y.Score.CompareTo(x.Score));
if (Settings.ShowPercentage)
{
if (Count == 1)
{
PercentageNS = 50;
}
else
{
int currentMP = 2 * FindAll((x) => x.Score < currentScore).Count + FindAll((x) => x.Score == currentScore).Count - 1;
PercentageNS = Convert.ToInt32(50.0 * currentMP / (Count - 1));
}
}
else
{
PercentageNS = -1; // Don't show percentage
}
// Determine if there is a hand record to view
HandRecord = false;
if (Settings.ShowHandRecord && HandRecords.HandRecordsList.Count > 0)
{
HandRecord handRecord = HandRecords.HandRecordsList.Find(x => x.SectionID == tableStatus.SectionID && x.BoardNumber == BoardNumber);
if (handRecord != null)
{
HandRecord = true;
}
else // Can't find matching hand record, so try default SectionID = 1
{
handRecord = HandRecords.HandRecordsList.Find(x => x.SectionID == 1 && x.BoardNumber == BoardNumber);
if (handRecord != null)
{
HandRecord = true;
}
}
}
}
