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(); } } }