private DataTable ConvertCCMExcelToDataTable(System.Web.HttpPostedFileBase postedFile)
{
IFileProvider fileProvider = new FileSystemProvider();
IExcelFactory excelFactory = new ExcelFactory();
CurrentInfo objCurInfo = new CurrentInfo();
string containerName = objCurInfo.GetCompanyCode().ToLower();
string fileName = postedFile.FileName;
string[] excelRetrieveColumns = new string[] { "Row_No", "Customer_Name", "Sur_Name", "Speciality_Name", "Gender", "Qualification", "Address1",
"Address2", "Local_Area", "Pin_Code", "City", "State", "Country", "Phone", "Mobile", "Fax", "Email", "Hospital_Name", "Hospital_Classification",
"DOB", "Anniversary_Date", "Registration_No" };
_CCMExcelTemplateFileName = fileProvider.GetFilePathToSave(UPLOAD_PATH_KEY_NAME, fileName);
string whereQuery = " LEN(Customer_Name) >0 ";
DataControl.Repository.AzureBlobUpload objAzureUpload = new Repository.AzureBlobUpload();
DataControl.Abstraction.IFileProvider objPathProv = new DataControl.Impl.FileSystemProvider();
string accKey = objPathProv.GetConfigValue("UPLOADEDFILEBLOBACCKEY");
string blobURL = objAzureUpload.PutAzureBlobStorage(postedFile.InputStream, postedFile.FileName, accKey, containerName);
System.IO.Stream stream = objAzureUpload.AzureblockDownload(postedFile.FileName, accKey, containerName);
DataTable dt = new DataTable();
dt = objAzureUpload.ConvertStreamToDataTable(stream, "Customer_Name");
return(dt);
}
public string UploadAttachment()
{
var result = "";
try
{
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls12;
var objAzureUpload = new DataControl.Repository.AzureBlobUpload();
var objPathProv = new DataControl.Impl.FileSystemProvider();
string accKey = objPathProv.GetConfigValue("UPLOADEDFILEBLOBACCKEY");
HttpFileCollectionBase files = Request.Files;
if (files.Count > 0)
{
for (var i = 0; i < files.Count; i++)
{
HttpPostedFileBase fileUpload = files[i];
String fileNametimeStamp = DateTime.Now.ToString("ddMMyyyyHHmmssfff");
fileNametimeStamp = fileNametimeStamp + '_' + fileUpload.FileName;
string containerName = "ORDERSHIPMENT";
result = objAzureUpload.PutAzureBlobStorage(fileUpload.InputStream, fileNametimeStamp, accKey, containerName);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
