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); }