public static bool SaveUserLogin(Page P, string s_USER_NAME, string sUSER_ID, string sFULL_NAME, string sUSER_GROUP_ID) { string sCLIENT_ID = P.Request.UserHostAddress.ToString(); DataTable table = SQLConnectWeb.GetTable("select SESSION_ID from LOG_IN_SESSION where CLIENT_ID='" + sCLIENT_ID + "'"); if (table == null) { return false; } if (table.Rows.Count == 0) { return (LOG_IN_SESSION.Insert_Object(sCLIENT_ID, sUSER_ID, s_USER_NAME, sFULL_NAME, sUSER_GROUP_ID) != null); } LOG_IN_SESSION login = new LOG_IN_SESSION(); login.SESSION_ID = table.Rows[0][LOG_IN_SESSION.cl_SESSION_ID].ToString(); return login.Save_Object(sCLIENT_ID, sUSER_ID, s_USER_NAME, sFULL_NAME, sUSER_GROUP_ID); }
//─────────────────────────────────────────────────────────────────────────────────────── public static LOG_IN_SESSION Insert_Object( string sCLIENT_ID , string sUSER_ID , string sUSER_NAME , string sFULL_NAME , string sUSER_GROUP_ID ) { string tem_sCLIENT_ID = MinhTam.DataAccess.Web.SQLToolWeb.GetSaveValue(sCLIENT_ID, "nvarchar"); string tem_sUSER_ID = MinhTam.DataAccess.Web.SQLToolWeb.GetSaveValue(sUSER_ID, "int"); string tem_sUSER_NAME = MinhTam.DataAccess.Web.SQLToolWeb.GetSaveValue(sUSER_NAME, "nvarchar"); string tem_sFULL_NAME = MinhTam.DataAccess.Web.SQLToolWeb.GetSaveValue(sFULL_NAME, "nvarchar"); string tem_sUSER_GROUP_ID = MinhTam.DataAccess.Web.SQLToolWeb.GetSaveValue(sUSER_GROUP_ID, "int"); string sqlSave = " INSERT INTO LOG_IN_SESSION(" + "CLIENT_ID," + "USER_ID," + "USER_NAME," + "FULL_NAME," + "CLIENT_DATE," + "USER_GROUP_ID) VALUES(" + tem_sCLIENT_ID + "," + tem_sUSER_ID + "," + tem_sUSER_NAME + "," + tem_sFULL_NAME + "," + "getDate()," +tem_sUSER_GROUP_ID + ")"; bool OK = Exec(sqlSave) >= 1 ? true : false; if (OK) { LOG_IN_SESSION newLOG_IN_SESSION = new LOG_IN_SESSION(); DataTable dt = GetTable(" SELECT TOP 1 SESSION_ID,CLIENT_DATE FROM LOG_IN_SESSION ORDER BY SESSION_ID DESC "); newLOG_IN_SESSION.SESSION_ID = dt.Rows[0]["SESSION_ID"].ToString(); newLOG_IN_SESSION.CLIENT_ID = sCLIENT_ID; newLOG_IN_SESSION.USER_ID = sUSER_ID; newLOG_IN_SESSION.USER_NAME = sUSER_NAME; newLOG_IN_SESSION.FULL_NAME = sFULL_NAME; newLOG_IN_SESSION.CLIENT_DATE = dt.Rows[0]["CLIENT_DATE"].ToString(); newLOG_IN_SESSION.USER_GROUP_ID = sUSER_GROUP_ID; return newLOG_IN_SESSION; } else return null; }