public void RenovarSesionInDB(string Token, ref string CK1, ref string CK2)
{
DALCSQLServer DALC = GetCommonDalc();
string SQL = "SELECT * FROM TBL_BUS_SesionHistory " +
" WHERE Token = '" + Token + "' AND ";
//SQL += DALCSQLServer.FormatFechaToDBAndTime(DateTime.Now) + " >= SesionInicio AND ";
//SQL += DALCSQLServer.FormatFechaToDBAndTime(DateTime.Now) + " <= SesionTermino AND ";
SQL += " FinalizaUsuario IS NULL ";
DataTable DT = new DataTable();
DT = DALC.ExecuteSQLDirect(SQL);
if (DT.Rows.Count > 0)
{
CK1 = DT.Rows[0]["CK1"].ToString();
CK2 = DT.Rows[0]["CK2"].ToString();
SQL = "UPDATE TBL_BUS_SesionHistory SET SesionTermino = DATEADD('n', 20, NOW()) " +
" WHERE Token = '" + Token + "' AND ";
//SQL += DALCSQLServer.FormatFechaToDBAndTime(DateTime.Now) + " >= SesionInicio AND ";
//SQL += DALCSQLServer.FormatFechaToDBAndTime(DateTime.Now) + " <= SesionTermino ";
SQL += " FinalizaUsuario IS NULL ";
DALC.ExecuteSQLNonResult(SQL);
}
}
