public StoreCloud CreateStoreCloud(string Title, string IDCentity = null)
{
StoreCloud po = null;
try
{
//controles
//if (!NGLib.DATA.FORMAT.StringUtilities.IsValidForXML(form.ti)) throw new Exception("IDStore invalide");
//if (form.IDStore.Length < 8) throw new Exception("IDStore minLength");
// insertion
po = new StoreCloud();
po["IDStore"] = DBNull.Value;
po.Valid = ENUMS.StoreCloudValid.CANCEL;
base.InsertBubble(po, false, true); //,false,true);
// Création
swift.CreateContainer(po.IDStore.ToString());
// Si tous est pret on active
po.Valid = ENUMS.StoreCloudValid.OK;
base.SaveBubble(po);
return(po);
}
catch (Exception ex)
{
throw new Exception("CreateStoreCloud " + ex.Message, ex);
}
}
public StoreCloudItem UploadFile(StoreCloud storeCloud, string VirtualPath, System.IO.Stream Fichier, string newFileName = null)
{
try
{
if (string.IsNullOrWhiteSpace(VirtualPath))
{
VirtualPath = "/"; // alors prendre la catégorie principale du storecloud (virtualpath = / ), jamais vide
}
using (var memoryStream = new MemoryStream())
{
Fichier.CopyTo(memoryStream);
var fich = memoryStream.ToArray();
string id = swift.Upload(storeCloud.IDStore.ToString(), fich);
StoreCloudItem nouveau = new StoreCloudItem();
nouveau["IDItem"] = null;
nouveau.IDPhysicalFile = id;
nouveau.NameFile = newFileName;
nouveau.IDStore = storeCloud.IDStore;
nouveau.VirtualPath = VirtualPath;
// Insert
base.InsertBubble(nouveau, false, true); // usekey=false car incrémenté , getlastautoincrement = true car incrémenté, si c'était des clefs prédéfinis il faudra inverser
return(nouveau);
}
}
catch (Exception ex)
{
throw new Exception("UploadFile " + ex.Message, ex);
}
}
/// <summary>
/// Obtient un cloudStore
/// </summary>
/// <param name="IDStore"></param>
/// <returns></returns>
public StoreCloud GetStoreCloud(int IDStore, bool Complete = true)
{
StoreCloud retour = null;
try
{
// !!! Charger tous les storecloud avec une procstock (plusieur table dans un dataset)
Dictionary <string, object> ins = new Dictionary <string, object>();
ins.Add("p_idstore", IDStore);
System.Data.DataSet ret = this.Connector.QueryDataSet(DefaultProcstockCloud, ins);
if (ret == null || ret.Tables.Count == 0 || ret.Tables[0].Rows.Count == 0)
{
return(null);
}
// -- tables[0] StoreCloud
retour = new StoreCloud(ret.Tables[0].Rows[0]);
// -- tables[1] StoreCloudDirectory
retour.VirtualPaths = NGLib.DATA.DATAPO.DataPOParser.ListFromDataTable <StoreCloudDirectory>(ret.Tables[1]);
// -- tables[2] StoreCloudItem
retour.Items = NGLib.DATA.DATAPO.DataPOParser.ListFromDataTable <StoreCloudItem>(ret.Tables[2]);
}
catch (Exception ex)
{
throw new Exception("GetStoreCloud " + ex.Message, ex);
}
return(retour);
}
public StoreCloudDirectory CreateDirectory(StoreCloud storeCloud, string virtualPath)
{
virtualPath = StoreCloudTools.CorrectVirtualPath(virtualPath);
StoreCloudDirectory dir = null;
try
{
//controles
//if (!NGLib.DATA.FORMAT.StringUtilities.IsValidForXML(form.ti)) throw new Exception("IDStore invalide");
//if (form.IDStore.Length < 8) throw new Exception("IDStore minLength");
// insertion
dir = new StoreCloudDirectory();
dir.IDStore = storeCloud.IDStore.ToString();
dir.VirtualPath = virtualPath;
base.InsertBubble(dir); //,false,true);
//// Création
//swift.CreateContainer(dir.IDStore.ToString());
//// Si tous est pret on active
//dir.Valid = ENUMS.StoreCloudValid.OK;
//base.SaveBubble(dir);
return(dir);
}
catch (Exception ex)
{
throw new Exception("CreateDirectory " + ex.Message, ex);
}
}
public List <string> GetVirtualPath(StoreCloud storeCloud)
{
Dictionary <string, object> ins = new Dictionary <string, object>();
ins.Add("IDStore", storeCloud.IDStore);
string sql = "SELECT DISTINCT VirtualPath FROM storecloud_virtalpaths WHERE VirtualPath is not null and IDStore=@IDStore";
System.Data.DataTable ret = this.Connector.Query(sql, ins);
return((from System.Data.DataRow rw in ret.Rows select rw[0].ToString()).ToList());
}
/// <summary>
/// Telecharger une fichier
/// </summary>
/// <param name="storeCloud">Nom de dossier</param>
/// <param name="IDLocalFile">identifiant de fichier</param>
/// <returns></returns>
public System.IO.Stream DownloadFile(StoreCloud storeCloud, string IDLocalFile)
{
try
{
return(new MemoryStream(swift.Download(storeCloud.IDStore.ToString(), IDLocalFile)));
}
catch (Exception ex)
{
throw new Exception("DownloadFile " + ex.Message, ex);
}
}
public StoreCloudItem UploadFile(StoreCloud storeCloud, string VirtualPath, System.IO.FileInfo Fichier, string newFileName = null)
{
if (string.IsNullOrWhiteSpace(VirtualPath))
{
VirtualPath = "/";
}
VirtualPath = ValidateVirtualPath(VirtualPath);
System.IO.Stream fstream = Fichier.Open(System.IO.FileMode.OpenOrCreate, System.IO.FileAccess.ReadWrite);
if (string.IsNullOrWhiteSpace(newFileName))
{
newFileName = Fichier.Name;
}
return(this.UploadFile(storeCloud, VirtualPath, fstream, newFileName));
}
// !!! Ajouter SaveFile
/// <summary>
///// Telecharger une fichier
///// </summary>
///// <param name="storeCloud">Nom de dossier</param>
///// <param name="IDLocalFile">identifiant de fichier</param>
///// <returns></returns>
//public void SaveFile(StoreCloud storeCloud, string IDLocalFile, System.IO.FileInfo myFile)
//{
// try
// {
// LocalFilerProvider lfProv = new LocalFilerProvider();
// lfProv.SaveFile(storeCloud.IDStore.ToString(), IDLocalFile, myFile);
// }
// catch (Exception ex)
// {
// throw new Exception("SaveFile " + ex.Message, ex);
// }
//}
/// <summary>
/// Supprimer fichier
/// </summary>
/// <param name="containerName">Nom de dossier</param>
/// <param name="IDLocalFile">Id fichier</param>
public void DeleteFile(StoreCloud storeCloud, long IDFile)
{
try
{
StoreCloudItem csi = GetFile(IDFile);
if (csi != null)
{
// swift.Delete(storeCloud.IDStore.ToString(), csi.IDPhysicalFile);
base.DeleteBubble(csi);
}
}
catch (Exception ex)
{
throw new Exception("DeleteFile " + ex.Message, ex);
}
}
/// <summary>
/// Obtenir les fichiers
/// </summary>
/// <param name="category"></param>
/// <param name="CountResultsMax"></param>
/// <returns></returns>
public List <StoreCloudItem> GetItemsByDirectory(StoreCloud storeCloud, string VirtualPath, int CountResultsMax = 100)
{
try
{
Dictionary <string, object> ins = new Dictionary <string, object>();
ins.Add("IDStore", storeCloud.IDStore);
ins.Add("VirtualPath", VirtualPath);
ins.Add("CountResultsMax", CountResultsMax);
string sql = "SELECT * FROM StoreCloud_Items WHERE IDStore=@IDStore AND VirtualPath=@VirtualPath LIMIT @CountResultsMax"; // ORDER BY DateCreate DESC ajouter le a la requette CountResultsMax
System.Data.DataTable ret = this.Connector.Query(sql, ins);
List <StoreCloudItem> retour = NGLib.DATA.DATAPO.DataPOParser.ListFromDataTable <StoreCloudItem>(ret); // transformer DataTable en liste<DataPo>
return(retour);
}
catch (Exception ex)
{
throw new Exception("GetItems " + ex.Message, ex);
}
}
public void deleteDirectory(StoreCloud storeCloud, string virtualPath)
{
virtualPath = StoreCloudTools.CorrectVirtualPath(virtualPath);
StoreCloudDirectory dir = null;
try
{
dir = GetDirectorys(storeCloud.IDStore.ToString(), virtualPath).FirstOrDefault();
var items = GetItemsByDirectory(storeCloud, virtualPath);
var iditems = GetItemsByDirectory(storeCloud, virtualPath).Select(i => i.IDItem);
foreach (var item in iditems)
{
base.DeleteBubble(items.FirstOrDefault(i => i.IDItem == item));
}
base.DeleteBubble(dir);
}
catch (Exception ex)
{
throw new Exception("CreateDirectory " + ex.Message, ex);
}
}