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