I have the following for an update function and I want to be able to pass in
a session variable where it is within the update statement. Does anyone
know how you can pass this session variable in here? As it is currently, it
says that it does not exist in the class or namspace. I have been able to
use it on other pages this way, but does not seem to be working here.
public static bool SaveMileageInfo(FleetMileage info)
{
int res = 0;
string sqlQuery = @"UPDATE fleet_equipments
SET ( DRIVER_FIRST_NAME,
DRIVER_LAST_NAME,
ACTUAL_MILES_QTY,
DRIVER_CUID,
AUDIT_LAST_USER_ID,
AUDIT_LAST_UPD_DT)
VALUES (?,?,?,?,?,SYSDATE)
WHERE flt_equip_id = ? ";
res = OleDbHelper.ExecuteNonQuery(sqlQuery,
CommandType.Text,
OleDbHelper.CreateParam("@pFirst_name",OleDbType.V arChar,
20,"pFirst_name",info.FirstName),
OleDbHelper.CreateParam("@pLastName",OleDbType.Var Char,
20,"pLastName",info.LastName),
OleDbHelper.CreateParam("@pCurrentOdo",OleDbType.I nteger,
7,"pCurrentOdo",info.CurrentOdometerReading),
OleDbHelper.CreateParam("@pDriverCUID",OleDbType.V arChar,
8,"pDriverCUID",info.DriverCuid),
OleDbHelper.CreateParam("@pCUID",OleDbType.VarChar ,
30,"pCUID",Session["CUID"]),
OleDbHelper.CreateParam("@pUnitNumber",OleDbType.V arChar,
8,"pUnitNumber",info.UnitNumber));
if(res > 0)
return true;
else
return false;
}