public async Task <IList <ModelMenuF1Report> > GetAllReportDataF1Async(ModelMenuF1_InterfaceData search_data) { string sql = "SELECT A.*, (B.name_thai) AS position_name_thai, " + "(C.name_thai) AS faculty_name_thai, (D.name_thai) AS education_name_thai, " + "(E.name_thai) AS character_name_thai " + "FROM RegisterUser A " + "INNER JOIN MST_Position B ON A.position = B.id " + "INNER JOIN MST_Faculty C ON A.faculty = C.id " + "INNER JOIN MST_Education D ON A.education = D.id " + "INNER JOIN MST_Character E ON A.character = E.id " + "WHERE 1=1 "; if (search_data != null && !string.IsNullOrEmpty(search_data.searchkey)) { sql += " AND (register_id LIKE '%" + search_data.searchkey + "%' OR email LIKE '%" + search_data.searchkey + "%' OR full_name LIKE '%" + search_data.searchkey + "%') "; } sql += " ORDER BY full_name 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 <ModelMenuF1Report> e = new List <ModelMenuF1Report>(); while (await reader.ReadAsync()) { ModelMenuF1Report item = new ModelMenuF1Report(); item.registerid = reader["register_id"].ToString(); item.userid = reader["userid"].ToString(); item.fullname = reader["first_name"].ToString() + reader["full_name"].ToString(); item.email = reader["email"].ToString(); item.registerdate = Convert.ToDateTime(reader["register_date"]).ToString("dd/MM/yyyy"); item.registerexpire = Convert.ToDateTime(reader["register_expire"]).ToString("dd/MM/yyyy"); item.positionname = reader["position_name_thai"].ToString(); item.facultyname = reader["faculty_name_thai"].ToString(); item.educationname = reader["education_name_thai"].ToString(); item.charactername = reader["character_name_thai"].ToString(); item.workphone = reader["work_phone"].ToString(); item.mobile = reader["mobile"].ToString(); item.fax = reader["fax"].ToString(); item.isactive = reader["IsActive"].ToString(); e.Add(item); row_count++; } return(e); } } conn.Close(); } return(null); }
public async Task <ModelMenuF1_InterfaceData> MenuF1InterfaceDataAsync(string RegisterId) { ModelMenuF1_InterfaceData resp = new ModelMenuF1_InterfaceData(); resp.listdata = await GetAllReportDataF1Async(null); resp.UserPermission = await _IRegisterUserRepository.GetPermissionPageAsync(RegisterId, "M023"); return(resp); }
public async Task <IActionResult> GetAllReportDataF1(ModelMenuF1_InterfaceData SearchData) { IList <ModelMenuF1Report> e = await _IDocMenuFService.GetAllReportDataF1Async(SearchData); if (e != null) { return(Ok(e)); } else { return(BadRequest()); } }
public async Task <IActionResult> MenuF1InterfaceData(string RegisterId) { ModelMenuF1_InterfaceData e = await _IDocMenuFService.MenuF1InterfaceDataAsync(RegisterId); if (e != null) { return(Ok(e)); } else { return(BadRequest()); } }
public async Task<IActionResult> GetAllReportDataF1(ModelMenuF1_InterfaceData SearchData) { var requestUri = $"{_WebApiModel.BaseURL}/{"PrivateDocMenuF"}/{"GetAllReportDataF1"}"; 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 <ModelMenuF1Report> > GetAllReportDataF1Async(ModelMenuF1_InterfaceData search_data) { return(await _IDocMenuF1Repository.GetAllReportDataF1Async(search_data)); }