public ResponseBALCalculate BALCalculate([FromBody] RequestBALCalculate request)
{
try
{
BALBLL bll = new BALBLL();
return(bll.BALCalculate(request));
}
catch (Exception ex)
{
throw new HttpResponseException(
Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public HttpResponseMessage getExcelBySql([FromBody] RequestExcel request)
{
try
{
BALBLL bll = new BALBLL();
//return bll.getExcelBySql(request);
var file = bll.getExcelBySql(request);
HttpResponseMessage response = new HttpResponseMessage(HttpStatusCode.OK);
var stream = new FileStream(file.DirectoryName, FileMode.Open);
response.Content = new StreamContent(stream);
//response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/octet-stream");
response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/vnd.ms-excel");
//response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment")
//{
// FileName = HttpUtility.UrlEncode(Path.GetFileName(FilePath))
//};
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment");
response.Content.Headers.ContentDisposition.FileName = HttpUtility.UrlEncode(Path.GetFileName(file.DirectoryName));
return(response);
}
catch (Exception ex)
{
return(new HttpResponseMessage(HttpStatusCode.NoContent));
}
//try
//{
// BALBLL bll = new BALBLL();
// return bll.getExcelBySql(request);
//}
//catch (Exception ex)
//{
// throw new HttpResponseException(
// Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
//}
}
