void appSessionDelete(string UserID)
{
_DBcon d = new _DBcon();
_DBcon.arrOutComPar hasil = d.executeProcNQ("appSessionDelete", new _DBcon.sComParameter[] {
new _DBcon.sComParameter("@UserID", System.Data.SqlDbType.VarChar, 15, UserID)
});
}
void create_session(string UserID, string SessionID)
{
_DBcon d = new _DBcon();
_DBcon.arrOutComPar hasil = d.executeProcNQ("appCreateSession", new _DBcon.sComParameter[] {
new _DBcon.sComParameter("@UserID", System.Data.SqlDbType.VarChar, 15, UserID),
new _DBcon.sComParameter("@SessionID", System.Data.SqlDbType.VarChar, 50, SessionID)
});
}
string getMenuXML(string userID)
{
_DBcon d = new _DBcon();
_DBcon.arrOutComPar hasil = d.executeProcNQ("getMenuXMLUL", new _DBcon.sComParameter[] {
new _DBcon.sComParameter("@UserID", System.Data.SqlDbType.VarChar, 15, userID),
new _DBcon.sComParameter("@Ret", System.Data.SqlDbType.Xml, 0, System.Data.ParameterDirection.Output)
});
return(hasil["@Ret"].ToString());
}
string setMenuPavorite(string strUserID)
{
_DBcon d = new _DBcon();
_DBcon.arrOutComPar hasil = d.executeProcNQ("getXMLMenuPavorite", new _DBcon.sComParameter[] {
new _DBcon.sComParameter("@UserID", System.Data.SqlDbType.VarChar, 15, strUserID),
new _DBcon.sComParameter("@Ret", System.Data.SqlDbType.Xml, 0, System.Data.ParameterDirection.Output)
});
return(convertXmlToString(hasil["@Ret"].ToString()));
}
private void save_marketing(byte[] obj_file, string marketing_id)
{
_DBcon c = new _DBcon();
_DBcon.arrOutComPar retval = c.executeProcNQ("act_marketing_save_ttd", new _DBcon.sComParameter[]
{
new _DBcon.sComParameter("@marketing_id", System.Data.SqlDbType.VarChar, 15, marketing_id),
new _DBcon.sComParameter("@ttd_image", System.Data.SqlDbType.Image, 0, obj_file),
new _DBcon.sComParameter("@file_type", System.Data.SqlDbType.VarChar, 200, hf_filetype.Value),
}
);
}
protected void Page_Load(object sender, EventArgs e)
{
a = new App(Request, Response);
Boolean status = false;
load_firstmenuid();
try
{
_DBcon d = new _DBcon();
_DBcon.arrOutComPar hasil = d.executeProcNQ("appSessionCheck", new _DBcon.sComParameter[] {
new _DBcon.sComParameter("@UserID", System.Data.SqlDbType.VarChar, 15, a.cookieUserIDValue),
new _DBcon.sComParameter("@SessionID", System.Data.SqlDbType.VarChar, 50, a.cookieSessionIDValue),
new _DBcon.sComParameter("@Ret", System.Data.SqlDbType.Bit, 0, System.Data.ParameterDirection.Output)
});
status = Convert.ToBoolean(hasil["@Ret"]);
}
catch
{
status = false;
}
finally
{
if (status == false)
{
Response.Redirect("login.aspx");
}
else
{
lMenu.Text = getMenuXML(a.cookieUserIDValue);
load_geotag();
}
}
}
