public async Task <ModelRegisterData> GetRegisterUserDataAsync(string register_id) { string register_id_ = Encoding.UTF8.GetString(Convert.FromBase64String(register_id)); string sql = "SELECT A.register_id, A.first_name, A.full_name, A.work_phone, A.mobile, B.name_thai as position_name " + "FROM RegisterUser A INNER JOIN MST_Character B ON A.position = B.id " + "WHERE register_id='" + register_id_ + "'"; using (SqlConnection conn = new SqlConnection(ConnectionString)) { conn.Open(); using (SqlCommand command = new SqlCommand(sql, conn)) { SqlDataReader reader = await command.ExecuteReaderAsync(); if (reader.HasRows) { ModelRegisterData e = new ModelRegisterData(); while (await reader.ReadAsync()) { e.registerid = reader["register_id"].ToString(); e.fullname = reader["first_name"].ToString() + " " + reader["full_name"].ToString(); e.positionname = reader["position_name"].ToString(); } return(e); } } conn.Close(); } return(null); }
public async Task <IActionResult> GetRegisterUserData(string RegisterId) { ModelRegisterData e = await _IDocMenuCService.GetRegisterUserDataAsync(RegisterId); if (e != null) { return(Ok(e)); } else { return(BadRequest()); } }