/// <summary>
///
/// </summary>
/// <param name="address"></param>
/// <param name="name"></param>
public static void CreateContainer(string name)
{
using (OleDbConnection objConnection = SQLDatabaseHelper.GetConnection())
{
OleDbCommand myCommandd = new OleDbCommand("insert into [container](ContainerName) values ( '" + name + "')", objConnection);
myCommandd.ExecuteNonQuery();
}
}
/// <summary>
///
/// </summary>
/// <param name="address"></param>
/// <param name="ID"></param>
public static void Delete(string ID)
{
using (OleDbConnection objConnection = SQLDatabaseHelper.GetConnection())
{
OleDbCommand myCommandd = new OleDbCommand("delete from [storage] where id = " + ID, objConnection);
myCommandd.ExecuteNonQuery();
}
}
/// <summary>
///
/// </summary>
/// <param name="fileName"></param>
/// <param name="size"></param>
/// <param name="fileType"></param>
/// <param name="isPublished"></param>
/// <param name="ContainerID"></param>
public static void Create(string fileName, int size, string fileType, bool isPublished, int ContainerID)
{
using (OleDbConnection objConnection = SQLDatabaseHelper.GetConnection())
{
string sql = string.Format("insert into [storage]([Name],[Size],[Type],[IsPublished],[ContainerID]) values ( '{0}',{1},'{2}',{3},{4})", fileName, size, fileType, isPublished, ContainerID);
OleDbCommand myCommandd = new OleDbCommand(sql, objConnection);
myCommandd.ExecuteNonQuery();
}
}
public static void DeleteStorageItem(string containerName, string storageItemName)
{
using (OleDbConnection objConnection = SQLDatabaseHelper.GetConnection())
{
OleDbCommand command = new OleDbCommand("DELETE from [storage] where [storage].[Name]='" + storageItemName +
"' and [storage].[ContainerID] IN (SELECT [ID] from [container] where [container].[ContainerName] = '" + containerName + "')",
objConnection);
command.ExecuteNonQuery();
}
}
/// <summary>
///
/// </summary>
/// <param name="address"></param>
/// <returns></returns>
public static DataSet Select()
{
using (OleDbConnection objConnection = SQLDatabaseHelper.GetConnection())
{
OleDbDataAdapter myCommandd = new OleDbDataAdapter(
"select [storage].[ID],[storage].[Name],[storage].[Size],[storage].[Type],[container].[CDNUri],[storage].[IsPublished],[container].[ContainerName] from [storage],[container] where [storage].[ContainerID] = [container].[ID]", objConnection);
DataSet ds = new DataSet();
myCommandd.Fill(ds);
return(ds);
}
}
/// <summary>
///
/// </summary>
/// <param name="containerName"></param>
/// <summary>
///
/// </summary>
/// <param name="containerName"></param>
public static void MakeContainerPrivate(string containerName)
{
string sqlContainerName = containerName.Replace("'", "''");
using (OleDbConnection objConnection = SQLDatabaseHelper.GetConnection())
{
OleDbCommand myCommandd = new OleDbCommand(
"update [container] set IsPublished = false, CDNUri = '' where [container].[ContainerName]='"
+ sqlContainerName + "'", objConnection);
myCommandd.ExecuteNonQuery();
}
}
/// <summary>
///
/// </summary>
/// <param name="name"></param>
/// <param name="containerID"></param>
/// <returns></returns>
public static int ContainerIncludeFile(string name, int containerID)
{
using (OleDbConnection objConnection = SQLDatabaseHelper.GetConnection())
{
OleDbCommand command = new OleDbCommand("select * from [storage] where [storage].[Name]='" + name + "' and [storage].[ContainerID]= " + containerID, objConnection);
OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
return(Convert.ToInt32(reader[0].ToString()));
}
return(-1);
}
}
/// <summary>
///
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public static int SelectContainerID(string name)
{
using (OleDbConnection objConnection = SQLDatabaseHelper.GetConnection())
{
OleDbCommand command = new OleDbCommand("select [container].[ID],[container].[ContainerName] from [container] where ContainerName='" + name + "'", objConnection);
OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
return(Convert.ToInt32(reader[0].ToString()));
}
return(-1);
}
}
public static bool GetContainerStatus(string containerName)
{
bool isPublished = false;
using (OleDbConnection objConnection = SQLDatabaseHelper.GetConnection())
{
OleDbCommand cmm = new OleDbCommand("select IsPublished from [container] where ContainerName='" + containerName + "'", objConnection);
OleDbDataReader reader = cmm.ExecuteReader();
while (reader.Read())
{
isPublished = Convert.ToBoolean(reader[0].ToString());
}
}
return(isPublished);
}
public static List <string> GetPublicContainers()
{
List <string> containers = new List <string>();
using (OleDbConnection objConnection = SQLDatabaseHelper.GetConnection())
{
OleDbCommand cmm = new OleDbCommand("Select ContainerName from [container] where IsPublished=TRUE", objConnection);
OleDbDataReader reader = cmm.ExecuteReader();
while (reader.Read())
{
containers.Add(reader["ContainerName"].ToString());
}
}
return(containers);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public static List <string> GetAllContainerNames()
{
List <string> containerList = new List <string>();
using (OleDbConnection objConnection = SQLDatabaseHelper.GetConnection())
{
OleDbDataAdapter myCommandd = new OleDbDataAdapter("select [container].[ContainerName] from [container]", objConnection);
DataSet ds = new DataSet();
myCommandd.Fill(ds);
foreach (DataRow dt in ds.Tables[0].Rows)
{
string containerName = dt["ContainerName"].ToString();
containerList.Add(containerName);
}
}
return(containerList);
}
public static void DeleteContainer(string containerName)
{
using (OleDbConnection objConnection = SQLDatabaseHelper.GetConnection())
{
// First delete the container's storage items (if any)
string sql = "DELETE from [storage] where " +
"[storage].[ContainerID] IN (SELECT [ID] from [container] where [container].[ContainerName] = '" + containerName + "')";
using (OleDbCommand command = new OleDbCommand(sql, objConnection))
{
command.ExecuteNonQuery();
}
// Now delete the container itself
sql = "DELETE FROM [container] where [container].[ContainerName] = '" + containerName + "'";
using (OleDbCommand command = new OleDbCommand(sql, objConnection))
{
command.ExecuteNonQuery();
}
}
}
public static List <string> GetStorageItems(string containerName)
{
containerName = containerName.Replace("'", "''");
List <string> storageItemList = new List <string>();
using (OleDbConnection objConnection = SQLDatabaseHelper.GetConnection())
{
OleDbDataAdapter myCommand = new OleDbDataAdapter(
"select [storage].[Name] from [storage], [container] where [storage].ContainerID = [container].ID and [container].ContainerName = '" + @containerName + "'", objConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds);
foreach (DataRow dt in ds.Tables[0].Rows)
{
string itemName = dt["Name"].ToString();
storageItemList.Add(itemName);
}
}
return(storageItemList);
}