/// <summary>
/// Save User specific API Info to Database.
/// </summary>
/// <param name="isNew">Is New User's API info?</param>
/// <param name="PartnerCode">Backlot Partner Code</param>
/// <param name="SecretKey">Backlot Secret Key</param>
/// <param name="APIKey">Backlot API Key</param>
/// <param name="UserID">Logged in User</param>
/// <returns>API Info are properly saved in DB or not. </returns>
public static bool SaveConfiguration(string PartnerCode, string SecretKey, string APIKey, string UserID)
{
string queryString = "CreateOrModifyAPISettings";
string ConnectionString = OoyalaConnectStringBuilder.BuildConnectionString();
SqlConnection con = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand(queryString, con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
if (APIKey.IndexOf(".") > 0)
{
PartnerCode = APIKey.Substring(0, APIKey.IndexOf("."));
}
cmd.Parameters.AddWithValue("PartnerCode", PartnerCode);
cmd.Parameters.AddWithValue("SecretKey", SecretKey);
cmd.Parameters.AddWithValue("APIKey", APIKey);
cmd.Parameters.AddWithValue("UserID", UserID);
using (con)
{
con.Open();
return(cmd.ExecuteNonQuery() == 1);
}
}
public static void EnsureChildNode(SPWebApplication webApp)
{
string connectionStringKey = "OoyalaConnectionString";
string connectionStringvalue = OoyalaConnectStringBuilder.BuildConnectionString();
string fileTypeKey = "OoyalaFileType";
string fileTypeValue = InstallConfiguration.OoyalaFileType;
string fileUploadLimitKey = "OoyalaFileUploadLimitInMB";
string fileUploadLimitValue = InstallConfiguration.OoyalaFileUploadLimitInMB;
Configuration config = WebConfigurationManager.OpenWebConfiguration("/", webApp.Name);
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(config.FilePath);
xmlDoc = AddOrModifyAppSettings(xmlDoc, connectionStringKey, connectionStringvalue);
xmlDoc = AddOrModifyAppSettings(xmlDoc, fileTypeKey, fileTypeValue);
xmlDoc = AddOrModifyAppSettings(xmlDoc, fileUploadLimitKey, fileUploadLimitValue);
xmlDoc.Save(config.FilePath);
}