Error while accessing Httpcontext.current.Session in DAL (Httpcontext doesnot exist) even after adding System.web

First of all Data Access layer is for accessing the data that is why it is named as data access layer but not the session access layer so try to use session value in an hierarchical manner from upper layer to lower layer by making it as a data

For eg.
 Session["server_id"] = "12";  /* In controller action method */
here server_id is a property stored as session now send this value from controller to BAL or your lower layer through function as  sendId(Convert.ToString(Session["server_id"])); as parameter in function and access this as a data
function sendId(string server_id)
{
    string my_server_id = server_id;
}
     

Comments

Post a Comment

Popular posts from this blog

Npgsql query and format with output parameters

  public string UploadExceldata(string json)         {             string connectionString = String.Format(new Connection().ConnectionString);             DataSet ds = new DataSet();             BaseResultData oBaseResult = new BaseResultData();             var connection = new Npgsql.NpgsqlConnection(connectionString);             try             {                                if (!(connection.State == ConnectionState.Open))                 {                     connection.Open();                 }                 //NpgsqlTransaction trans = connection.BeginTransaction();                 var command = new Npgsql.NpgsqlCommand("systemtracker_dbo.pr_create_user_from_excel_json", connection);                 command.CommandType = System.Data.CommandType.StoredProcedure;                 IDbDataAdapter dbDataAdapter = new NpgsqlDataAdapter();                 //Parameter Settings                 var parameter = command.CreateParameter();                 parameter.ParameterName =
Read more

Npgsql Helper class

 using System; using System.Collections.Generic; using System.Text; using System.Data; using Npgsql; using NpgsqlTypes; namespace AI_Portal_Cloud.DAL {     public class clsPSQLHelper : IDisposable     {         private NpgsqlConnection connection = null;         private String connectionString = "dbConnection";         private NpgsqlDataAdapter sqlData = new NpgsqlDataAdapter();         public NpgsqlCommand sqlCmd = new NpgsqlCommand();                  // {0} : IP, {1} : DB Name, {2} : userID, {3} : userPW         private String connectionFormat = "Server={0};Database={1};User Id={2};Password={3};Port={4}";         public String ConnectionString         {             set             {                 connectionString = value;             }         }         #region Constructors         public clsPSQLHelper()         {             //             // TODO: Add constructor logic here             //             string strConn = String.Format(new Connection().ConnectionS
Read more