public async Task <ModelMenuF2_InterfaceData> MenuF2InterfaceDataAsync(string RegisterId, string UserGroup)
{
ModelMenuF2_InterfaceData resp = new ModelMenuF2_InterfaceData();
ModelMenuF2_InterfaceData search_data = new ModelMenuF2_InterfaceData();
search_data.usergroup = UserGroup;
resp.listdata = await GetAllReportDataF2Async(search_data);
resp.UserPermission = await _IRegisterUserRepository.GetPermissionPageAsync(RegisterId, "M024");
return(resp);
}
public async Task <IActionResult> GetAllReportDataF2(ModelMenuF2_InterfaceData SearchData)
{
IList <ModelMenuF2Report> e = await _IDocMenuFService.GetAllReportDataF2Async(SearchData);
if (e != null)
{
return(Ok(e));
}
else
{
return(BadRequest());
}
}
public async Task <IActionResult> MenuF2InterfaceData(string RegisterId, string UserGroup)
{
ModelMenuF2_InterfaceData e = await _IDocMenuFService.MenuF2InterfaceDataAsync(RegisterId, UserGroup);
if (e != null)
{
return(Ok(e));
}
else
{
return(BadRequest());
}
}
public async Task <IList <ModelMenuF2Report> > GetAllReportDataF2Async(ModelMenuF2_InterfaceData search_data)
{
string sql = "SELECT B.name as group_name, C.*, A.* " +
"FROM [dbo].[SYS_Permission] A " +
"LEFT OUTER JOIN[dbo].[SYS_UserGroup] B ON A.user_group_code = B.code " +
"LEFT OUTER JOIN[dbo].[SYS_MenuPages] C ON A.menu_page_code = C.code " +
"WHERE 1=1 ";
if (search_data != null && !string.IsNullOrEmpty(search_data.usergroup))
{
sql += " AND (user_group_code ='" + search_data.usergroup + "') ";
}
sql += " ORDER BY B.name, C.code ASC ";
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand command = new SqlCommand(sql, conn))
{
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
int row_count = 1;
IList <ModelMenuF2Report> e = new List <ModelMenuF2Report>();
while (await reader.ReadAsync())
{
ModelMenuF2Report item = new ModelMenuF2Report();
item.usergroupname = reader["group_name"].ToString();
item.menupagecode = reader["menu_page_code"].ToString();
item.menupagename = reader["name"].ToString();
item.pmview = (Convert.ToBoolean(reader["pm_view"]) == true) ? "YES" : "";
item.pminsert = (Convert.ToBoolean(reader["pm_insert"]) == true) ? "YES" : "";
item.pmupdate = (Convert.ToBoolean(reader["pm_update"]) == true) ? "YES" : "";
item.pmprint = (Convert.ToBoolean(reader["pm_print"]) == true) ? "YES" : "";
item.pmalldata = (Convert.ToBoolean(reader["pm_all_data"]) == true) ? "YES" : "";
item.isactive = reader["IsActive"].ToString();
e.Add(item);
row_count++;
}
return(e);
}
}
conn.Close();
}
return(null);
}
public async Task<IActionResult> GetAllReportDataF2(ModelMenuF2_InterfaceData SearchData)
{
var requestUri = $"{_WebApiModel.BaseURL}/{"PrivateDocMenuF"}/{"GetAllReportDataF2"}";
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, SearchData);
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);
}
}
public async Task <IList <ModelMenuF2Report> > GetAllReportDataF2Async(ModelMenuF2_InterfaceData search_data)
{
return(await _IDocMenuF2Repository.GetAllReportDataF2Async(search_data));
}
