communityutility.cs

C#邮件代码库,用于邮件发送

            cmdAdd.Parameters.Add( "@domain", domain );
            cmdAdd.Parameters.Add( "@subdomain", subDomain );
            cmdAdd.Parameters.Add( "@smtpServer", smtpServer );
            cmdAdd.Parameters.Add( "@databaseQuota", databaseQuota );
			cmdAdd.Parameters.Add( "@isDisplayed", isDisplayed );
			conPortal.Open();
            cmdAdd.ExecuteNonQuery();
            int result = (int)cmdAdd.Parameters["@RETURN_VALUE"].Value;
            conPortal.Close();
            return result;
        }


        //*********************************************************************
        //
        // UpdateCommunity Method
        //
        // Updates community information in the database. 
        //
        //*********************************************************************
    
        public static void UpdateCommunity(int communityID, string name, string primaryDomain, string domain, string subDomain, string smtpServer, int databaseQuota, bool isDisplayed) {
            SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
            SqlCommand cmdUpdate = new SqlCommand( "Community_CommunitiesUpdateCommunity", conPortal );
            cmdUpdate.CommandType = CommandType.StoredProcedure;
            cmdUpdate.Parameters.Add( "@communityID", communityID );
			cmdUpdate.Parameters.Add( "@name", name );
			cmdUpdate.Parameters.Add( "@primaryDomain", primaryDomain );
            cmdUpdate.Parameters.Add( "@domain", domain );
            cmdUpdate.Parameters.Add( "@subdomain", subDomain );
            cmdUpdate.Parameters.Add( "@smtpServer", smtpServer);
            cmdUpdate.Parameters.Add( "@databaseQuota", databaseQuota );
			cmdUpdate.Parameters.Add( "@isDisplayed", isDisplayed );

			conPortal.Open();
            cmdUpdate.ExecuteNonQuery();
            conPortal.Close();
        }


        //*********************************************************************
        //
        // DeleteCommunity Method
        //
        // Deletes a community from the database. 
        //
        //*********************************************************************
    
        public static void DeleteCommunity(int communityID) {
            SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
            SqlCommand cmdDelete = new SqlCommand( "Community_CommunitiesDeleteCommunity", conPortal );
            cmdDelete.CommandType = CommandType.StoredProcedure;
            cmdDelete.Parameters.Add( "@communityID", communityID );
            conPortal.Open();
            cmdDelete.ExecuteNonQuery();
            conPortal.Close();
        }

        //*********************************************************************
        //
        // ApplySampleContent Method
        //
        // Applies sample content to a community. 
        //
        //*********************************************************************
    
        public static void ApplySampleContent(int communityID, string adminUsername, string adminPassword) {
            SqlConnection con = new SqlConnection( CommunityGlobals.ConnectionString );
            SqlCommand cmd = new SqlCommand( "Community_MaintenanceApplySampleContent", con );
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add( "@communityID", communityID );
            cmd.Parameters.Add( "@adminUsername", adminUsername );
            cmd.Parameters.Add( "@adminPassword", adminPassword );
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }


        //*********************************************************************
        //
        // ApplySampleFreeContent Method
        //
        // Applies content to a community without sample content. 
        //
        //*********************************************************************
    
        public static void ApplySampleFreeContent(int communityID, string adminUsername, string adminPassword) {
            SqlConnection con = new SqlConnection( CommunityGlobals.ConnectionString );
            SqlCommand cmd = new SqlCommand( "Community_MaintenanceApplySampleFreeContent", con );
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add( "@communityID", communityID );
            cmd.Parameters.Add( "@adminUsername", adminUsername );
            cmd.Parameters.Add( "@adminPassword", adminPassword );
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }


        //*********************************************************************
        //
        // ExportSampleData Method
        //
        // Copies the content of the first community to XML files. 
        //
        //*********************************************************************
    
        public static void ExportSampleData() {
            // Calculate Sample Files folder
            string _sampleFolder = HttpContext.Current.Server.MapPath("~/ISPAdmin/SampleData/SampleFiles");

            // Open the database con
            SqlConnection con = new SqlConnection(CommunityGlobals.ConnectionString);
            con.Open();

            // First, let's get the list of sample tables
            DataTable dtblSampleTables = new DataTable();
            SqlDataAdapter dadSample = new SqlDataAdapter("Community_MaintenanceGetSampleTables", con);
            dadSample.SelectCommand.CommandType = CommandType.StoredProcedure;
            dadSample.Fill(dtblSampleTables);

            // Now, loop through each sample table creating XML file
            DataSet dstSampleData;
            SqlDataAdapter dadGetSampleData = new SqlDataAdapter();
            
            string _sourceTableName;
            string _sampleTableName;
            string _select;
            foreach (DataRow row in dtblSampleTables.Rows) {
                _sourceTableName = (string)row["st_sourceTable"];
                _sampleTableName = (string)row["st_sampleTable"];
                _select = "Select * from " + _sourceTableName;
                dadGetSampleData.SelectCommand = new SqlCommand(_select, con);
                dstSampleData = new DataSet();
                dadGetSampleData.Fill(dstSampleData);
                dstSampleData.WriteXml(String.Format("{0}\\{1}.xml",_sampleFolder, _sampleTableName ),XmlWriteMode.WriteSchema); 
            }
            
            
            // Close the database connection
            con.Close();
        }


        //*********************************************************************
        //
        // ImportSampleData Method
        //
        // Loads the sample XML files from the SampleFiles folder. 
        //
        //*********************************************************************
    
        public static void ImportSampleData() {
            // Calculate Sample Files folder
            string _sampleFolder = HttpContext.Current.Server.MapPath("~/ISPAdmin/SampleData/SampleFiles");

            // Open the database con
            SqlConnection con = new SqlConnection(CommunityGlobals.ConnectionString);
            con.Open();

            // First, let's get the list of sample tables
            DataTable dtblSampleTables = new DataTable();
            SqlDataAdapter dadSample = new SqlDataAdapter("Community_MaintenanceGetSampleTables", con);
            dadSample.SelectCommand.CommandType = CommandType.StoredProcedure;
            dadSample.Fill(dtblSampleTables);

            // Now, loop through each sample table loading corresponding XML file
            DataSet dstSampleData;
            SqlDataAdapter dadLoadSampleData;
            SqlCommandBuilder builder;
            SqlCommand cmdTruncate;
            
            string _sampleTableName;
            string _select;
            string _truncate;
            foreach (DataRow row in dtblSampleTables.Rows) {
                _sampleTableName = (string)row["st_sampleTable"];
                _select = "Select * from " + _sampleTableName;
                _truncate = "Truncate Table " + _sampleTableName;
                
                // load sample data
                dstSampleData = new DataSet();
                dstSampleData.ReadXml(String.Format("{0}\\{1}.xml",_sampleFolder, _sampleTableName ));
            
                // truncate existing sample data
                cmdTruncate = new SqlCommand(_truncate, con);
                cmdTruncate.ExecuteNonQuery();
            
                // update db with sample data
                dadLoadSampleData = new SqlDataAdapter(_select, con);
                builder = new SqlCommandBuilder(dadLoadSampleData);
                dadLoadSampleData.Update(dstSampleData);
            }
            
            // Now fix the offsets
            SqlCommand cmdFixOffset = new SqlCommand("Community_MaintenanceFixSampleOffset", con);
            cmdFixOffset.CommandType = CommandType.StoredProcedure;
            cmdFixOffset.ExecuteNonQuery();
            
            // Close the database connection
            con.Close();
        }



    }
}