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