public async Task <IActionResult> GetAllReportHistoryDataR1([FromBody] ModelMenuR1_InterfaceData model) { var requestUri = $"{_WebApiModel.BaseURL}/{"PrivateDocMenuR"}/{"GetAllReportHistoryDataR1"}"; string authHeader = HttpContext.Request?.Headers["Authorization"]; if (authHeader != null && authHeader.StartsWith("Bearer")) { BearerToken = authHeader.Substring("Bearer ".Length).Trim(); } var response = await HttpRequestFactory.Post(requestUri, BearerToken, model); switch (response.StatusCode) { case HttpStatusCode.Unauthorized: return(Unauthorized(response.ContentAsString())); case HttpStatusCode.BadRequest: return(BadRequest(response.ContentAsString())); case HttpStatusCode.OK: return(Ok(response.ContentAsString())); default: return(StatusCode(500)); } }
// ระเบียบวาระที่ 4 ------------------------------------------------------------------------------ public async Task <ModelMenuR1_InterfaceData> MenuR1InterfaceDataAsync(string RegisterId) { ModelMenuR1_InterfaceData resp = new ModelMenuR1_InterfaceData(); resp.ListMeetingId = new List <ModelSelectOption>(); resp.ListMeetingId = await GetAllMeetingIdAsync(); ModelSelectOption all_meeting = new ModelSelectOption() { value = "", label = "เลือก..." }; resp.ListMeetingId.Add(all_meeting); resp.ListMeetingType = await GetAllMeetingTypeAsync(); ModelSelectOption all_meeting_type = new ModelSelectOption() { value = "", label = "เลือก..." }; resp.ListMeetingType.Add(all_meeting_type); resp.ListReportData = await GetAllReportHistoryDataR1Async(null); resp.UserPermission = await _IRegisterUserRepository.GetPermissionPageAsync(RegisterId, "M019"); return(resp); }
public async Task <IActionResult> GetAllReportHistoryDataR1(ModelMenuR1_InterfaceData search) { IList <ModelMenuR1Data> e = await _IDocMenuRService.GetAllReportHistoryDataR1Async(search); if (e != null) { return(Ok(e)); } else { return(BadRequest()); } }
public async Task <IActionResult> MenuR1InterfaceData(string RegisterId) { ModelMenuR1_InterfaceData e = await _IDocMenuRService.MenuR1InterfaceDataAsync(RegisterId); if (e != null) { return(Ok(e)); } else { return(BadRequest()); } }
public async Task <IList <ModelMenuR1Data> > GetAllReportHistoryDataR1Async(ModelMenuR1_InterfaceData search) { string sql = "SELECT B.doc_id, A.meeting_round, A.meeting_year, A.isClose, " + "B.meeting_date, B.meeting_start, B.meeting_close, B.meeting_location, C.name_thai AS meeting_type_name " + "FROM Doc_MeetingRound_Project A " + "LEFT OUTER JOIN [dbo].[Doc_MenuC3] B " + "ON A.meeting_year = B.year_of_meeting AND A.meeting_round = B.meeting_round " + "LEFT OUTER JOIN [dbo].[MST_MeetingRecordType] C ON C.id = B.meeting_record_id " + "WHERE 1=1 "; if (search != null && !string.IsNullOrEmpty(search.meetingid)) { sql += " AND B.doc_id='" + search.meetingid + "' "; } sql += " ORDER BY A.meeting_round DESC"; using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); using (SqlCommand command = new SqlCommand(sql, conn)) { SqlDataReader reader = await command.ExecuteReaderAsync(); if (reader.HasRows) { IList <ModelMenuR1Data> e = new List <ModelMenuR1Data>(); while (await reader.ReadAsync()) { ModelMenuR1Data item = new ModelMenuR1Data(); item.docid = reader["doc_id"].ToString(); item.meetingdate = (string.IsNullOrEmpty(reader["meeting_date"].ToString()) ? "" : Convert.ToDateTime(reader["meeting_date"]).ToString("dd/MM/yyyy")); item.meetinglocation = reader["meeting_location"].ToString(); item.meetingstart = reader["meeting_start"].ToString(); item.meetingclose = reader["meeting_close"].ToString(); item.meetinground = reader["meeting_round"].ToString(); item.yearofmeeting = reader["meeting_year"].ToString(); item.isclosed = Convert.ToBoolean(reader["isClose"]); e.Add(item); } return(e); } } conn.Close(); } return(null); }
public async Task <IList <ModelMenuR1Data> > GetAllReportHistoryDataR1Async(ModelMenuR1_InterfaceData model) { return(await _IDocMenR1Repository.GetAllReportHistoryDataR1Async(model)); }