public IEnumerable <string> Get()
{
// getting back the reporttypes from the database table( ReportTypes)
using (var repo = new ReportRepoClass())
{
logData.Info("Getting Report Types from db");
try
{
List <string> reportTypeList = new List <string>();
var results = repo.get();
foreach (var reporttype in results)
{
reportTypeList.Add(reporttype.ReportName);
}
logData.Info("Getting Report Types Finished");
return(reportTypeList);
}
catch (SqlException odbcEx)
{
Debug.WriteLine(odbcEx.Message);
logData.Error(odbcEx.Message);
return(null);
}
}
}
// POST: api/UploadFile
public HttpResponseMessage Post()
{
logData.Info("Uploading all files started");
try
{
for (var i = 0; i < HttpContext.Current.Request.Files.Count; i++)
{
HttpPostedFile file = HttpContext.Current.Request.Files.Get(i);
var fileJsonMeta = HttpContext.Current.Request[$"file-metadata-{i}"];
Debug.WriteLine(fileJsonMeta);
using (var memoryStream = new MemoryStream())
{
bool fileExists = false;
var fileStream = file.InputStream;
SHA1Managed sha = new SHA1Managed();
byte[] checksum = sha.ComputeHash(fileStream);
string sendCheckSum = BitConverter.ToString(checksum)
.Replace("-", string.Empty);
/* using(var repo= new ReportRepoClass())
* {
* repo.checkIfFileExists(fileJsonMeta, sendCheckSum);
* }*/
fileStream.Position = 0;
fileStream.CopyTo(memoryStream);
var serializedFile = memoryStream.ToArray();
Debug.WriteLine(serializedFile);
using (var repo = new ReportRepoClass())
{
// sending the report and metadata to the database.
repo.sendToReportFile(serializedFile, fileJsonMeta, sendCheckSum);
}
}
}
logData.Info("Uploading all files ending");
return(new HttpResponseMessage(HttpStatusCode.Accepted));
}
catch (Exception ex)
{
logData.Error(ex.Message);
Console.WriteLine(ex.Message);
}
return(null);
}
