using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using Microsoft.AspNetCore.Http; using Microsoft.AspNetCore.Mvc; using Microsoft.AspNetCore.Authorization; using Microsoft.Extensions.Logging; using TTSW.Controllers; using TTSW.EF; using TTSW.Utils; using TTSW.Constant; using TTSW.Common; using TodoAPI2.Models; using System.Data; using Microsoft.Extensions.Configuration; using System.IO; using System.Net; namespace TodoAPI2.Controllers { //[Authorize] [Produces("application/json")] [Route("api/eva_adjust_quota_update_final_status")] public class eva_adjust_quota_update_final_statusController : BaseController { #region Private Variables private ILogger _logger; private Ieva_adjust_quota_update_final_statusService _repository; private Iexternal_employeeService emp; private IConfiguration Configuration { get; set; } #endregion #region Properties #endregion /// /// Default constructure for dependency injection /// /// /// /// /// public eva_adjust_quota_update_final_statusController(ILogger logger, Ieva_adjust_quota_update_final_statusService repository, IConfiguration configuration, Iexternal_employeeService inemp) { _logger = logger; _repository = repository; Configuration = configuration; emp = inemp; } /// /// Get specific item by id /// /// /// /// Return Get specific item by id /// Returns the item /// Error Occurred [HttpGet("{id}")] [ProducesResponseType(typeof(eva_adjust_quota_update_final_statusWithSelectionViewModel), 200)] [ProducesResponseType(400)] [ProducesResponseType(500)] //[ValidateAntiForgeryToken] public IActionResult Get(int id) { try { if (!MyHelper.checkAuth(Configuration, HttpContext)) return Unauthorized(); var result = _repository.GetWithSelection(id); return Ok(result); } catch (Exception ex) { _logger.LogCritical($"Exception in IActionResult Get.", ex); return StatusCode(500, $"{ex.Message}"); } } /// /// Get Blank Item /// /// /// /// Return a blank item /// Returns the item /// Error Occurred [HttpGet("GetBlankItem")] [ProducesResponseType(typeof(eva_adjust_quota_update_final_statusWithSelectionViewModel), 200)] [ProducesResponseType(400)] [ProducesResponseType(500)] //[ValidateAntiForgeryToken] public IActionResult GetBlankItem() { try { if (!MyHelper.checkAuth(Configuration, HttpContext)) return Unauthorized(); var result = _repository.GetBlankItem(); return Ok(result); } catch (Exception ex) { _logger.LogCritical($"Exception in IActionResult GetBlankItem.", ex); return StatusCode(500, $"{ex.Message}"); } } /// /// Get list items by quota_final_status_note /// /// /// /// Return list of items by specifced keyword /// Returns the item /// Error Occurred [HttpGet("")] [ProducesResponseType(typeof(List), 200)] [ProducesResponseType(400)] [ProducesResponseType(500)] //[ValidateAntiForgeryToken] public IActionResult GetList(string quota_final_status_note) { try { if (!MyHelper.checkAuth(Configuration, HttpContext)) return Unauthorized(); return Ok(_repository.GetListByquota_final_status_note(quota_final_status_note)); } catch (Exception ex) { _logger.LogCritical($"Exception in IActionResult GetList.", ex); return StatusCode(500, $"{ex.Message}"); } } /// /// Get list items by search /// /// /// /// Return list of items by specifced keyword /// Returns the item /// Error Occurred [HttpGet("GetListBySearch")] [ProducesResponseType(typeof(List), 200)] [ProducesResponseType(400)] [ProducesResponseType(500)] //[ValidateAntiForgeryToken] public IActionResult GetListBySearch(eva_adjust_quota_update_final_statusSearchModel model) { try { if (!MyHelper.checkAuth(Configuration, HttpContext)) return Unauthorized(); return Ok(_repository.GetListBySearch(model)); } catch (Exception ex) { _logger.LogCritical($"Exception in IActionResult GetListBySearch.", ex); return StatusCode(500, $"{ex.Message}"); } } /// /// Download Report /// /// /// /// Return list of items by specifced keyword /// Returns the item /// Error Occurred [HttpGet("eva_adjust_quota_update_final_status_report")] [ProducesResponseType(typeof(FileStreamResult), 200)] [ProducesResponseType(400)] [ProducesResponseType(500)] //[ValidateAntiForgeryToken] public IActionResult eva_adjust_quota_update_final_status_report(eva_adjust_quota_update_final_statusReportRequestModel model) { try { if (!MyHelper.checkAuth(Configuration, HttpContext)) return Unauthorized(); var httpclient = new WebClient(); string mainurl = MyHelper.GetConfig(Configuration, "JasperReportServer:MainURL"); string reportsite = MyHelper.GetConfig(Configuration, "JasperReportServer:reportsite"); string username = MyHelper.GetConfig(Configuration, "JasperReportServer:username"); string password = MyHelper.GetConfig(Configuration, "JasperReportServer:password"); string url = $"{mainurl}{reportsite}/xxใส่ชื่อรายงานตรงนี้xx.{model.filetype}?{MyHelper.GetParameterForJasperReport(model)}&j_username={username}&j_password={password}"; if (model.filetype == "xlsx") { url += "&ignorePagination=true"; } var data = httpclient.DownloadData(url); var stream = new MemoryStream(data); return File(stream, model.contentType); } catch (Exception ex) { _logger.LogCritical($"Exception while GetReport.", ex); return StatusCode(500, $"{ex.Message}"); } } /// /// Update item /// /// /// /// /// /// Response Result Message /// Response Result Message /// If the model is invalid /// Error Occurred [HttpPut("{id}")] [ProducesResponseType(typeof(CommonResponseMessage), 200)] [ProducesResponseType(400)] [ProducesResponseType(500)] //[ValidateAntiForgeryToken] public IActionResult Update(int id, [FromBody] eva_adjust_quota_update_final_statusInputModel model) { if (ModelState.IsValid) { try { if (!MyHelper.checkAuth(Configuration, HttpContext)) return Unauthorized(); int? e = null; if (!string.IsNullOrEmpty(HttpContext.Request.Cookies["user_id"])) { var loginid = Convert.ToInt32(HttpContext.Request.Cookies["user_id"]); var theEmp = emp.GetEmployeeForLogin(Convert.ToInt32(loginid)); if (theEmp != null) { e = theEmp.id; } else { return Unauthorized(); } } else { return Unauthorized(); } var result = _repository.Update(id, model, true, e); var message = new CommonResponseMessage(); message.code = "200"; message.message = $"แก้ไขข้อมูล เรียบร้อย"; message.data = result; return Ok(message); } catch (Exception ex) { _logger.LogCritical($"Exception while update {id.ToString()}.", ex); return StatusCode(500, $"{id.ToString()}. {ex.Message}"); } } return BadRequest(ModelState); } } }