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);
}
private DataTable ConvertRCPAExcelToDataTable(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[] { "*" };
_employeeExcelTemplateFileName = fileProvider.GetFilePathToSave(UPLOAD_PATH_KEY_NAME, fileName);
string whereQuery = " LEN(Region_Name) >0 ";
// postedFile.SaveAs(_employeeExcelTemplateFileName);
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, "D_Doctor_Name");
return(dt);
}
public void DownloadInwardExcelTemplate()
{
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls12;
DataControl.Repository.FileDownload objFileDownload = new DataControl.Repository.FileDownload();
DataControl.Abstraction.IFileProvider objProvider = new DataControl.Impl.FileSystemProvider();
string error = string.Empty;
string fileName = "BulkInwardUpload.xlsx";
string blobURL = objProvider.GetConfigValue("EXCELTEMPLATES") + fileName;
objFileDownload.DownloadFile(blobURL, fileName, out error);
}
/// <summary>
/// get the selected message details
/// </summary>
/// <param name="msgCode"></param>
/// <returns>returns the selected message details in the form of json </returns>
public string GetSelectedMsgDetails(string msgCode, string TargetAddress)
{
DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
DataControl.BLMessaging objMsg = new DataControl.BLMessaging();
DataControl.JSONConverter objJson = new DataControl.JSONConverter();
DataControl.Repository.AzureBlobUpload objAzureUpload = new DataControl.Repository.AzureBlobUpload();
DataControl.Abstraction.IFileProvider objPathProv = new DataControl.Impl.FileSystemProvider();
string accKey = objPathProv.GetConfigValue("NBFILES");
string blobURL = accKey + objCurInfo.GetCompanyCode().ToLower();
return(objJson.Serialize(objMsg.GetSelectedMsgDetails(objCurInfo.GetCompanyCode(), msgCode, TargetAddress)) + "~" + blobURL);
}