Пример #1
0
        //// GET ORGID WITH LEADERS ASPNET EMAIL ////
        protected void GetOrgId()
        {
            // Instantiate SQL String
            string SelectOrgIDSQL;

            // Select SQL
            SelectOrgIDSQL = "SELECT UserID, OrgID FROM tbl_UsersMaster WHERE UserEmail ='" + FetchUser.UserEmail() +
                             "'";

            // Use SQL Statement to Select Records from DB
            var sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString);
            var cmd     = new SqlCommand(SelectOrgIDSQL, sqlConn);

            cmd.Connection.Open();
            SqlDataReader OrgIdRdr;

            OrgIdRdr = cmd.ExecuteReader();
            while (OrgIdRdr.Read())
            {
                string sOrgID = OrgIdRdr["OrgID"].ToString();
                lbl_OrgID.Text = sOrgID;

                // Set Session
                Session["OrgID"] = sOrgID;

                string sUserID = OrgIdRdr["UserID"].ToString();
                // Set Session
                Session["UserID"] = sUserID;
            }
            cmd.Connection.Close();
            cmd.Connection.Dispose();
        }
        //// GET ORG DETAILS FROM ORGID SESSION VARIABLE ////
        protected void GetOrgDetails()
        {
            // Instantiate SQL String
            string SelectOrgDetailsSQL;
            string sOrgID = lbl_OrgID.Text;

            // Select SQL
            SelectOrgDetailsSQL = "SELECT * FROM tbl_OrgsMaster WHERE OrgID ='" + sOrgID + "'";

            // Use SQL Statement to Select Records from DB
            var sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString);
            var cmd     = new SqlCommand(SelectOrgDetailsSQL, sqlConn);

            cmd.Connection.Open();
            SqlDataReader OrgIdRdr;

            OrgIdRdr = cmd.ExecuteReader();
            while (OrgIdRdr.Read())
            {
                string sOrgName = OrgIdRdr["OrgName"].ToString();
                lbl_OrgName.Text = sOrgName;
                // Set Session
                Session["OrgName"] = sOrgName;
            }
            cmd.Connection.Close();
            cmd.Connection.Dispose();
        }
Пример #3
0
        //// GET ORG DETAILS FROM ORGID SESSION VARIABLE ////
        protected void GetOrgDetails()
        {
            // Instantiate SQL String
            string SelectOrgDetailsSQL;
            // Get From Session
            string sOrgID = Session["OrgID"].ToString();

            // Select SQL
            SelectOrgDetailsSQL = "SELECT * FROM tbl_OrgsMaster WHERE OrgID ='" + sOrgID + "'";

            // Use SQL Statement to Select Records from DB
            var sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString);
            var cmd     = new SqlCommand(SelectOrgDetailsSQL, sqlConn);

            cmd.Connection.Open();
            SqlDataReader OrgIdRdr;

            OrgIdRdr = cmd.ExecuteReader();

            while (OrgIdRdr.Read())
            {
                // Create strings from reader
                string sOrgName = OrgIdRdr["OrgName"].ToString();
                string sautoApproveConversation = OrgIdRdr["autoApproveConversation"].ToString();
                string sautoApproveComment      = OrgIdRdr["autoApproveComment"].ToString();
                string sconversationEmail       = OrgIdRdr["conversationEmail"].ToString();
                string scommentEmail            = OrgIdRdr["commentEmail"].ToString();
                string sprofanityFilter         = OrgIdRdr["profanityFilter"].ToString();
                string sorgEnabled = OrgIdRdr["OrgEnabled"].ToString().ToLower();

                lbl_OrgName.Text = sOrgName;

                // Set Sessions with created strings
                Session["OrgName"] = sOrgName;
                Session["autoApproveConversation"] = sautoApproveConversation;
                Session["autoApproveComment"]      = sautoApproveComment;
                Session["conversationEmail"]       = sconversationEmail;
                Session["commentEmail"]            = scommentEmail;
                Session["profanityFilter"]         = sprofanityFilter;

                // Set Master Org Label
                var lbl_masterOrg = (Label)Master.FindControl("lbl_masterOrg");
                lbl_masterOrg.Text = sOrgName;

                // Set Org Enabled Label
                var lbl_orgEnabled = (Label)Master.FindControl("lbl_orgEnabled");
                lbl_orgEnabled.Text = sorgEnabled;
            }

            cmd.Connection.Close();
            cmd.Connection.Dispose();
        }
Пример #4
0
        //// GET ORG DETAILS FROM ORGID SESSION VARIABLE ////
        protected void GetOrgDetails()
        {
            // Instantiate SQL String
            string SelectOrgDetailsSQL;
            string sOrgID = lbl_OrgID.Text;

            // Select SQL
            SelectOrgDetailsSQL = "SELECT * FROM tbl_OrgsMaster WHERE OrgID ='" + sOrgID + "'";

            // Use SQL Statement to Select Records from DB
            var sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString);
            var cmd     = new SqlCommand(SelectOrgDetailsSQL, sqlConn);

            cmd.Connection.Open();
            SqlDataReader OrgIdRdr;

            OrgIdRdr = cmd.ExecuteReader();
            while (OrgIdRdr.Read())
            {
                // Set Page Org Name
                string sOrgName = OrgIdRdr["OrgName"].ToString();
                lbl_OrgName.Text = sOrgName;

                // Get Enabled Status
                string sorgEnabled = OrgIdRdr["OrgEnabled"].ToString().ToLower();

                // Set Master Org Label
                var lbl_masterOrg = (Label)Master.FindControl("lbl_masterOrg");
                lbl_masterOrg.Text = sOrgName;

                // Set Org Enabled Label
                var lbl_orgEnabled = (Label)Master.FindControl("lbl_orgEnabled");
                lbl_orgEnabled.Text = sorgEnabled;

                // Set Session
                Session["OrgName"] = sOrgName;
            }
            cmd.Connection.Close();
            cmd.Connection.Dispose();
        }