public void BloquearUsuario(MSSQLce dbObj, int iCodUsuario)
{
StringBuilder queryString = null;
SqlCeParameter[] pars = null;
//
try
{
#region Query
queryString = new StringBuilder();
queryString.Append("update usuario ");
queryString.Append("set num_intentos = 0, ");
queryString.Append(" bloqueado = 1 ");
queryString.Append("where cod_usuario = @CodUsuario;");
#endregion Query
#region Parameters
pars = new SqlCeParameter[1];
pars[0] = new SqlCeParameter("@CodUsuario", SqlDbType.Int);
pars[0].Value = iCodUsuario;
#endregion Parameters
#region Query Execution
dbObj.EjecutarConsulta(false, queryString.ToString(), pars);
#endregion Query Execution
}
catch (Exception ex)
{
throw new Exception(this.sClassName + ", BloquearUsuario: " + ex.Message);
}
}
public long InsertarConfigHandHeld(int iCodUsuario, int iCodTurno, int iCodProceso)
{
MSSQLce dbObj = null;
StringBuilder queryString1 = null;
StringBuilder queryString2 = null;
SqlCeParameter[] pars = null;
DataTable dtObj = null;
long lCodConfigHandHeld = -1;
//
try
{
#region Connection Configuration
dbObj = new MSSQLce(this.sMSSQLServerCE_ConnectionString);
#endregion Connection Configuration
#region Query
queryString1 = new StringBuilder();
queryString1.Append("select ((case when max(ch.cod_config_handheld) is null then 0 else max(ch.cod_config_handheld) end) + 1) as CodConfigHandHeld ");
queryString1.Append("from config_handheld ch;");
queryString2 = new StringBuilder();
queryString2.Append("insert into config_handheld ");
queryString2.Append("(cod_config_handheld, cod_usuario, cod_turno, cod_proceso) ");
queryString2.Append("values (@CodConfigHandHeld, @CodUsuario, @CodTurno, @CodProceso);");
#endregion Query
#region Parameters
pars = new SqlCeParameter[4];
pars[0] = new SqlCeParameter("@CodConfigHandHeld", SqlDbType.BigInt);
//pars[0].Value = lCodConfigHandHeld;
pars[1] = new SqlCeParameter("@CodUsuario", SqlDbType.Int);
pars[1].Value = iCodUsuario;
pars[2] = new SqlCeParameter("@CodTurno", SqlDbType.Int);
pars[2].Value = iCodTurno;
pars[3] = new SqlCeParameter("@CodProceso", SqlDbType.Int);
pars[3].Value = iCodProceso;
#endregion Parameters
#region Query Execution
dtObj = dbObj.ObtenerRegistros(true, queryString1.ToString(), pars);
lCodConfigHandHeld = Convert.ToInt64(dtObj.Rows[0]["CodConfigHandHeld"]);
pars[0].Value = lCodConfigHandHeld;
dbObj.EjecutarConsulta(true, queryString2.ToString(), pars);
#endregion Query Execution
}
catch (Exception ex)
{
throw new Exception(this.sClassName + ", InsertarConfigHandHeld: " + ex.Message);
}
finally
{
dbObj.Dispose();
}
return(lCodConfigHandHeld);
}