?? adminutility.cs
字號:
cmdEdit.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
cmdEdit.Parameters.Add("@messageName", messageName);
cmdEdit.Parameters.Add("@messageTitle", messageTitle);
cmdEdit.Parameters.Add("@messageBody", messageBody);
conPortal.Open();
cmdEdit.ExecuteNonQuery();
conPortal.Close();
}
// *********************************************************************
// Edit Service Methods
// *********************************************************************
public static void DeleteService(string name)
{
SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
SqlCommand cmd = new SqlCommand( "Community_AdminDeleteService", conPortal );
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
cmd.Parameters.Add("@name", name);
conPortal.Open();
cmd.ExecuteNonQuery();
conPortal.Close();
}
public static void RefreshService(string name)
{
ServiceUtility.UpdateServiceRefreshDate(name,System.DateTime.Parse("1/1/1966"));
}
public static int AddService(ServiceInfo service)
{
SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
SqlCommand cmd = new SqlCommand( "Community_AdminAddService", conPortal );
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
cmd.Parameters.Add("@name", service.Name);
cmd.Parameters.Add("@url", service.Url);
cmd.Parameters.Add("@type", service.Type);
cmd.Parameters.Add("@refreshRate", service.RefreshRate);
cmd.Parameters.Add("@maximumItems", service.MaximumItems);
cmd.Parameters.Add("@password", service.Password);
conPortal.Open();
cmd.ExecuteNonQuery();
int result = (int)cmd.Parameters["@RETURN_VALUE"].Value;
conPortal.Close();
return result;
}
public static int EditService(ServiceInfo service)
{
SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
SqlCommand cmd = new SqlCommand( "Community_AdminEditService", conPortal );
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
cmd.Parameters.Add("@id", service.ID);
cmd.Parameters.Add("@name", service.Name);
cmd.Parameters.Add("@url", service.Url);
cmd.Parameters.Add("@type", service.Type);
cmd.Parameters.Add("@refreshRate", service.RefreshRate);
cmd.Parameters.Add("@maximumItems", service.MaximumItems);
cmd.Parameters.Add("@password", service.Password);
conPortal.Open();
cmd.ExecuteNonQuery();
int result = (int)cmd.Parameters["@RETURN_VALUE"].Value;
conPortal.Close();
return result;
}
// *********************************************************************
// Edit Service Subscriptions Methods
// *********************************************************************
public static int AddServiceSubscription(ServiceSubscriptionInfo service)
{
SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
SqlCommand cmd = new SqlCommand( "Community_AdminAddServiceSubscription", conPortal );
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
cmd.Parameters.Add("@name", service.Name);
cmd.Parameters.Add("@url", service.Url);
cmd.Parameters.Add("@password", service.Password);
conPortal.Open();
cmd.ExecuteNonQuery();
int result = (int)cmd.Parameters["@RETURN_VALUE"].Value;
conPortal.Close();
return result;
}
public static int EditServiceSubscription(ServiceSubscriptionInfo service)
{
SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
SqlCommand cmd = new SqlCommand( "Community_AdminEditServiceSubscription", conPortal );
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
cmd.Parameters.Add("@id", service.ID);
cmd.Parameters.Add("@name", service.Name);
cmd.Parameters.Add("@url", service.Url);
cmd.Parameters.Add("@password", service.Password);
conPortal.Open();
cmd.ExecuteNonQuery();
int result = (int)cmd.Parameters["@RETURN_VALUE"].Value;
conPortal.Close();
return result;
}
public static void DeleteServiceSubscription(string subscriptionName)
{
SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
SqlCommand cmd = new SqlCommand( "Community_AdminDeleteServiceSubscription", conPortal );
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
cmd.Parameters.Add("@subscriptionName", subscriptionName);
conPortal.Open();
cmd.ExecuteNonQuery();
conPortal.Close();
}
public static void RefreshServiceSubscription(string subscriptionName)
{
SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
SqlCommand cmd = new SqlCommand( "Community_AdminRefreshServiceSubscription", conPortal );
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
cmd.Parameters.Add("@subscriptionName", subscriptionName);
conPortal.Open();
cmd.ExecuteNonQuery();
conPortal.Close();
}
// *********************************************************************
// Newsletter Methods
// *********************************************************************
public static int AddNewsletterTemplate
(
string templateName,
string newsletterSubject,
string newsletterBody,
int newsletterBodyFormat
)
{
SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
SqlCommand cmd = new SqlCommand( "Community_AdminAddNewsletterTemplate", conPortal );
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
cmd.Parameters.Add("@templateName", templateName);
cmd.Parameters.Add("@newsletterSubject", newsletterSubject);
cmd.Parameters.Add("@newsletterBody", newsletterBody);
cmd.Parameters.Add("@newsletterBodyFormat", newsletterBodyFormat);
conPortal.Open();
cmd.ExecuteNonQuery();
int result = (int)cmd.Parameters["@RETURN_VALUE"].Value;
conPortal.Close();
return result;
}
public static void EditNewsletterTemplate
(
int templateID,
string templateName,
string newsletterSubject,
string newsletterBody,
int newsletterBodyFormat
)
{
SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
SqlCommand cmd = new SqlCommand( "Community_AdminEditNewsletterTemplate", conPortal );
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
cmd.Parameters.Add("@templateID", templateID);
cmd.Parameters.Add("@templateName", templateName);
cmd.Parameters.Add("@newsletterSubject", newsletterSubject);
cmd.Parameters.Add("@newsletterBody", newsletterBody);
cmd.Parameters.Add("@newsletterBodyFormat", newsletterBodyFormat);
conPortal.Open();
cmd.ExecuteNonQuery();
conPortal.Close();
}
public static void DeleteTemplate
(
int templateID
)
{
SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
SqlCommand cmd = new SqlCommand( "Community_AdminDeleteNewsletterTemplate", conPortal );
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
cmd.Parameters.Add("@templateID", templateID);
conPortal.Open();
cmd.ExecuteNonQuery();
conPortal.Close();
}
public static SqlDataReader GetNewsletterTemplateNames()
{
SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
SqlCommand cmdGet = new SqlCommand( "Community_AdminGetNewsletterTemplateNames", conPortal );
cmdGet.CommandType = CommandType.StoredProcedure;
cmdGet.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
conPortal.Open();
SqlDataReader dr = cmdGet.ExecuteReader(CommandBehavior.CloseConnection);
return dr;
}
public static DataSet GetNewsletterSubjects()
{
SqlDataAdapter dadGet = new SqlDataAdapter( "Community_AdminGetNewsletterSubjects", CommunityGlobals.ConnectionString );
dadGet.SelectCommand.CommandType = CommandType.StoredProcedure;
dadGet.SelectCommand.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
DataSet dstNewsletters = new DataSet();
dadGet.Fill(dstNewsletters);
return dstNewsletters;
}
public static SqlDataReader GetNewsletterTemplate(int templateID)
{
SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
SqlCommand cmdGet = new SqlCommand( "Community_AdminGetNewsletterTemplate", conPortal );
cmdGet.CommandType = CommandType.StoredProcedure;
cmdGet.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
cmdGet.Parameters.Add("@templateID", templateID);
conPortal.Open();
SqlDataReader dr = cmdGet.ExecuteReader(CommandBehavior.CloseConnection);
return dr;
}
public static int AddNewsletter
(
string newsletterSubject,
string newsletterBody,
int newsletterBodyFormat
)
{
SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
SqlCommand cmd = new SqlCommand( "Community_AdminAddNewsletter", conPortal );
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
cmd.Parameters.Add("@newsletterSubject", newsletterSubject);
cmd.Parameters.Add("@newsletterBody", newsletterBody);
cmd.Parameters.Add("@newsletterBodyFormat", newsletterBodyFormat);
conPortal.Open();
cmd.ExecuteNonQuery();
int result = (int)cmd.Parameters["@RETURN_VALUE"].Value;
conPortal.Close();
return result;
}
// *********************************************************************
// Delete Community Content
// *********************************************************************
public static void DeleteCommunityContent(string username, bool deleteContent, bool deleteSections, bool deleteUsers)
{
SqlConnection con = new SqlConnection(CommunityGlobals.ConnectionString);
SqlCommand cmd = new SqlCommand("Community_AdminDeleteContent", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add( "@communityID", CommunityGlobals.CommunityID);
cmd.Parameters.Add( "@username", username);
cmd.Parameters.Add( "@content", deleteContent);
cmd.Parameters.Add( "@sections", deleteSections);
cmd.Parameters.Add( "@users", deleteUsers);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
// Remove Sections from Cache
if (deleteSections)
HttpContext.Current.Cache.Remove( CommunityGlobals.CacheKey("Sections") );
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -