public BlobStorageDetail GetDataLakeStorageDetails()
{
BlobStorageDetail objBlobStorageDetail = new BlobStorageDetail();
try
{
var sqlHelper = GetDBConnection(2);
DataSet ds = sqlHelper.ExecuteDataSet(Constants.PROC_GetFileStorageDetail, 245020, true, 2200);
if (ds.Tables != null || ds.Tables.Count > 0)
{
DataTable table = ds.Tables[0];
if (table != null || table.Rows.Count > 0)
{
var containerName = table.Rows[0]["FSContainerName"];
if (IsDBNull(containerName))
{
throw new ApplicationException("FSContainerName is blank");
}
objBlobStorageDetail.FSContainerName = containerName.ToString();
var storageKey = table.Rows[0]["STORAGE_KEY"];
if (IsDBNull(storageKey))
{
throw new ApplicationException("STORAGE_KEY is blank");
}
objBlobStorageDetail.StorageKey = storageKey.ToString();
var storageName = table.Rows[0]["STORAGE_NAME"];
if (IsDBNull(storageName))
{
throw new ApplicationException("STORAGE_NAME is blank");
}
objBlobStorageDetail.StorageName = storageName.ToString();
var projectName = table.Rows[0]["Project_Name"];
if (IsDBNull(projectName))
{
throw new ApplicationException("Project_Name is blank");
}
objBlobStorageDetail.ProjectName = projectName.ToString();
}
}
return(objBlobStorageDetail);
}
catch (SqlException ex)
{
//SpendLoggerHelper.LogError(ex, "GetDataLakeStorageDetails", partnerCode, partnerCode, applicationName);
throw new ApplicationException("Error in data operation: ", ex);
}
catch (Exception ex)
{
//SpendLoggerHelper.LogError(ex, "GetDataLakeStorageDetails", partnerCode, partnerCode, applicationName);
throw;
}
}
public async Task <Stream> GetUploadedDoc(string docName = "Master Agreement_Template (1) (1)", string version = "1.0.0.1")
{
BlobStorageDetail blobStorageDetail = _DAO.GetDataLakeStorageDetails();
string storageConnectionString = string.Format("DefaultEndpointsProtocol=https;AccountName={0};AccountKey={1}",
blobStorageDetail.StorageName, blobStorageDetail.StorageKey);
var storageBlob = new StorageBlob(storageConnectionString, blobStorageDetail.FSContainerName);
string filepath = storageBlob.Account.BlobStorageUri.PrimaryUri.AbsoluteUri + blobStorageDetail.FSContainerName + "/Techathon20/12/13/" + docName + "_v" + version + ".docx";
Stream file = await DataLakeHelper.GetFileStreamWithStorageBlob(storageBlob, filepath);
//var parameters = ClientRequestParametersProvider.GetClientParameters(HttpContext, clientId);
return(file);
}
