Update Command Coding

[Brian Conway]

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_equipment s

SET ( DRIVER_FIRST_NA ME,

DRIVER_LAST_NAM E,

ACTUAL_MILES_QT Y,

DRIVER_CUID,

AUDIT_LAST_USER _ID,

AUDIT_LAST_UPD_ DT)

VALUES (?,?,?,?,?,SYSD ATE)

WHERE flt_equip_id = ? ";

res = OleDbHelper.Exe cuteNonQuery(sq lQuery,

CommandType.Tex t,

OleDbHelper.Cre ateParam("@pFir st_name",OleDbT ype.VarChar,
20,"pFirst_name ",info.FirstNam e),

OleDbHelper.Cre ateParam("@pLas tName",OleDbTyp e.VarChar,
20,"pLastName", info.LastName),

OleDbHelper.Cre ateParam("@pCur rentOdo",OleDbT ype.Integer,
7,"pCurrentOdo" ,info.CurrentOd ometerReading),

OleDbHelper.Cre ateParam("@pDri verCUID",OleDbT ype.VarChar,
8,"pDriverCUID" ,info.DriverCui d),

OleDbHelper.Cre ateParam("@pCUI D",OleDbType.Va rChar,
30,"pCUID",Sess ion["CUID"]),

OleDbHelper.Cre ateParam("@pUni tNumber",OleDbT ype.VarChar,
8,"pUnitNumber" ,info.UnitNumbe r));
if(res > 0)

return true;

else

return false;

}

[Scott Allen]

Hi Brian:

You can use the Current property of the the HttpContext class to get
to the session, i.e.

HttpContext.Cur rent.Session

HttpContext is in the System.Web namespace, so you'll need to add a
using clause if not present. Some additional information here:
http://odetocode.com/Articles/112.aspx

Another approach to seriously consider is to pass what you need as a
parameter to the method, or add CUID as a memeber of the FleetInfo
class (if it makes sense from a OOP design point of view). The reason
being is that SaveMileageInfo then would not have to have any
dependancy on HttpContext, which is only going to be around if you are
processing a web request. Otherwise SaveMileageInfo seems like a nice
method you could use in any type of project.

--
Scott
On Wed, 30 Jun 2004 13:39:53 -0600, "Brian Conway"
<Br**********@q west.com> wrote:

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.